I'm new to saleforce, I want to make a custom case history component using the CaseHistory object, I do the following SOQL
List <CaseHistory> caseHist = [SELECT Id,
Field,
CreatedBy.Name,
OldValue,
NewValue,
CreatedDate
FROM CaseHistory WHERE CaseId =: caseId ORDER BY CreatedDate DESC LIMIT 3];
I have three problems:
- the field I need the label not the name api
- update the component when making any changes (as it is a history component, Case (parent) when making modifications to the case when saving it should be displayed in the case history component (child) since they are on the same page)
- there are changes that are made and keeps two records the id of another object and the name