Skip to main content

D365 get fetchxml alias value

 If we use an alias in our fetchxml query it will not retrieve the alias attribute like the default query.

  String inputstdssAttendeeFetchXML = $@"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>  
                                     <entity name='std_stdssattendee' >  
                                     <attribute name='std_attendeeroleid' />  
                                       <filter>  
                                        <condition attribute='std_stdstdssid' operator='eq' value='{ inputstdss.GetAttributeValue<Guid>("std_stdstdssid")}' />  
                                        <condition attribute='statecode' operator='eq' value='0' />  
                                        <condition attribute='std_attendeeroleid' operator='not-null' />  
                                       </filter>  
                                       <link-entity name='std_stdattendee' from='std_stdattendeeid' to='std_stdattendeeid' link-type='inner' alias='stdattendee' >  
                                        <link-entity name='contact' from='contactid' to='std_contactid' link-type='inner' alias='contact' >  
                                         <attribute name='contactid' />  
                                        </link-entity>  
                                       </link-entity>  
                                      </entity>  
                                   </fetch>";  
 var inputstdssAttendeeresult = localContext.OrganizationService.RetrieveMultiple(new FetchExpression(inputstdssAttendeeFetchXML));  
 if (inputstdssAttendeeresult.Entities.Any())  
 {  
      foreach (Entity inptstdssAtten in inputstdssAttendeeresult.Entities)  
      {  
           Guid contactId = (Guid)inptstdssAtten.GetAttributeValue<AliasedValue>("contact.contactid").Value;  
      }  
 }

Labels:

Comments

Post a Comment

Popular posts from this blog

WPF datagrid cell textbox change event

Entity/Class: public class FeesDetails : INotifyPropertyChanged { public int Id { get; set; } public string FeesName { get; set;} public string FeesDetailsName { get; set; } public int? PaidAmount { get; set; } public event PropertyChangedEventHandler PropertyChanged; private void NotifyPropertyChanged(System.String info) { if (PropertyChanged != null) { PropertyChanged(this, new PropertyChangedEventArgs(info)); } } public int feesAmount { get; set; } public int FeesAmount { get { return this.feesAmount; } set { if (value != this.feesAmount) { this.feesAmount = value; NotifyPropertyChanged("FeesAmount"); } } } } XAML: <DataGrid AutoGenerateColumns="False" Height="21...
Post a Comment
Read more

mvc razor textboxfor change event change another textboxfor value

Based on value of Weight, Rate , CNF & AWB it will change the value of Freight , TTLCNF anfd TTLFright . Freight= Weight*Rate; TTLCNF  = Weight*CNF; TTLFright=  Freight+ TTLCNF  + AWB; @Html.TextBoxFor(model => model.Weight, new { onChange="return GetWight(this);"}) @Html.TextBoxFor(model => model.Rate, new { onChange="return GetWight(this);"})/Kg @Html.TextBoxFor(model => model.Freight, new {disabled = "disabled" , @readonly = "readonly" ,onChange="return GetTTLFright(this);"}) @Html.TextBoxFor(model => model.CNFPK, new { onChange="return GetCNFPK(this);"}) @Html.TextBoxFor(model => model.TTLCNF, new {disabled = "disabled" , @readonly = "readonly",onChange="return GetTTLFright(this);" }) @Html.TextBoxFor(model => model.AWB, new { onChange="return GetTTLFright(this);"}) and script <script> function GetW...
Post a Comment
Read more

mvvm double click event in listview

If you want to get the double click event on a listview item you can try with this code; <ListView Grid.Row="0" Grid.RowSpan="3" Grid.Column="0" Width="250" Height="200" HorizontalAlignment="Stretch" VerticalAlignment="Top" AlternationCount="2" BorderBrush="#FFA8CC7B" ItemContainerStyle="{StaticResource alternatingStyle}" ItemsSource="{Binding FromPayerNameList}" SelectedItem="{Binding SelectedFromPayer, Mode=TwoWay}"> <ListView.ItemTemplate> <DataTemplate> <TextBlock Width="{Binding Path=ActualWidth, RelativeSource={RelativeSource FindAncestor, AncestorType={x:Type ListView}}}" Text=...
Post a Comment
Read more