locked
CRM 2011 Create Report FetchXml with Link multiple Enity RRS feed

  • Question

  • Hi all People,

    I wante to create a Report FetchXml with Multiple link-entity.

    my Senario:

    I have 3 custom entity :
    Entity1 - Entity2 - Entity3

    Entity1 to Entity2 have RelationShip 1:N
    Entity2 to Entity3 have RelationShip 1:N

    In my Report i want to retrive attribute from Entity1 to Entity3 but no RelationShip betwen the two Entity.

    Is if possible to retrieve the attribute through the Entity1 ?
    Like a join in SQL.

    Regards,

    Sunday, December 7, 2014 11:28 AM

Answers

  • Hi all,

    The solution is use a tool stunnware to create a complex FetchXML with Three layer entity.

    Because advance find not build for too complex query.

    Regards

    • Marked as answer by IDMHAND Sunday, December 7, 2014 7:18 PM
    Sunday, December 7, 2014 7:18 PM

All replies

  • Hi,

    Try to build your SQL and then put SQL into following web site to get relevant fetchXML out for this query..

    http://sql2fetchxml.com/

    see if this helps..


    MayankP
    My Blog
    Follow Me on Twitter

    Sunday, December 7, 2014 12:47 PM
    Answerer
  • Thanks Mayank for your replay,

    I will try this method.

    it's possible to use entity 2 as a parameter (entity 2 to get a reference for entity 1 and 3).

    Regards,



    • Edited by IDMHAND Sunday, December 7, 2014 1:12 PM
    Sunday, December 7, 2014 12:55 PM
  • Hi all,

    The solution is use a tool stunnware to create a complex FetchXML with Three layer entity.

    Because advance find not build for too complex query.

    Regards

    • Marked as answer by IDMHAND Sunday, December 7, 2014 7:18 PM
    Sunday, December 7, 2014 7:18 PM