You can use database functions in entity filter criteria. To ensure that TDM processes the filter query correctly, you must use the IN operator and a Select clause.
For example, consider filter criteria that uses the add_months database function. Workflow generation fails if the plan contains the query entered directly, as TDM does not recognize this as a database function. TDM is unable to pass the criteria with the database function as is to the database.
To use the filter criteria with a database function, use the IN operator and enter the query with a Select clause.
To add the required filter criteria, in the
dialog box, select the operator IN from the list of operators. Enter the database function as a Select clause in the
select HIREDATE from <table> where HIREDATE > add_months(current_date, -3)
TDM processes the filter criteria correctly and passes the query to the database. The workflow runs successfully with this entity criteria.