```'SELECT id, custrecord_pcsq_customer, ' + ...
# suiteql
n
Copy code
'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.
c
Try single quotes around Pending and Initial
n
and the whole query in double quotes?
c
Sure, you can use double quotes around the whole query string, or escape the single quotes, or use backticks to create a template literal with variable interpolation instead of concatenation.
s
Use 2.1 and use template literals, will make it easier to read/write
n
It worked. Thanks @Clay Roper @Sandii
1