• State Suggested Answer
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 13 subscribers
  • Views 8295 views
  • Users 0 members are here
Options
Related

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

Ben Pecot
Offline

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 date, but this query definition is pulled by another process automatically and I don't want to have to update the Query Definition every day with the current date for whoever ends up running it that day.

I currently have:

[Valid to] > '2021-11-29T00:00:00'

I want something like (this doesn't work)

[Valid to] > current_date()

Parents
  • 0

    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!

Reply
  • 0

    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!

Children
No Data