10
Hi,
I have a table as shown below:
| Employee Name | Competency | Role |
| Sandya | C2 | Software Engineer |
| Devaraj | C1 | Test Engineer |
| Prem | C3 | Test Engineer |
| Subash | C1 | Data Engineer |
| Rushikesh | C2 | Data Analyst |
In this table I want all the unique competency as list like ['C1','C2','C3']
can anyone help me to achieve this task using c# plugin.
Thanks,
Sandya
Hi Sandya,
Use the query generated by Fetch Builder with the below function
Share
Report
All responses (
Answers (
public static EntityCollection ExecuteFetch(string fetchXmlString, IOrganizationService service)
{
EntityCollection entityCollection = new EntityCollection();
try
{
entityCollection = service.RetrieveMultiple(new FetchExpression(fetchXmlString));
}
catch (Exception)
{
Console.WriteLine("Error from ExecuteFetch");
}
return entityCollection;
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156