#SOQL11 debatiendo

Hi, this query works in SOQL but I am hoping to do create a report type.  I am not having much luck.  Any idea if I can create a report type to handle these objects? 

SELECT 

LinkedEntity.Name, 

ContentDocument.Title, 

ContentDocument.LatestPublishedVersion.TextPreview 

FROM ContentDocumentLink 

WHERE LinkedEntity.Type = 'Contact'  

These report types show no data: "File and Content Report" and "Content Report" 

Thanks, Aron! 

#Reporting  #SOQL  #Notes & Attachments

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