Skip to main content
Topics#SOQL Query

#SOQL Query0 discussing

Ask a question...
Matthew Hecker (Salesforce Administrator at Securitas Technology Healthcare) posted in #CSV
Sep 10, 2020, 8:43 PM

Workbench - Bulk CSV export - Error: InvalidJob: Unable to find object: childaccounts

 

I'm getting an error when trying to run SOQL in workbench. The below query works fine if i choose the view as option "list", however if i choose "Bulk CSV" it throws an error? Any thoughts on how to export this without getting that error would be great :)

 

SELECT id, name, state__c, custid__c, (select state__c FROM childaccounts)

FROM account where owner.name = 'FAKE PERSON' and parentid = '' and solomon_address_key__c = ''

1 comment
Write a comment...
0/9000
Christie Fidura (Director, Global Developer Programmes at Salesforce) posted in * Salesforce Developers *
Oct 31, 2022, 11:26 AM

Ready to Learn Apex and SOQL? Check out this Free Resource! 

 

Trailblazer Mentor and Dyersburg community group leader @Shelley Reaves shared this resource on LinkedIn recently, so I'm re-posting her recommendation here:

 

If you're interested in learning #Apex and #SOQL Query, I highly recommend you check out Women Code Heroes, a blog written by @Kieren Jameson. She created a series of "Cooking with Code" articles to explain the fundamentals of Apex and SOQL, and it has quickly become one of my favorite learning to code resources because it's fun and easy to follow!  Link to the blog below, and there are many different Cooking with Code articles that can be found within the blog!

 

http://womencodeheroes.com/

 

Ready to Learn Apex and SOQL?

Image credit: Women Code Heroes website

2 comments
  1. Kieren Jameson (Salesforce)
    Oct 31, 2022, 3:22 PM

    We're also always looking for volunteer mentor coaches (our organization is 100% volunteer-run). If you are a developer looking to give back and change the gender-diversity stats in our developer community, then see more details in the About Our Coaches.

     

    You can sign up via our volunteer signup page.

Write a comment...
0/9000
Jeevanjyot Kaur (Bristlecone)
Oct 11, 2021, 9:29 AM
Feature Set License

How can we fetch all the Feature set license Names through SOQL query?

 

#CRM Configuration #Salesforce Developer

1 answer
Write an answer...
0/9000
Jeevanjyot Kaur (Bristlecone) asked in #SOQL Queries
Oct 10, 2021, 11:16 PM
Profile Name SOQL Query

Hi,

 

Could you please help me how create a single SOQL query for fetching : User Id, User NAME, User Profile Name, user using Permission set license name in a single SOQL Query.

I am using below query which does execute but under Assignee.Profile.Name field I get wrong output. [screenshot attached]

 

Could you please let me know how can I correct this Query to get correct profile name

 

#SOQL Queries #SOQL Query #REST API #Salesforce Developer #User Profile #Permission Set #Sales Cloud #Integration.

 

Query : SELECT Assignee.Id, Assignee.Name, Assignee.Alias, Assignee.ProfileId, Assignee.Profile.Name, PermissionSetLicense.MasterLabel FROM PermissionSetLicenseAssign

 

Thank you!!

Capture.PNG
2 answers
  1. Tanuj Malik (Grazitti Interactive)
    Oct 11, 2021, 5:44 AM

    This is correct, just use this query in the SALESFORCE INSPECTOR Data Export Tab. It will show there.

     

    IT will show like this:

    This is correct, just use this query in the SALESFORCE INSPECTOR Data Export Tab. It will show there.

Write an answer...
0/9000
Jeevanjyot Kaur (Bristlecone) asked in #SOQL Queries
Oct 8, 2021, 12:02 PM
Join SOQL query

Hi,

 

Is it possible to provide joins in SOQL and get the data of multiple fields from different objects in a single query.

Is Join with User object possible?

 

For example if below query is possible : 

If query like : Select PermissionSetLicenseAssign.Id, PermissionSetLicense.MasterLabel, User.Id, User.Name from PermissionSetLicenseAssign where PermissionSetLicenseAssign.AssigneeId = User.Id

 

#SOQL Queries #Joining #SOQL Query #REST API #Child Object #User Licenses #Sales Cloud #Integration User.Id

3 answers
  1. Luiz Souza (OLX Brasil)
    Oct 8, 2021, 12:31 PM

    Hi Jeevanjyot! There's no join in SOQL as well as in SQL. But you can bring parent records and child records using Relationship Queries.  

    For your case, maybe you can use the Asignee field to bring the User data. Like this:

     SELECT PermissionSetLicenseAssign.Id, Assignee.Id, Assignee.Name FROM PermissionSetLicenseAssign WHERE AssigneeId = :bind_variable

     

    I hope I've helped,

    Best regards!

Write an answer...
0/9000
Engy Tawadros (Integrations Developer at Parker Hannifin at Lovelytics) asked in #SOQL Queries
Sep 30, 2021, 10:21 PM
How can I extract reports (all the rows) in Soql?

I want to extract all the rows from a report.

 

#SOQL Queries  #SOQL Query  #SOQL  #SOQL Experts

4 answers
Write an answer...
0/9000
Gidi Abramovich asked in #SOQL Queries
Sep 19, 2021, 8:01 AM
Capturing the Account OwnerId field Id

Hi Experts,

Is there a way to query the 'OwnerId' account standard field ID?

 

Thanks,

Gidi

 

#SOQL Queries  #SOQL Query

5 answers
  1. Amnon Kruvi (The Architech Club)
    Sep 19, 2021, 9:52 AM

    Hi Gidi,

     

    I don't think you can query for the field in SOQL - at least not from the FieldDefinition object (using the tooling API). However, you should be able to get the field information from Apex using the Schema namespace. Is there a specific reason you need it in SOQL, or can you create an Apex service to return these results?

Write an answer...
0/9000
Gunjan Garg
Sep 7, 2021, 12:15 PM
I want to query on opportunity object and count total number of opportunities whose closing month is september and stageName is closed Won

Opportunity object does not have close month, it has close date. So, how can i query it and fetch the record from Salseforce database. I am executing this query inside opportunity trigger.

  #trigger    #SOQL Query

Any help will be appriciated.

4 answers
  1. Amey Priolkar (Silverline)
    Sep 7, 2021, 12:26 PM

    Hi Gunjan,

     

    Could you please use this query,

     

    select count(id) from Opportunity where CALENDAR_MONTH(CloseDate) = 9 AND StageName ='Closed Won'
Write an answer...
0/9000
Margaret 'Peg' Henderson (Salesforce Admin at CVRx) posted in Mass Action Scheduler
May 14, 2021, 12:18 PM

I have a SOQL Query Source that will run with 1 condition but fails when I add a 2nd condition.   Is this a limitation or do I have an error with my SOQL query?  The 2nd condition is a picklist field.

 

Select ID, Days_Follow_up_Past_Due__c, Credentialing_Stage__c FROM Facility_Privilege__c WHERE Days_Follow_up_Past_Due__c = 1

AND Credentialing_Stage__c IN (‘New’, ‘Requested’, ‘Mpower Cred Process’, ‘App Submitted’, ‘Temporary’, ‘Approved’)

Write a comment...
0/9000