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.
Solved! Go to 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"
Thank you, its working now. Cheers