FetchXML Understanding Distinct









up vote
0
down vote

favorite












I am learning FetchXML and am currently new to it.



I tried looking at the documentation located here but I did not find it very helpful



What does this line mean:



<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">


What does the mapping="logical" part mean?
What does the distinct="true" part mean?










share|improve this question



























    up vote
    0
    down vote

    favorite












    I am learning FetchXML and am currently new to it.



    I tried looking at the documentation located here but I did not find it very helpful



    What does this line mean:



    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">


    What does the mapping="logical" part mean?
    What does the distinct="true" part mean?










    share|improve this question

























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I am learning FetchXML and am currently new to it.



      I tried looking at the documentation located here but I did not find it very helpful



      What does this line mean:



      <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">


      What does the mapping="logical" part mean?
      What does the distinct="true" part mean?










      share|improve this question















      I am learning FetchXML and am currently new to it.



      I tried looking at the documentation located here but I did not find it very helpful



      What does this line mean:



      <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">


      What does the mapping="logical" part mean?
      What does the distinct="true" part mean?







      dynamics-crm fetchxml






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 9 at 16:48









      Arun Vinoth

      8,603132345




      8,603132345










      asked Nov 9 at 15:06









      LunchBox

      594317




      594317






















          1 Answer
          1






          active

          oldest

          votes

















          up vote
          1
          down vote













          As per FetchXML schema we have two enum values namely internal & logical for mapping attribute. We have to use mapping="logical" in our queries & internal may be for Platform usage (my guess).



           <xs:attribute name="mapping">
          <xs:simpleType>
          <xs:restriction base="xs:NMTOKEN">
          <xs:enumeration value="internal" />
          <xs:enumeration value="logical" />
          </xs:restriction>
          </xs:simpleType>
          </xs:attribute>


          distinct="true" will remove the duplicate values in your resultset. This is similar to SQL concept.



          Refer & read the documentation






          share|improve this answer




















            Your Answer






            StackExchange.ifUsing("editor", function ()
            StackExchange.using("externalEditor", function ()
            StackExchange.using("snippets", function ()
            StackExchange.snippets.init();
            );
            );
            , "code-snippets");

            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "1"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













             

            draft saved


            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53228271%2ffetchxml-understanding-distinct%23new-answer', 'question_page');

            );

            Post as a guest






























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            1
            down vote













            As per FetchXML schema we have two enum values namely internal & logical for mapping attribute. We have to use mapping="logical" in our queries & internal may be for Platform usage (my guess).



             <xs:attribute name="mapping">
            <xs:simpleType>
            <xs:restriction base="xs:NMTOKEN">
            <xs:enumeration value="internal" />
            <xs:enumeration value="logical" />
            </xs:restriction>
            </xs:simpleType>
            </xs:attribute>


            distinct="true" will remove the duplicate values in your resultset. This is similar to SQL concept.



            Refer & read the documentation






            share|improve this answer
























              up vote
              1
              down vote













              As per FetchXML schema we have two enum values namely internal & logical for mapping attribute. We have to use mapping="logical" in our queries & internal may be for Platform usage (my guess).



               <xs:attribute name="mapping">
              <xs:simpleType>
              <xs:restriction base="xs:NMTOKEN">
              <xs:enumeration value="internal" />
              <xs:enumeration value="logical" />
              </xs:restriction>
              </xs:simpleType>
              </xs:attribute>


              distinct="true" will remove the duplicate values in your resultset. This is similar to SQL concept.



              Refer & read the documentation






              share|improve this answer






















                up vote
                1
                down vote










                up vote
                1
                down vote









                As per FetchXML schema we have two enum values namely internal & logical for mapping attribute. We have to use mapping="logical" in our queries & internal may be for Platform usage (my guess).



                 <xs:attribute name="mapping">
                <xs:simpleType>
                <xs:restriction base="xs:NMTOKEN">
                <xs:enumeration value="internal" />
                <xs:enumeration value="logical" />
                </xs:restriction>
                </xs:simpleType>
                </xs:attribute>


                distinct="true" will remove the duplicate values in your resultset. This is similar to SQL concept.



                Refer & read the documentation






                share|improve this answer












                As per FetchXML schema we have two enum values namely internal & logical for mapping attribute. We have to use mapping="logical" in our queries & internal may be for Platform usage (my guess).



                 <xs:attribute name="mapping">
                <xs:simpleType>
                <xs:restriction base="xs:NMTOKEN">
                <xs:enumeration value="internal" />
                <xs:enumeration value="logical" />
                </xs:restriction>
                </xs:simpleType>
                </xs:attribute>


                distinct="true" will remove the duplicate values in your resultset. This is similar to SQL concept.



                Refer & read the documentation







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 9 at 16:48









                Arun Vinoth

                8,603132345




                8,603132345



























                     

                    draft saved


                    draft discarded















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53228271%2ffetchxml-understanding-distinct%23new-answer', 'question_page');

                    );

                    Post as a guest














































































                    Popular posts from this blog

                    Kleinkühnau

                    Makov (Slowakei)

                    Deutsches Schauspielhaus