I am developing view that satisfies various fields within a form, but, my problem is when $ConflictAction = “1”, the view will display the forms that doesnt meet the requirements regardless of what the field says.
Here is the code:
SELECT (Request_Type = “New Part Request” &
@Contains(Action; “Enter”) & !@Contains(Action;“Flammability”) &
(@Contains(AUDRES;“”) | @Contains(AUDRES;“Fail”))) &! @Contains(AUDRES;“Pass”)
It will still display forms with Pass that have $ConflictAction = 1.
Any suggestions?