Entrar
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
FetchXml Conditions on linked entities

Proposed Answer FetchXml Conditions on linked entities

  • quarta-feira, 9 de março de 2011 23:10
     
      Contém Código
    Entrar para Votar
    0

    Hi, I am wanting to add an some conditions in an OR filter where these conditions are for attributes on different entities.

    For example, something like:

    <fetch mapping='logical' page='1' count='10'>
 <entity name='account'>
    
 <all-attributes />
    
 <link-entity name='systemuser' to='createdby' alias='sysuser'>
    
  <all-attributes />
    
 </link-entity>
    
 <filter type='or'>
    
  <condition attribute='lastname' operator='like' value='%mar%' />
    
  <condition attribute='sysuser.lastname' operator='like' value='%mar%' />
    
 </filter>
    
 </entity>
    
</fetch>
    Is there a way to make this kind of filter work?
     

Todas as Respostas

  • quarta-feira, 9 de março de 2011 23:54
     
     
    Entrar para Votar
    1

    Nope. FetchXml doesn't support doing "OR"s between different entities (a problem I've run into many times).  I think you could get a similar query that filters on the user's fullname by doing this:

    <filter type='or'>
      <condition attribute='lastname' operator='like' value='%mar%' />
      <condition attribute='createdbyname' operator='like' value='%mar%' />
    </filter>

    This works because the user's fullname (i.e., the primary field of the systemuser entity) is included in the account view as "createdbyname".

    Another option would be to create a plug-in that would set a custom "created by last name" field on the account.  But of course then you're de-normalizing your data so you have to decide if its really worth it.

    Erik Pool | Avanade XRM | http://erikpool.blogspot.com
     
  • quinta-feira, 10 de março de 2011 00:12
     
     
    Entrar para Votar
    0

    Thanks for the reply.

    In my case, I'm not actually wanting the condition based on createby (i just used that as my example because I copied it from MSDN and made some minor changes).

    Adding a field and creating a plugin to populate is one way of doing this, but obviously this is something I'd prefer to avoid.

     
  • quinta-feira, 10 de março de 2011 11:37
     
     Resposta Proposta Contém Código
    Entrar para Votar
    1

    I think you should be able to do this. for example:-

     <fetch count='1' mapping='logical'>
 <entity name='annotation'>
 <attribute name='annotationid'/>
 <attribute name='createdon'/>
 <attribute name='documentbody'/>
 <attribute name='filename'/>
 <attribute name='isdocument'/>
 <attribute name='mimetype'/>
 <attribute name='notetext'/>
 <order attribute='createdon' descending='true'/>
 <filter type='or'>
  <condition attribute='documentbody' operator='not-null'/>
  <condition attribute='mimetype' operator='eq' value='text/xml'/>
  <condition attribute='createdon' operator='on-or-before' value='3/4/2011'/>
 </filter>
 <link-entity name='customentity' from='customentityid' to='objectid'>
  <attribute name='lastapproveddate'/>
  <filter type='or'>
  <condition attribute='customentityid' operator='eq' value='e539f9e3-e946-e011-9e01-000c2977dd1b'/>
  </filter>
 </link-entity>
 </entity>
</fetch>

    You can download fetchxml builder. It will make thing easier. 

    Regards Faisal
    • Sugerido como Resposta Jim Glass Jr quinta-feira, 10 de março de 2011 18:48
    •  
     
  • quinta-feira, 10 de março de 2011 14:26
     
     
    Entrar para Votar
    1

    Think Luke requirement is something as below.

    Need to obtain the accounts whose

    a) Account name is ABC

    (OR)

    b) Last name of the user who created the account is ABC

    -------------------------------------------------------------------

    Luke - Correct me if i had wrongly understood it.

    If this is going to be the requirement, then I hope Fisal structure is not going to help you. fetchxml is not going to help us. By default fetchxml dosent provide option to combine (AND or OR) filter from primary entity and link entity.

    You can also try to perform the same form advanced find view. You will be provide with an alert

    "To group conditions, select two or more conditions or groups that are listed under the same entity, and then click Group And or Group Or. Individual conditions that are already grouped cannot be included in new groups, and related entity conditions or groups cannot be grouped with the parent entity conditions or groups."

     
  • quinta-feira, 10 de março de 2011 15:07
     
     Resposta Proposta
    Entrar para Votar
    1
    use createdbyidname in condition
    Regards Faisal
    • Sugerido como Resposta Jim Glass Jr quinta-feira, 10 de março de 2011 18:48
    •  
     
  • segunda-feira, 21 de março de 2011 20:53
    Moderador
     
     
    Entrar para Votar
    0

    I'm running into a similar situation although I am using QueryExpression to retrieve with this criteria:

    1. PrimaryEntity.Name = "abc" OR RelatedContact.Name = "abc".

    I can create a LinkEntity Criteria but then I cannot create an OR group with another filter on the primary entity. Is there a workaround or is such a query just not possible?

     
  • terça-feira, 20 de março de 2012 20:21
     
     
    Entrar para Votar
    0
    I have the similar issue. Is there any solution for this?
     
  • terça-feira, 31 de julho de 2012 11:09
     
     
    Entrar para Votar
    0
    Does somebody knows why this isn't supported?

    Greivin Britton

     
  • segunda-feira, 20 de agosto de 2012 11:23
     
     Resposta Proposta
    Entrar para Votar
    0

    You can set up a custom attribute on the related entity to hold the value of the primary entity.  This value can then be maintained via plugins so it is always up to date.  Then you can set up an OR statement at the related entity level.

    • Sugerido como Resposta itara terça-feira, 11 de setembro de 2012 07:01
    •