Forum Discussion

ben_pecot_cubic_com's avatar
ben_pecot_cubic_com
Ideator I
4 years ago

How do I set a where statement on a Query Definition against the current date the query is run?

I want to only have it pull a specific relationship (Part AML) if a custom date field "Valid To" is greater than the current date.  I am able to create the Where that compares it against a specific d...
Query Builder
Query Definitions
SQL
ben_pecot_cubic_com's avatar
ben_pecot_cubic_com
Ideator I
3 years ago

I was not able to find a more elegant dynamic solution so instead I have a method that updates the filter on the query definition and added that method to the scheduler.