Hi,
I will be having two columns in my table minValue,Maxvalue.when i pass an input to the table it should return the lookup value in the attached screen shot.
Lets say if i pass a value 0.25, the value 0.25 is in between 0 and 0.5 in attached screen shot, it should return me 100.
What should be my query logic in this case?
Attached is the code , but this logic is wrong because the logic should be written in reciprocal to this.
Please help with this , any creative way of creating the table table structure are also welcome.
a!queryEntity( entity:cons!ENTITY, query:a!query( logicalExpression:a!queryLogicalExpression( operator:"AND", filters:{ a!queryFilter( field:"minValue", operator:">=", value:0.25 ),
a!queryFilter( field:"maxValue", operator:"<=", value:0.25 ) }), pagingInfo: a!pagingInfo(1,1) ) )
Discussion posts and replies are publicly visible