I'm trying to create a query where Type = 'Defect' , Status = 'Unresolved', Phase Found = 'FVT', 'iVT', or 'APAR' , and Linked Record = 'Unresolved' when Phase Found = 'FVT' or 'APAR'.

However, for records where Phase Found = 'iVT' the linked record state doesn't matter and can be blank.

How can I specify that the record returned must be one of those 3 Phase Founds, but the Linked Record status only matters if the Phase Found is 'FVT' or 'APAR'?


In our project Phase Found is an Enumeration and Linked Record is a Work Item field.

Thanks,