filtering not working

[mnhhs]

Hi,

I am trying to filter the data by CCC_SPEC_CD "305" and Categories 1, 2, 3 & Blanks only as per the below filter:

[CCC_SPEC_CD] = "305" OR
[URGENCY_CATEGORY] = "1" OR
[URGENCY_CATEGORY] = "2" OR
[URGENCY_CATEGORY] = "3" OR
[URGENCY_CATEGORY] = "Blank"

But the output is including other CCCs that I don't want and also other categories that I don't want.

Any assistance will be helpful. thank you.

[gautams091 · Accepted solution]

Hi

Please check the data type which needs to be String and use the following filter condition 

([URGENCY_CATEGORY]="1" OR
[URGENCY_CATEGORY]="2" OR
[URGENCY_CATEGORY]="3" OR
[URGENCY_CATEGORY]="4") AND
[CCC_SPEC_CD]="305" 

[mnhhs · Accepted solution]

Thank you, its working now. Cheers