How to filter data on the basis of range (From-To)
Application Type
Reactive

Hi everyone,

Am working on an application and trying to implement different search filters.
I am having trouble finding data on the basis of range. I am using the below filter to find data of SOH

ProductMaster.SOH >= FromSOH or FromSOH = NullIdentifier()

and 

ProductMaster.SOH <= ToSOH or ToSOH = NullIdentifier()

If I am inputting data from 20 to 25 it is giving me values of 28 and 30(which are higher than 25)
I have attached an image as well. Please help.

Thank you.

Hello Wahaj Adil,


Try segregating each filter without "AND".


1. ProductMaster.SOH >= FromSOH or FromSOH = NullIdentifier()


2. ProductMaster.SOH <= ToSOH or ToSOH = NullIdentifier()


As an example below:

Okay, I'll try to put it this way.
Thank you.

Hi @Muhammed Riyas 

It is working fine now.
Thank you for being helpful.

Regards.

Hi Wajah

If the ProductMaster.SOH ,FromSOH  and ToSOH   are integers than it should work. 


ProductMaster.SOH >= FromSOH or FromSOH = NullIdentifier()

and 

ProductMaster.SOH <= ToSOH or ToSOH = NullIdentifier()


You also need to check the above highlighted condition because of that also you can get wrong output.

Best Regards

Devendra

Yes, they are integers only.


Thank you.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.