Skip to main content

#SOQL5 diskutieren mit

3 Antworten
  1. Gestern 09:03

    Hi @Hitesh Sharma, If you are already good in other coding, apex is not tough to learn on your end. You just start with the basics and learn one by one that I mentioned below,  

     

    1. Go with the bascis of Apex in salesforce 

    2. Do some handson using the Apex like palindrome kind of excersices and understand the coding. 

    3. Next go with Triggers, Async Apex concepts, test classes. 

    4. Use trailhead for the learning and get handson from AI, do your practices. For the trailhead learning, you just go with the Developer Beginner trailmix that shared in previous comment. 

     

    If you are dedicately looking apex, you can learn within 45 days with good understanding. There are lot of materials there in Salesforce help document as well as other forums. 

     

    Basically, learning apex is not hard and you just start your learning. Hope this info is enough to start your learning. If any doubts, ask here, I am ready to help you. 

0/9000

I need to know the Stages and order of those Stages for a particular Sales Process. I can get all Stages and their order from the OpportunityStage object, but that gives me all stages, not just those specific to a particular process. 

 

And I can find out what Sales Process is associated with my Opp by looking up the Record Type and pulling the BusinessProcessID. But I can't figure out how to determine what Stages are relevant to which Sales Process via flow. 

 

Is there anyway to get to that information with lookups? 

 

#Flow  #SOQL

10 Antworten
0/9000

In Apex, how do I declare a CSV file, access it, pass its data to a method that inserts the contents in the database, and then close it?

 

Thanks!

 

#Apex #SOQL #Csv To Records

7 Antworten
  1. 22. Juli 2025, 17:40

    I ran into something similar a while back when working with large CSV files and Salesforce. Sometimes native import tools just aren’t flexible enough, especially if you need scheduled or automated uploads. You can check out Skyvia and some information about it on this page. They’ve got a few options for importing and exporting data between Salesforce and CSV files, and you don’t have to deal with any complex setup.

0/9000

Native Integration with Data Cloud: Salesforce Developers Ask Me Anything November 2024

 

Join host @Alba Rivas and product experts @Amrinder Chadha, @Diana Jaffe and @Minhaj Khan for an in-depth discussion on integrating @* Data 360 * with the Salesforce Platform for agents.

 

Discover how to unlock the full potential of Data Cloud using familiar platform features including fields, related lists, flows, and advanced data objects (DMOs & DLOs) through #SOQL and #SQL in #Apex.

 

Bring your technical questions and get ready to explore how #Agentforce can help streamline and enhance your agent workflows.

 

Click here to register now.

 

*All AMAs are recorded and can be watched on demand on our YouTube channel.

Native Integration with Data Cloud: Salesforce Developers Ask Me Anything November 2024 Join host and product experts , and for an in-depth discussion on integrating with the Salesforce Platform for a

#Flow #Einstein Search #Enrichment Tools #Fields & Relationships #DMO

0/9000

#SOQL Queries #Salesforce Admin #SOQL

 

SOQL QUERY: Query all flows in your Org. (Use Tooling API)

 

Select Id,DefinitionId,MasterLabel, ManageableState, VersionNumber, Status, Description, ProcessType, CreatedDate,CreatedById, TriggerOrder, RunInMode, ApiVersion, Environments, TimeZoneSidKey,  ProgressStatus from flow where Status = 'Active'

6 Kommentare
  1. 14. Okt. 2024, 09:18

    You can also identify schedule-triggered flows with the query:

     

    SELECT id, IsActive, Label, ProcessType, ManageableState , TriggerObjectOrEventId, TriggerObjectOrEventLabel, TriggerType FROM FlowDefinitionView WHERE triggertype = 'Scheduled'
0/9000

#SOQL Queries #Salesforce Admin #SOQL

 

SOQL QUERY: Query all validation rules in your Org. (Use Tooling API)

 

SELECT Id, ValidationName,Active, Description, EntityDefinition.DeveloperName, ErrorDisplayField, ErrorMessage, CreatedBy.Name FROM ValidationRule where Active = true 

0/9000

#SOQL Queries #Salesforce Admin #SOQL

SOQL QUERY: Query all permission sets assigned to Particular user in your Org.

 

SELECT Id, PermissionSetId, PermissionSet.Name, PermissionSet.ProfileId, PermissionSet.Profile.Name, AssigneeId, Assignee.Name FROM PermissionSetAssignment WHERE Assignee.Name in ('Salesforce User Name')

0/9000

#SOQL Queries #Salesforce Admin #SOQL

 

SOQL QUERY: Query all flows with type of triggers in your Org 

 

SELECT Id, DurableId, ApiName, Label, Description, ProcessType, TriggerType, NamespacePrefix, ActiveVersionId, IsActive, IsOutOfDate, LastModifiedDate, IsTemplate, IsOverridable,  IsSwingFlow, Builder, ManageableState, InstalledPackageName, TriggerObjectOrEventLabel, TriggerObjectOrEventId, RecordTriggerType, HasAsyncAfterCommitPath, VersionNumber, TriggerOrder, Environments, ApiVersion FROM FlowDefinitionView WHERE IsActive =true

0/9000

#SOQL Queries #Salesforce Admin #SOQL

SOQL QUERY: Query all permission sets that can access an Object across your Org.

 

SELECT Id, ParentId,Parent.Name, SobjectType, PermissionsCreate, PermissionsRead, PermissionsEdit, PermissionsDelete, PermissionsViewAllRecords, PermissionsModifyAllRecords, CreatedDate, CreatedById,CreatedBy.Name FROM ObjectPermissions where SObjectType = 'Account'

0/9000