FetchXml To Return Records Assigned to Set Users -or- Team

Foreslået svar FetchXml To Return Records Assigned to Set Users -or- Team

  • 12. marts 2012 19:16
     
     

    Is there any way to select records where the record is owner by a specific team OR by users where I am the current manager?  CRM does not seem to support this because it involves an OR condition across a linked-entity and so the only other way to do it is to manage the list of people and the team with an Owner equals <list> which is obviously not ideal in a large and changing organization.

    Is there anyway around this - I'm a bit stunned that I cannot say where owner = team OR owner = users I manage - it seems like a simple thing to expect to need to do.

Alle besvarelser

  • 10. maj 2012 04:30
     
     Foreslået svar

    Hi LCVS,

    Are you doing this programmatically through LINQ?

    A workaround for this is to run two set of queries. One that is getting all records owned by team A. And then, another query that gets all records owned by particular users.

    You'll then need to merge these results together and filter out the duplicate records.

    I hope this helps. If my response answered your question, please mark the response as an answer.


    Dimaz Pramudya - CRM Developer - CSG (Melbourne) www.xrmbits.com http://twitter.com/xrmbits