Skip to main content
주제#SOQL Query

#SOQL Query토론 중인 항목 0개

질문해 보세요...
Matthew Hecker (Securitas Technology Healthcare Salesforce Administrator) 님이 #CSV에 글을 올렸습니다
2020년 9월 10일 오후 8:43

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개
댓글을 작성하세요...
0/9000
Ashna Khanna (Infosys Senior System Engineer)
2024년 2월 19일 오후 7:32

What is the SOQL query to find count of contact id from an account ?

#SOQL Query #SOQL Statement
댓글 2개
댓글을 작성하세요...
0/9000
Christie Fidura (Salesforce Director, Global Developer Programmes) 님이 * Salesforce Developers *에 글을 올렸습니다
2022년 10월 31일 오전 11:26

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개
  1. Kieren Jameson (Salesforce)
    2022년 10월 31일 오후 3:22

    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.

댓글을 작성하세요...
0/9000
Jeevanjyot Kaur (Bristlecone)
2021년 10월 11일 오전 9:29
Feature Set License

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

 

#CRM Configuration #Salesforce Developer

답변 1개
답변을 작성하세요...
0/9000
Jeevanjyot Kaur (Bristlecone) 님이 #SOQL Queries에 질문했습니다
2021년 10월 10일 오후 11:16
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개
  1. Tanuj Malik (Grazitti Interactive)
    2021년 10월 11일 오전 5:44

    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.

답변을 작성하세요...
0/9000
Jeevanjyot Kaur (Bristlecone) 님이 #SOQL Queries에 질문했습니다
2021년 10월 8일 오후 12:02
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개
  1. Luiz Souza (OLX Brasil)
    2021년 10월 8일 오후 12:31

    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!

답변을 작성하세요...
0/9000
Engy Tawadros (Lovelytics Integrations Developer at Parker Hannifin) 님이 #SOQL Queries에 질문했습니다
2021년 9월 30일 오후 10:21
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개
답변을 작성하세요...
0/9000
Gidi Abramovich 님이 #SOQL Queries에 질문했습니다
2021년 9월 19일 오전 8:01
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개
  1. Amnon Kruvi (The Architech Club)
    2021년 9월 19일 오전 9:52

    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?

답변을 작성하세요...
0/9000
Gunjan Garg
2021년 9월 7일 오후 12:15
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개
  1. Amey Priolkar (Silverline)
    2021년 9월 7일 오후 12:26

    Hi Gunjan,

     

    Could you please use this query,

     

    select count(id) from Opportunity where CALENDAR_MONTH(CloseDate) = 9 AND StageName ='Closed Won'
답변을 작성하세요...
0/9000
Margaret 'Peg' Henderson (CVRx Salesforce Admin) 님이 Mass Action Scheduler에 글을 올렸습니다
2021년 5월 14일 오후 12:18

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’)

댓글을 작성하세요...
0/9000