```SELECT DISTINCT custrecord_employee, id FROM cu...
# suiteqln
NickSuite
08/02/2022, 4:20 PM Copy code
SELECT DISTINCT custrecord_employee, id FROM customrecord_update_queue ' +
'WHERE custrecord_status is Pending'r
Richard Tanner
08/02/2022, 5:00 PMYou would need quotes around Pending. If the status field is a select field you would also need to either surround it with BUILTIN.DF or use the internal id of the list value. Also, I don't believe you can use is like that, it should be an = sign.
Richard Tanner
08/02/2022, 5:01 PMsomething like this
Copy code
SELECT DISTINCT custrecord_employee, id FROM customrecord_update_queue
WHERE BUILTIN.DF(custrecord_status) = 'Pending'n
NickSuite
08/02/2022, 7:33 PMThank you. That worked @Richard Tanner
NickSuite
08/02/2022, 7:33 PM= sign and " " was the issue.