JavaScript Required

We're sorry, but we doesn't work properly without JavaScript enabled.


Accessing different type of attributes from fetchXML link entity (AliasedValue) using C#

This blog you may use as a quick guide for accessing different type of attributes value from the link-entity using C#. So here in this blog I am retrieving data from the contact entity information with that I also retrieve link entity which is account entity where I am basically retrieving all type of attributes. I went through many blogs but seems there is no blog available where I could get all type attribute access code. I almost cover all the type of attributes which we usually retrieve in our day to the day development.

The tricky things which we usually miss alias name in the fetchXML. Alias name comes automatically when you build FetchXML using advanced find. You can give any name which you like in the fetchXML.

<link-entity name=""account"" from=""accountid"" to=""parentcustomerid"" visible=""false"" link-type=""outer"" alias=""ab"">

We need to use the alias name and dot before use the attributes name when you wanted to retrieve data using link entity. For example, if we retrieve accountnumber attributes value from account entity we need to use ab.accountnumber.

Here is the sample code you could refer -

var fethXML = @"<fetch version=""1.0"" output-format=""xml-platform"" mapping=""logical"" distinct=""true""> <entity name=""contact""><attribute name=""fullname"" /><attribute name=""telephone1"" /> <attribute name=""contactid"" /> <order attribute=""fullname"" descending=""false"" /> <link-entity name=""account"" from=""primarycontactid"" to=""contactid"" link-type=""inner"" alias=""ae""> <filter type=""and""><condition attribute=""accountcategorycode"" operator=""eq"" value=""1"" /></filter> </link-entity><link-entity name=""account"" from=""accountid"" to=""parentcustomerid"" visible=""false"" link-type=""outer"" alias=""ab""> <attribute name=""accountnumber"" /><attribute name=""tel_hobby"" /> <attribute name=""accountcategorycode"" /> <attribute name=""address1_latitude"" /> <attribute name=""createdby"" /><attribute name=""createdon"" /> <attribute name=""description"" /><attribute name=""donotemail"" /><attribute name=""exchangerate"" /> <attribute name=""onholdtime"" /><attribute name=""ownerid"" /><attribute name=""processid"" /> <attribute name=""revenue"" /></link-entity></entity></fetch>"; EntityCollection entityCollectionResult = new EntityCollection(); entityCollectionResult = Service.RetrieveMultiple(new FetchExpression(fethXML)); if (entityCollectionResult.Entities.Count > 0) { foreach (Entity entity in entityCollectionResult.Entities) { //---------Getting accountnumber (AccountNumber) - Single Line of Text Field--------// string accountnumber; AliasedValue accountnumberAliasVal = entity.GetAttributeValue<AliasedValue>("ab.accountnumber"); if (accountnumberAliasVal != null) { accountnumber = accountnumberAliasVal.Value.ToString(); } //---------revenue (Revenue) - Currency Field--------// decimal revenue; AliasedValue revenueAliasVal = entity.GetAttributeValue<AliasedValue>("ab.revenue"); if (revenueAliasVal != null) { revenue = ((revenueAliasVal.Value) as Money).Value; } //---------createdon (CreatedOn) - Date and Time Field--------// DateTime? createdon; AliasedValue createdonAliasVal = entity.GetAttributeValue<AliasedValue>("ab.createdon"); if (createdonAliasVal != null) { createdon = (DateTime)(createdonAliasVal.Value); } //---------exchangerate (ExchangeRate) - Decimal Number Field--------// decimal exchangerate; AliasedValue exchangerateAliasVal = entity.GetAttributeValue<AliasedValue>("ab.exchangerate"); if (exchangerateAliasVal != null) { exchangerate = Convert.ToDecimal(exchangerateAliasVal.Value); } //---------address1_latitude (Address1_Latitude) - Floating Point Number Field--------// decimal latitude; AliasedValue latitudeAliasVal = entity.GetAttributeValue<AliasedValue>("ab.address1_latitude"); if (latitudeAliasVal != null) { latitude = Convert.ToDecimal(latitudeAliasVal.Value); } //---------createdby (CreatedBy) - Lookup Field--------// Guid createdByGuid = new Guid(); string createdByName = string.Empty; AliasedValue createdByAliasVal = entity.GetAttributeValue<AliasedValue>("ab.createdby"); if (createdByAliasVal != null) { createdByGuid = ((createdByAliasVal.Value) as EntityReference).Id; createdByName = ((createdByAliasVal.Value) as EntityReference).Name; } //---------description (Description) - Multiple Lines of Text Field--------// string description; AliasedValue multilineTextAliasVal = entity.GetAttributeValue<AliasedValue>("ab.description"); if (multilineTextAliasVal != null) { description = multilineTextAliasVal.Value.ToString(); ; } //---------accountcategorycode (Category) - Optionset Field--------// Int32 categoryVal; AliasedValue categoryAliasVal = entity.GetAttributeValue<AliasedValue>("ab.accountcategorycode"); if (categoryAliasVal != null) { categoryVal = ((categoryAliasVal.Value) as OptionSetValue).Value; } //---------ownerid (OwnerId)-Owner type Field--------// Guid ownerId = new Guid(); string ownerName = string.Empty; AliasedValue ownerAliasVal = entity.GetAttributeValue<AliasedValue>("ab.ownerid"); if (ownerAliasVal != null) { ownerId = ((ownerAliasVal.Value) as EntityReference).Id; ownerName = ((ownerAliasVal.Value) as EntityReference).Name; } //---------donotemail - DoNotEMail--Two Options Field--------// bool donotemailFlag; AliasedValue donotemailAliasVal = entity.GetAttributeValue<AliasedValue>("ab.donotemail"); if (donotemailAliasVal != null) { donotemailFlag = (Boolean)donotemailAliasVal.Value; } //---------onholdtime - OnHoldTime - Whole Number Field--------// Int32 onholdtime; AliasedValue onholdtimeAliasVal = entity.GetAttributeValue<AliasedValue>("ab.onholdtime"); if (onholdtimeAliasVal != null) { onholdtime = (Int32)onholdtimeAliasVal.Value; } //---------Getting tel_hobby(Hobby) - Multiselect optionset--------// Int32 hobby; AliasedValue hobbyAliasVal = entity.GetAttributeValue<AliasedValue>("ab.tel_hobby"); if (hobbyAliasVal != null) { List<int> optionsValue = new List<int>(); OptionSetValueCollection hobbies = ((hobbyAliasVal.Value) as OptionSetValueCollection); foreach (OptionSetValue opt in hobbies) { optionsValue.Add(opt.Value); } } } }

Awesome clients we worked for

Client Testimonials

  • Fabio Durso

    We found a reliable and efficient partner in Aegis Infoways, ready to support our strategy of offshore software development. Aegis Infoways has particularly impressed by the speed of response to any request for the development of software applications and for their maintenance.

  • Filipe

    We did hire full time Java developers from Aegis Infoways, to help us to improve a time to market of a product. The software platform is based on Java & Extjs, and they are delivering the software on time and with success. We strongly recommend Aegis Infoways as Reliable Development partner.

  • Steve

    Powerful solutions are given by Aegis Infoways dedicated developers for my projects. They suggest solutions as per current market trend. Other than this, the team is always ready for any type of changes or update. That is the main reason that I would like to give my next project to them.

Copyright © Aegis Infoways All rights reserved