between operator not working

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
          }
        )

how can write this query without between operator 

  Discussion posts and replies are publicly visible

  • 0
    Certified Lead Developer
    in reply to KM

    What does "different" mean?

    If the "between" operator does not work the way you need it, you can't use it.

    If the decision returns value you cannot use with "<=" or ">=", you will need to modify the decision, or the returned values.

  • that's what how can i change the decision rule, please help me...

    or is their any other option to come up with other solution 

  • 0
    Certified Lead Developer
    in reply to KM

    I tried to change your code so it picks the first item in the returned list. Please try this.

    a!queryFilter(
              field: "expiredDays_int",
              operator:"<=",
              value: index(
              rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation(
                selectedItemType_txt: ri!selectedItemType_txt
              ).endIndex_int, 1, 0
              ),
              applyWhen: or(
                ri!selectedItemType_txt = cons!CR_CMU_GRID_LABEL_BUCKET_VALUES[1],
                ri!selectedItemType_txt = cons!CR_CMU_GRID_LABEL_BUCKET_VALUES[2],
                ri!selectedItemType_txt = cons!CR_CMU_GRID_LABEL_BUCKET_VALUES[3],
              )
            ),
            a!queryFilter(
              field: "expiredDays_int",
              operator: ">=",
              value: index(
                rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation(
                  selectedItemType_txt: ri!selectedItemType_txt
                ).startIndex_int, 1, 0
              ),
              applyWhen: or(ri!selectedItemType_txt = cons!CR_CMU_GRID_LABEL_BUCKET_VALUES[4], 
              ri!selectedItemType_txt = cons!CR_CMU_GRID_LABEL_BUCKET_VALUES[1],
              ri!selectedItemType_txt = cons!CR_CMU_GRID_LABEL_BUCKET_VALUES[2],
              ri!selectedItemType_txt = cons!CR_CMU_GRID_LABEL_BUCKET_VALUES[3])
            )

  • Hi here the issue is batch size in the paging.. count is miss matching..

    when i give the batch size =-1 then count will match to db data 

    when i give the batch size =10 or 1 or 20 or 50 whatever it will miss match the count from db to UI 

    why this will happen! what is the exact issue? why batch size is giving issue?

    can anyone help me with this