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