Greater than equal to not working as expected

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

Parents
    • Is approvedOn a date or a dateTime?    
    • Have you tried hardcoding a date and seeing if that works ok?
    • Have you tried just writing a separate test expression rule with OOTB functionality rather than the custom filter constructors (just a straight a!query and a!queryFilter?   

    These steps might help you pinpoint if there is an issue on the database side or the custom SAIL code side. 

  • Hello Scoot,

    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

Reply
  • Hello Scoot,

    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

Children