D365 UCI version - How to obtain team name in C#

(0) Share

Report

Posted on by D365 Geek

I need some help, please. I am writing a C# code that should ascertain whether the logged user is a member of a particular team, called it, Corporate Desk Team, and if yes, grant certain privileges. I have been able to handle all aspects of the code apart from the Query Expression or FetchXML that returns the name of the team. Could someone help me with a Query Expression or FetchXML query that can search whether a logged in user belongs to Corporate Desk Team? Thank you in advance.

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Charan Raju C R 7 Moderator on at

Like (1)

Report

Hi,

Please check if the below fetch XML query is helpful for your requirement.

string fetchXML = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>
<entity name='systemuser'>
<attribute name='fullname' />
<attribute name='systemuserid' />
<order attribute='fullname' descending='false' />
<filter type='and'>
<condition attribute='systemuserid' operator='eq-userid' />
</filter>
<link-entity name='teammembership' from='systemuserid' to='systemuserid' visible='false' intersect='true'>
<link-entity name='team' from='teamid' to='teamid' alias='af'>
<filter type='and'>
<condition attribute='name' operator='eq' value='Corporate Desk Team' />
</filter>
</link-entity>
</link-entity>
</entity>
</fetch>";
EntityCollection records = crmService.RetrieveMultiple(new FetchExpression(fetchXML));

if(records.Entities.Count > 0)
// Logged in user belongs to 'Corporate Desk Team'
else
// Logged in user doesn't belongs to 'Corporate Desk Team'

Was this reply helpful? Yes No
Verified answer

Mauro De Biasio on at

Like (1)

Report
Hi D365 Geek,

This is the query expression that retrieves all the users belonging to a team that you know the Guid of:

//Define the Entity you want to retrieve QueryExpression retrieveUsersBelongingToTeam = new QueryExpression() { EntityName = "systemuser" }; //Define the columns you want to retrieve (true means all) you just need systemuser id and fullname retrieveUsersBelongingToTeam.ColumnSet = new ColumnSet(true); //define the entities and the field to join var linkedEntity = new LinkEntity(); linkedEntity.LinkFromEntityName = "systemuser"; linkedEntity.LinkToEntityName = "teammembership"; linkedEntity.LinkFromAttributeName = "systemuserid"; linkedEntity.LinkToAttributeName = "systemuserid"; //define a filter to limit the number of teams var filterExpression = new FilterExpression(); filterExpression.FilterOperator = LogicalOperator.And; //define the team Guid to filter var condition = new ConditionExpression(); condition.AttributeName = "teamid"; condition.Operator = ConditionOperator.Equal; condition.Values.Add("Your Team guid here"); //add the condition to the filter filterExpression.Conditions.Add(condition); //add the filter to the linked entity linkedEntity.LinkCriteria = filterExpression; //add the linked entity retrieveUsersBelongingToTeam.LinkEntities.Add(linkedEntity); EntityCollection retrieved = svc.RetrieveMultiple(retrieveUsersBelongingToTeam); //print the username that belong to the particular team foreach (var c in retrieved.Entities) { System.Console.WriteLine("Name: " c.Attributes["fullname"]); }

With that information you should be able to accomplish what you were after. Remember that User and Team are connected via "teammembership".

Please consider to change your code style and switch to "Early Bound" the code will be more manageable and in general linq queries are easier to write.

Best Regards,

Mauro De Biasio

Was this reply helpful? Yes No
Mauro De Biasio on at

Like (0)

Report

D365 Geekcan you please mark the previous post as the answer if the code worked for you?

Was this reply helpful? Yes No

Join the conversation

Community site session details

D365 UCI version - How to obtain team name in C#

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

D365 UCI version - How to obtain team name in C#

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates