Log in to AnswerLog in to Follow
2021-07-01 19-05-18
Wahaj Adil
10Views
5Comments
Solved
How to filter data on the basis of range (From-To)
Question
Aggregate
Reactive
Best Practices
Database
Logic
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.

0
0
30 Mar

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:

0
0
30 Mar

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

0
0
30 Mar

Hi @Muhammed Riyas 

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

Regards.

0
0
30 Mar

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

0
0
30 Mar

Yes, they are integers only.


Thank you.

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