Slash Before Quote - Merge or Query Building Issue?

edited September 3, 2019 in Questions
When attempting to query CaseComments by ParentId, I'm running into an issue with the model conditions. According to the error, it appears that an 18 character Id is being passed to the SOQL query, which would be fine if it was enclosed in single quotes. My troubles occur when I try to set that condition in an action to have the single quotes on either side of the Id. The error indicates that a is inserted before the single quotes.

Comments

  • edited September 3, 2019
    I'm not sure you need to supply the quotes if you are using the field name Id, or the merge syntax version {{Id}}. (I'm trying to visualize how you are setting up the condition; a screen shot or the XML <condition>...</condition> line might be helpful.

    That said, if you are using the merge syntax with double braces, try changing to triple: {{{Id}}}

    Also, if ParentId in CaseComments is similar to the Attachment object, you may not be able to "get there from here." The object-oriented relationships between some of those objects is not what a relational database approach expects.
  • edited August 7, 2018
    I'm much more interested in whether or not the single quotation in string can be passed into the SOQL query without the /. The query works with the single quotations.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!