RESEARCH

How to retrieve User.IsPortalEnabled info from CreatedBy field on a object like Feed Item using Apex and SOQL in Salesforce

The syntax for polymorphic queries doesn’t require the relationship name You have: SELECT Id, TYPEOF CreatedBy WHEN User THEN Created.Name, Created.IsPortalEnabled END FROM Feeditem You can use: SELECT Id, TYPEOF…Read moreHow to retrieve User.IsPortalEnabled info from CreatedBy field on a object like Feed Item using Apex and SOQL in Salesforce

DATA MANAGEMENT RESEARCH

soql – How to retrieve reportFolder.meta-xml files with the Access Type and ParentId attributes?

In your package.xml you have to include report folder name and report name as follow: <?xml version=”1.0″ encoding=”UTF-8″?> <Package xmlns=”http://soap.sforce.com/2006/04/metadata”> <types> <members>MyFolder</members> <members>MyFolder/Report1</members> <members>MyFolder/Report2</members> <name>Report</name> </types> </Package> Please note <members>MyFolder</members>,…Read moresoql – How to retrieve reportFolder.meta-xml files with the Access Type and ParentId attributes?

DATA MANAGEMENT RESEARCH

soql malformed in REST API on where clause for useremail

while running this code in anonymous window getting the error below String useremailaddress=”test@test.com“; HttpRequest req = new HttpRequest(); String query=’SELECT+id+,+uuid__c+from+User+WHERE+Username=”+useremailaddress; req.setEndpoint(“callout:salesforceauthnam/services/data/v56.0/query?q=’+query); req.setMethod(‘GET’); Http http = new Http(); HTTPResponse resp =…Read moresoql malformed in REST API on where clause for useremail

DATA MANAGEMENT RESEARCH

soql – Salesforce “EntityDefinition” tooling api returns less custom object+ custom setting count

I am using Salesforce tooling “EntityDefinition” api to pull all the custom object and custom settings as per the below query: instance/services/data/v55.0/tooling/query?q=SELECT count() FROM EntityDefinition WHERE publisherid != ‘System’ and…Read moresoql – Salesforce “EntityDefinition” tooling api returns less custom object+ custom setting count