[SalesForce] How to get record name passing object name, record id (dynamically)

i want to fetch the record name using record id.
below is my dynamic query

SObject record = Database.query('Select CaseNumber From ' + sObjName + ' Where Id = :subOrderId');

Could anyone please let me know how can i extract the CaseNumber alone from the above query.

Best Answer

For accessing fields from SObject use getter methods like:

// with String
record.get('CaseNumber')

// with Schema.sObjectField
record.get(Schema.Case.CaseNumber)

Related Solutions

[SalesForce] Database.query not returning records properly as needed

The field is there, but it's not being printed out by default. If you try

system.debug('myData::'+JSON.serialize(objData));

you will get the null value as well. So for your intents, all the data is in place.

[SalesForce] How to fetch the list of Milestone under the Entitlement Process of the Entitlement using Entitlement Name

How to fetch the list of Milestone under the Entitlement Process of the Entitlement using Entitlement Name ?

You need to use Metadata API to fetch list of milestones under Entitlement process.

From Entitlement Name you can get SLAProcessId, which Entitlement Process Id through SOQL query.

SELECT SlaProcessId FROM Entitlement WHERE Name = '<Entitlement Name>';

Refer EntitlementProcess Metadata API which has milestones field referred to EntitlementProcessMilestoneItem and from there you can fetch milestoneName.

Using CaseId fetch the Name Of the Milestones??

This SOQL I have given you earlier perfectly works for me.

[SELECT Id, Name FROM MilestoneType 
WHERE Id IN 
(SELECT MilestoneTypeId 
FROM CaseMilestone 
WHERE CaseId = '')]

Best Answer

Related Solutions

[SalesForce] Database.query not returning records properly as needed

[SalesForce] How to fetch the list of Milestone under the Entitlement Process of the Entitlement using Entitlement Name

Related Topic