2 Replies Latest reply on Sep 16, 2010 8:14 AM by fireworks12

    How to get Query Multiple to return standard XML

    fireworks12

      Hi,

       

      I'm looking for a way to get the Query Multipe to return the XML with the correct XML standard convention for nulls from the datastore.

       

      Query Multiple currently returns:

       

      <FacilityList>
          <Facility>
              <Id>1111</Id>
              <Name>Auto Fac Name 2 20100901</Name>
              <Alias>AFN</Alias>
              <PhysicalAssetBusinessNumber/> <--blank in database.  XML fine.

              <PhoneNumber>null</PhoneNumber> <--null in database but this is wrong for XML

          </Facility>

      </FacilityList>

       

      Should be:

       

      <FacilityList>
           <Facility>
               <Id>1111</Id>
               <Name>Auto Fac Name 2 20100901</Name>
               <Alias>AFN</Alias>
               <PhysicalAssetBusinessNumber/>

               </PhoneNumber xsi:nil="true">

          </Facility>

      </FacilityList>

       

       

      Any suggestions or explanations as to why this is the case?

       

      Thanks!