The Welkin Suite Forum

SOQL Builder Issues with Multiple Objects



SOQL Builder Issues with Multiple Objects

  • Please log in to reply

#1
windows version welkinsuite

stvpwrs

    Posted 13 May 2019 and edited 21 May 2019

    Hello,


    I am new to both Welkin and Salesfroce, but I am having a hard time buidling what would be a simple query in SQL. I need to join the Opportunity object with a custom Employee object to pull in related Employee fields. In Welkin SOQL I can see the fields in the Opportunity object as a "referece" but they are not listed as child items.


    Is there something I am missing? I just need to do a few LEFT JOINS against the Employee object, but this seems like quite the feat in Salesforce.


    Steve



    1 replies to this topic

    #2

    ihor.zhabolenko

      Posted 21 May 2019

      Hello.
       
      Thank you for your interest
       
      To help you explore the abilities of The Welkin Suite for dealing with queries, I would like to share with you a short video about our SOQL Executor in The Welkin Suite, and a written article about our SOQL Executor.
       
      Regarding your question about joining 2 tables, you could choose these fields from the "Child Relationships" list.
       
      If you would have any questions, I'll be happy to be of assistance.
       
       
      Kindest regards,
      Ihor
       

      TWS Team





      Boost Your Productivity. Get Started Today

      Try Free Trial