Greater than equal to not working as expected

Question

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
)

Mike Schmitt · Answer

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.

Greater than equal to not working as expected

Top Replies