I have a requirement where i need to query ids with approvedOn date greater than or equal to (today - 5) business days.
What i have in place is working only for equal to but not for greater than.
rule!ACO_filterEquals(field:"transactionId", value: 501),
/*constant has -5 value*/
rule!ACO_filterGreaterThanOrEqualTo(field:"approvedOn", value: gmt(todatetime(workday(rule!ACO_today(), cons!OCC_RCL_AWAITING_APPROVAL_FINAL_NOTIFICATION_REMINDER_DAYS)))),
rule!ACO_filterLessThanOrEqualTo(field:"approvedOn", value: gmt(todatetime(workday(rule!ACO_today(), cons!OCC_RCL_AWAITING_APPROVAL_FINAL_NOTIFICATION_REMINDER_DAYS))) + intervalds(23,59,59))
Discussion posts and replies are publicly visible
These steps might help you pinpoint if there is an issue on the database side or the custom SAIL code side.
thanks for the response.
Even when i used general a!queryfilter function inside a!queryentity,
rule!ACO_queryFilter( field: ri!field, operator: ">=", value: gmt(todatetime(workday(rule!ACO_today(), -5)))),
I am only getting exact today - 5 which is 10/08/2020 records but i also want to query which are in-prior like 10/7/2020,10/06/2020 etc.
Greater than equal operator is not returning the values when applied to field
You still need to test this using a straight OOTB queryEntity and queryFilter rule call, because we have no way of knowing, nor any reasonable hope of troubleshooting, the contents of your code constructor functions like rule!ACO_queryFilter.
You also didn't really answer Scott's question, as far as I can tell: is the DB field you're querying on a DATE or DATETIME type? This makes a huge difference when we get into the particulars of querying like this.
If you do want rows that are prior/earlier than the date in the value, then you need your operator to be less than (<=), not greater than (>=).
You are right Scott, i just figured <= alone is enough to do the job.
Thank you so much for the response.
No problem, sometimes it helps a lot to have another pair of eyes with a fresh look at the problem!
© 2021 Appian. All rights reserved.