Admin Site
      Back to home
      1. OmniByte Self-Help
      2. FormsPro
      3. Admin Site

      Creating a Data Set Using an XML Query

      How to create a data set using an XML query

      If you're working with IFS FSM or another system that provides data in XML format, you can create a data set using the XML Query data origination type.

      An XML Query allows you to search for, retrieve, or filter data that is stored in XML (Extensible Markup Language)—a common format used to structure and exchange information between systems. XML data is organized in a hierarchical structure with tags, making it ideal for representing nested or grouped information like records, categories, and related data.

      By creating a data set that uses XML Query, your form can automatically access and display specific pieces of XML data from your connected system—without requiring manual input from users. This is especially useful when you're working with systems like IFS FSM that return data in XML format rather than a traditional database structure.

      This procedure outlines the basic steps for creating a data set using XML Query. For more detailed information about data sets, see Creating a Data Set.

      1. From the Reusable Components menu, select Data Sets. Click New Data Set. The Data Set Designer opens.
      2. From the Data Origination field, select XML Query. 
      3. Enter the XML query to retrieve the data fields. 
      4. Click Generate Data Fields to run the query and display a subset of the data to help you determine whether the query is correct. 
      5. Click Save to save the data set. You can now begin using it in your forms. See Adding a Data Set to an Input and Adding a Data Set to a Dynamic Table for more information.