This is a public Forum  publicRSS

Topic

    Anushree gandhi
    ROQL Select Query working in Connect Object Explorer but not...
    Topic posted August 3, 2018 by Anushree gandhiNewbie 
    58 Views, 1 Comment
    Title:
    ROQL Select Query working in Connect Object Explorer but not in Custom Script
    Content:

    Hi All,

    I am trying to fetch data from Contact and its child custom object.

    My query is "Select ID , packageName$objectName$fieldName.fieldName1 , packageName$objectName$fieldName.fieldName2  from Contact where ContactID is not null LIMIT 10"

    The same query is working in Connect object explorer but when i try it in custom script it says 'Unknown table or column 'packageName'.

    Thanks in Advance!

     

     

    Version:
    Connect v1.3

    Answer

     

    • Deepu Kolkkadan

      Hi Anushree,

      Try below query, this will work in your script.

      "SELECT Contact.id,Contact.CustomFields.packageName.objectName.fieldName1,Contact.CustomFields.packageName.objectName.fieldName2 FROM Incident where Contact.id is not null LIMIT 10"

       

      Regards,

      Deepu