[SalesForce] How to Fetch all role names and ids created by developer or user( not system created)

When i am querying the "Select id,name from UserRole" then all roles are getting fetch with the system roles and created by user/admin/developer..
Is there any way to fetch the roles created by user/dev/admin.Please Suggest

Best Answer

An imperfect but probably workable solution:

If you want to see who is changing metadata such as Roles, go to Setup | View Setup Audit Trail

You can go back 6 months in time. You'll get the SFDC username that, if you really care, can be cross-referenced to the User SObjects and admin versus user vs dev breakouts can be ascertained. The normal use case for this issue is "who made some system change?" and is typically a one-off.

Related Solutions

[SalesForce] SOQL query not returning any record even when it is present. Trigger failing due to this

I observed the same issue in our full sandbox after a refresh. I believe it is a bug, though it is not yet on Salesforce's known issues list.

If you change your query to Select Id,Name from CaseTeamRole where Name != 'CSO', your query will probably return all results except the record where the Name is CSO.

If you change your query to Select Id,Name from CaseTeamRole where Name like '%s%', your query will probably return two records: CSO and Global Sales Manager.

It looks to me that the results only return if > 1 row is in the result set.

The workaround that could work for you is to query for all CaseTeamRole records and then loop through each result looking for Name = 'CSO'. For example:

for (CaseTeamRole ctr: [select id, name from CaseTeamRole])
{
 if(ctr.Name == 'CSO')
 {..do stuff.. }
}

If you happened to open a case with Salesforce, would be curious to know if they confirmed whether it is a bug or not.

Best Answer

Related Solutions

[SalesForce] SOQL query not returning any record even when it is present. Trigger failing due to this

Related Topic