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

Edit Criteria

dialog box, select the operator IN from the list of operators. Enter the database function as a Select clause in the

Value

field.

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.