we have one filter condition why it's not working install status is "1" time

[mani55]

we have one filter condition why it's not working install status is "1" time for 2 it's working fine and substaus values we have for only 2 those are also working but install status 1 on that time it's working 

we have one filter condition why it's not working install status is "1" time

nameINGOSS Americas,APAC,Europe^install_statusIN2,1^substatusINmodify,retire

let me know the mistake

[Sohithanjan G]

Hi @mani55 

Putting it all together, the query is filtering records with the following criteria:

• The "name" field must match one of "GOSS Americas", "APAC", or "Europe".
• The "install_status" field must be either "2" or "1".
• The "substatus" field must be either "modify" or "retire".

You have AND condition running btw three filter. Make sure you have data present or if you are looking for OR condition, you can use the below query

nameINGOSS Americas,APAC,Europe^install_statusIN2^ORinstall_statusIN1^substatusINmodify,retire

HIT Helpful & Accept Solution !!!

[Mark Manders]

If you only have the sub_status when install_status is 2, it will never show you any install_status 1, since it's an 'AND' query.

You need to create an OR query with it:

nameINGOSS Americas,APAC,Europe^install_status=1^NQnameINGOSS Americas,APAC,Europe^install_status=2^substatusINmodify,retire

[mani55]

i tried ur query but no luck

[Shubham26]

Hi @mani55 

May I know your table name, is it OOB table or custom table?

And are you sure you have data in your table with install status 1 and also satisfy other condition as well?

Thank You.

Regards,

Shubham Gupta