How To Get All Power Filters in Classic UI

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

How can power filter expressions be retrieved?

Environment

Release : 16.1.3

Resolution

The following query can be ran:

select * from ODF_FILTER_EXPRESSIONS
order by last_updated_date desc;

Example expressions:
idea.created_date == dateMacro("today")
project.actuals > 0