TableView Filter Expression not working

Question

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_ · Answer

Hi

Does this expression works better?

(ProgArea:3) AND (ManageRag:error OR ManageRag:moved) AND (ProcessStatus:2 OR ProcessStatus:3 OR ProcessStatus:4 OR ProcessStatus:5)

Alex

Caitlin Brown_oq6ko9 · Answer

Hi Alex, thanks for getting back to me. Please see configuration attached.

To note I attempted your expression however the Amber risk is not pulling through the report:

(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)

Alex Medved _ConfiForms_ · Answer

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