The Welkin Suite Forum

SOQL Builder Issues with Multiple Objects

SOQL Builder Issues with Multiple Objects

  • Please log in to reply

windows version welkinsuite


    Posted 13 May 2019 and edited 21 May 2019


    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.


    1 replies to this topic



      Posted 21 May 2019

      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,

      TWS Team

      Boost Your Productivity. Get Started Today

      Try Free Trial