Integrations and APIs for Service

Get Involved. Join the Conversation.

Topic

    chidambaram CT
    ROQL - Email address with single quote
    Topic posted March 12, 2018 by chidambaram CTBronze Trophy: 5,000+ Points 
    105 Views, 3 Comments
    Title:
    ROQL - Email address with single quote
    Content:

    Following ROQL sentence throws error, because it contains single quote in the email address. 

    select count(*) from Contact where Emails.EmailList.Address='gavin'north@gmail.com' and Emails.EmailList.AddressType.ID = 0

    How to write ROQL without error?

    Comment