nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Salesforce Connector: SOQL JOIN Query-left join

Shelton_Thompson

Hello

I am trying to join two tables using SOQL in the SalesForce connector using a left join so I only download what I need (due to the number of rows I want to query the data before pulling otherwise it is to large), but I am unsure how to write the SOQL code.

BMCServiceDesk__Incident_Service_Target__c is the parent table in which I need the following fields: Id,Name,CreatedDate,LastModifiedDate,LastActivityDate,LastViewedDate,LastReferencedDate,BMCServiceDesk__ClockPauseDate__c,BMCServiceDesk__ClockState__c,BMCServiceDesk__ElapsedTime__c,BMCServiceDesk__EndDate__c,BMCServiceDesk__Incident__c,BMCServiceDesk__IsCanceled__c,BMCServiceDesk__PausedDuration__c,BMCServiceDesk__SLAName__c,BMCServiceDesk__ServiceTargetName__c,BMCServiceDesk__Service_Target_Duration__c,BMCServiceDesk__StartDate__c,BMCServiceDesk__StateValue__c,BMCServiceDesk__Status__c,BMCServiceDesk__TargetEndDate__c,BMCServiceDesk__TargetTypeValue__c,BMCServiceDesk__TargetBusinessDays__c,BMCServiceDesk__Target_Duration__c

BMCServiceDesk__Incident__c is the child table in which I need the following fields: Id, Name, Queue_Name_C

I would join where the field Name from both tables equals one another and I would want to do a left join so I get everything from BMCServiceDesk__Incident_Service_Target__c and only what matches from BMCServiceDesk__Incident__c

I would then want to further filter my results to where Queue_Name_C from BMCServiceDesk__Incident__c contains CBS-NA

Thank you

Salesforce

Accepted answers

nick_ceneviva

I think there are two options to get this to work:

1. Define the relationship within Salesforce

2. Bring in the three tables that you need and do all of the joins within Alteryx. This probably won't perform quite as well as having a query that handles the join but if you just bring back the necessary columns and apply necessary filters, the performance shouldn't be an issue.

All comments

nick_ceneviva

Give this a try!

SELECT BMCServiceDesk__Incident_Service_Target__c.Id,BMCServiceDesk__Incident_Service_Target__ct.Name,CreatedDate,LastModifiedDate,LastActivityDate,LastViewedDate,LastReferencedDate,BMCServiceDesk__ClockPauseDate__c,BMCServiceDesk__ClockState__c,BMCServiceDesk__ElapsedTime__c,BMCServiceDesk__EndDate__c,BMCServiceDesk__Incident__c,BMCServiceDesk__IsCanceled__c,BMCServiceDesk__PausedDuration__c,BMCServiceDesk__SLAName__c,BMCServiceDesk__ServiceTargetName__c,BMCServiceDesk__Service_Target_Duration__c,BMCServiceDesk__StartDate__c,BMCServiceDesk__StateValue__c,BMCServiceDesk__Status__c,BMCServiceDesk__TargetEndDate__c,BMCServiceDesk__TargetTypeValue__c,BMCServiceDesk__TargetBusinessDays__c,BMCServiceDesk__Target_Duration__c, (SELECT BMCServiceDesk__Incident__c .Id, BMCServiceDesk__Incident__cName, Queue_Name_C From BMCServiceDesk__Incident__c Where Queue_Name_C Like '%CBS-NA%')

From BMCServiceDesk__Incident_Service_Target__c

That will bring back everything from the BMCServiceDesk__Incident_Service_Target__c table and only information from the BMCServiceDesk__Incident__c table where the Queue name contains CBS-NA. If you are only looking for records from both tables were the Queue Name is CBS-NA the query will look slightly different but happy to help with that!

One thing to be careful of when working with the Salesforce Connector is that sometimes it doesn't treat enters as spaces so make sure there are spaces before every line break in you query.

Shelton_Thompson

Almost there:

I am looking to LEFT JOIN the two tables based on the name field where the field Name from BMCServiceDesk__Incident_Service_Target__c = Name from BMCServiceDesk__Incident__c (with BMCServiceDesk__Incident_Service_Target__c as the parent/left table) and then filter that join down to where Queue_Name_C from BMCServiceDesk__Incident__c contains CBS-NA

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703