Hello,
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.
Any inputs?
index( rule!ACO_getCdt( entity: cons!TEST, type: 'type!{urn:com:appian:types:occrcl}Test?list', fields: {"transactionId"}, filters: { rule!ACO_filterEquals(field:"transactionId", value: 501), rule!ACO_filterEquals(field:"isApproved", value:true), rule!ACO_filterEquals(field:"actionId", value:cons!OCC_RCL_REF_TRANSACTION_ACTION_APPROVE_RECLASS_ID), /*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)) } ), "transactionId", {} ) ================================ rule!ACO_filterGreaterThanOrEqualTo(): rule!ACO_queryFilter( field: ri!field, operator: ">=", value: ri!value )
Discussion posts and replies are publicly visible
1. solution use execute stored procedure it will help you.
2. I think the issue you faced is because of datatype of the field approvedOn. I think you have selected it as a string. Please try with datatype date for approvedOn field in this case it must work.
Hope it will help you identify problem