0 Replies Latest reply: Aug 2, 2012 1:18 PM by 673776 RSS

    Sample XML and Schema Problem After Regenerate

    673776
      We use a PeopleSoft query as our data source for our XML Publisher reports. We added a field to a PS query then regenerated the XML (Reporting Tools-XML Publisher-Data Source). The regenerated XML now has the PS query record letter prefixed to each field name. For example, previously the XML looked like this:

      <FIELD1>FIELD1</FIELD1>

      After adding the new field and regenerating the XML, it now looks like this:

      <A.FIELD1>A.FIELD1</A.FIELD1>

      As a test we removed the new field from the query and regenerated the XML. Now the XML reads like this:<FIELD1>FIELD1</FIELD1>. There is only one table in the query. Why would one new field change the XML to this?
      <A.FIELD1>A.FIELD1</A.FIELD1>

      Thank you.