#SOQL5 discutindo

#SOQL  #Apex  #Salesforce Developer

#Apex  #SOQL

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

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

#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'

#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 

#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')

#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