Dynamic SOQL Query using sObject
Please use below sample code to form SOQL query string based on user field level access permission. Code : public static string generateDynamicSOQLQuerybysObject(String objectName){ String selects = ”; Map<String, Schema.SObjectField> fMap = Schema.getGlobalDescribe().get(objectName.toLowerCase()).getDescribe().Fields.getMap(); list<string> selectFields = new list<string>(); if (fMap != null){ for (Schema.SObjectField ft : fMap.values()){
Dynamic SOQL Query using sObject with Reference Object Fields
Generate dynamic SOQL query with “__r” fields. Code : public static string generateDynamicSOQLwithReferenceField(String objectName, String strRefField) { String selects = ”; Map<String, Schema.SObjectField> fMap = Schema.getGlobalDescribe().get(objectName.toLowerCase()).getDescribe().Fields.getMap(); list<string> selectFields = new list<string>(); if (fMap != null){ for (Schema.SObjectField ft : fMap.values()){ Schema.DescribeFieldResult fd = ft.getDescribe(); selectFields.add(fd.getName()); } } if (!selectFields.isEmpty()){ for (string s:selectFields){ selects +=
Salesforce Encrypted SSN/CreditCard Field Limitation
SSN Field Encryption & Shield/Credit Card Field Limitation – SFDC Salesforce have ability to display the secured data in encrypted format. It is salesforce out of box functionality. You can create new Text(Encrypted) using “Custom Fields & Relationships” on the object. Advantages