Skip to main content
kavyam0002
April 7, 2022
Question

between

  • April 7, 2022
  • 6 replies
  • 0 views

Hi,

is their any other alternative to between operator?

bcz am querying data from db.. giving different o/p in UI

same query i have used to query the data from UI so 

 a!queryFilter(
          field: "expiredDays_int",
          operator:"between",
          value: {rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation(
            selectedItemType_txt: 1
          ).startIndex_int,
          rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation(
            selectedItemType_txt: 31
          ).endIndex_int

    6 replies

    stefanhelzle0001
    Brainy
    April 7, 2022

    What is wrong with "between"?

    You can just combine two filters. One with a ">" and another with a "<" operator.

    kavyam0002
    April 7, 2022

    didn't get how to write that .. how can i send the two values to filter 

    i understood your query 

    select * from xyz where id> 1 and id<30 like this but how to write in appian!

    stefanhelzle0001
    Brainy
    April 7, 2022