Since you mentioned that z_quarter ia drop down. I think the value stored on the ticket for that field is not a string but an integer value. So try updating your constraint to:
z_quarter = z_quarter.
quarter1
OR
z_quarter = <ID> (where ID is the unique value of the record on the referencing table.
------------------------------
Kind Regards,
Brian
------------------------------
Original Message:
Sent: 10-23-2019 08:33 AM
From: asim Shah
Subject: stored query for custom shcema
Hi Team
We have a custom dropdown whose schema is 'z_quarter' which has three values 'quarter 1' , 'quarter2' & 'quarter3'
we want see tickets who has quarter1 selected in dropdown , those tickets will appear only.. so i write below constraint in stored query but its not working.
z_quarter = 'quarter1'
#cr_stored_queries
#ca_sdm_17.1
Please help