Advanced query question
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,
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,