locked
FetchXML RRS feed

  • Question

  • hi,

    I ve created a new field within dataset wizard en BID just a sum(Fields!units.Value) and now I want to see in my select :

    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
      <entity name="table">
        <attribute name="units" />

      </entity>
    </fetch>

     

    How can i do that?

     

    Monday, January 16, 2012 3:02 PM

Answers

All replies

  • Hi Javi

     

    please find the link demonstrating example of fetchxml

     http://techdetector.wordpress.com/2010/10/07/fetch-xml-and-javascript-in-crm-4-0/

    Also find a  link to fetchxml builder

    http://fetchxmlbuilder.codeplex.com/

    there is also great tool from stuntware fetch xml wizard

    http://www.stunnware.com/crm2/

    hope this helps

    dkay

    if the response answered your question, please take a minute and mark the response as an answer.

    Monday, January 16, 2012 3:09 PM
  • Hi

    Did this help?

    Please make sure to mark as answer to the response that helped you get through. This will help others with similar problem identify the answer and also close this thread as resolved.

    Thanks

    Dkay

    Monday, January 16, 2012 9:43 PM
  • Hi Javi,

    I don't know if you've noticed, but you can create a search criteria in Advanced Find and select the 'Download Fetch Xml' ribbon button in CRM2011.

    hth,

    Scott


    www.develop1.net
    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"
    Monday, January 16, 2012 9:57 PM
    Answerer
  • thank all of you for answer me.

    Scot I Know it. And I use it for as "select-fetch" template. But it is a litle primitive. I want to create a select like this.

    I have this Table
    id month units 
     1 1        24
     1 2        38
    I want a select-fetch retrieving units diference betewen  previuos month.
    Select

    T1.id,

    T1.unidades As UniCurrent,

    (Select T2.unidades

    From tabla T2

    Where T1. id = T2.id and

    T2.month = @month -1 ) As UniPreviuos,

    From

       table T1

    Where

    T1.month = @month and

     

    Wednesday, January 18, 2012 11:11 PM