690
Hello everyone,
Asp.x have a page where I am displaying a gridview with data from the Case (Incident) created.
The Status Reason field in the select returns the Value example 100000000 and need to return the label such as "Complete".
Can anybody help me?
Thank you
*This post is locked for comments
Yes Ricardo,
You can make a "inner join" between incident and stringmap to return exaclty the information that you need.
As follows:
Best Regards,
Felippe Mendonça dos Santos
Fellipe,
Thanks for answering me.
I am using a query that the loading of the page we fill in gridview,
In this case I would have to do a join with the sitemap table?
Below the query that I'm using, could auxliar me better please confess I do not quite understand.
select customerid, customeridname , ticketnumber, new_equipamentoid, contactresponsible,title, statuscode, createdon from Incident"
Thank you for attention
Hi Ricardo,
If u are using the SDK to retrieve the Entity class, this code will retrieve the label of the desired OptionSet
Example:
incidentEntity.FormattedValues["statuscode"].ToString();
If you are querying directly on the Views of CRM Organization, the view: "StatusMap" contains the value that you wants:
The column"AttributeValue" corresponds to the OptionSet value(int).
The column "Value" corresponds to the OpstionSet label value(varchar)
The column "ObjectTypeCode" identify the EntityTypeCode. You can see the values of all entities in your CRM version here:
https://msdn.microsoft.com/en-us/library/gg328086(v=crm.6).aspx
Best Regards,
Felippe Mendonça dos Santos
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (