filtering not working

Question

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 Answer

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 Answer

Thank you, its working now. Cheers