NickSuite
08/03/2022, 5:25 PM'SELECT id, custrecord_pcsq_customer, ' +
'custrecord_pcsq_type_check, custrecord_pcsq_fields from customrecord_parent_child_sync_queue ' +
'WHERE custrecord_pcsq_status = "Pending" AND custrecord_pcsq_process_type = "Initial"; '
This error occurs: "name":"SSS_SEARCH_ERROR_OCCURRED","message":"Search error occurred: Unknown identifier '\"Pending\"'.
What is wrong with this query? Status and Process Type field both are free form text.Clay Roper
08/03/2022, 5:31 PMNickSuite
08/03/2022, 5:33 PMClay Roper
08/03/2022, 5:36 PMSandii
08/03/2022, 5:41 PMNickSuite
08/03/2022, 5:45 PM