TableView Filter Expression not working

[Caitlin Brown]

I am attempting to do a tableview of my confiform data. I want it to show all RED and Amber RAG status, for WP- 3 and 4 different process statuses :

ManageRag - Statuses field with RED AMBER and GREEN

ProgArea - Drop down with WP-1: WP-4

ProcessStatus - drop down field with 2 - ID: 6 - Closed Cancelled

I have entered the below:

ProgArea.label: WP-3 AND (ManageRag.label:RED OR ManageRag.label:AMBER) AND (ProcessStatus.label:2 - ID OR ProcessStatus.label:3 - Assess OR ProcessStatus.label: 4 - Respond OR ProcessStatus.label:5 - Manage)

It is not working, I have attempted different orders of the these and using both IDs and labels. With ProcessStatus there is no ID so I have to use label. Currently it is only pulling through red entries for WP-3. 

Please advise. Let me know if you need any further information.

[Alex Medved _ConfiForms_]

Hard to tell exactly what needs to be changes, as I need to see an exact configuration of each field, but it might be just the parentheses and spaces... 

(ProgArea.label:WP-3) AND (ManageRag.label:RED OR ManageRag.label:AMBER) AND (ProcessStatus.label:2 - ID OR ProcessStatus.label:3 - Assess OR ProcessStatus.label:4 - Respond OR ProcessStatus.label:5 - Manage)

 Share the exact configuration, so I can validate it better