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
angela's avatar
angela
Catalyst II
3 years ago

Hi Ben,

thanks for sharing your test results!

After checking the sample I am not sure if search_container.js is actually used by the QueryBuilder at all. If you set a debugger breakpoint, will it be triggered by the Query?

In worst case we have to customize some file in this folder:  ...\Client\Modules\aras.innovator.QueryBuilder

If you have a subscription maybe ask Aras for this feature. It would definitely be a useful enhancement!