{"id":10895,"date":"2017-12-13T17:53:19","date_gmt":"2017-12-13T12:23:19","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=10895"},"modified":"2017-12-13T17:53:19","modified_gmt":"2017-12-13T12:23:19","slug":"read-formatted-values-using-linq-queries-in-dynamics-365","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2017\/12\/read-formatted-values-using-linq-queries-in-dynamics-365\/","title":{"rendered":"Read Formatted values using LINQ Queries in Dynamics 365"},"content":{"rendered":"

Recently we had a business requirement where we came across an issue while retrieving formatted values using LINQ.<\/p>\n

In this blog, we will discuss how to resolve this issue.<\/p>\n

Suppose, we want to retrieve a revenue with currency symbol in the formatted value and we are using below query:<\/p>\n

\/\/Retrieve Account List with Name & Revenue\n var accountList = (from acc in _context.CreateQuery(\"account\")\n                      select new\n                      {\n\n                accName = acc.GetAttributeValue<string>(\"name\"),\n\n               revenue = acc.FormattedValues.Contains(\"revenue\")? acc.FormattedValues[\"revenue\"]: \"No Data\"\n\n                                   }).ToList();\n<\/pre>\n
\u00a0It seems to be correct, but it fails to retrieve the revenue value with a currency symbol.<\/p>\n
Instead, we were just getting \u201cNo Data\u201d as the value which we have set if no revenue value found.<\/p>\n
After some research and play around we found that the FormattedValues are not returned directly as shown above.<\/p>\n
For that we needed to change the query to:<\/p>\n
\/\/Retrieve Account List with Name & Revenue\n   var accountList = (from acc in _context.CreateQuery(\"account\")\n                        select new\n                      {\n\n                        accName = acc.GetAttributeValue<string>(\"name\"),\n\n              revenueField = acc.Attributes.Contains(\"revenue\") ? acc[\"revenue\"] : null,\n         revenue = acc.FormattedValues.Contains(\"revenue\") ? acc.FormattedValues[\"revenue\"] : \"No Data\"\n\n                                   }).ToList();\n<\/pre>\n
And then it worked!<\/p>\n
Conclusion:<\/strong><\/h2>\n
If we need to retrieve a Formattedvalue using LINQ, then we first need to read the attribute value, and then we may read the FormattedValues later in the query for that attribute.<\/p>\n
\"Microsoft<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Recently we had a business requirement where we came across an issue while retrieving formatted values using LINQ. In this blog, we will discuss how to resolve this issue. Suppose, we want to retrieve a revenue with currency symbol in the formatted value and we are using below query:<\/p>\n","protected":false},"author":13,"featured_media":10896,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,19,42,67],"tags":[993],"class_list":["post-10895","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-crm","category-plugin","category-workflows","tag-linq-queries"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t