Open topic with navigation

Using the query builder

You can build a custom query to choose only those fields or records you need from your source data.

To build a custom query

1. In the Scribe Workbench, on the Source menu, click Configure. The Configure Source dialog box appears.
2. From the drop-down list of connections, select the connection that represents the Web Service you want to connect to.
3. In the Configure Source dialog box, click the Custom Query option.

   Note:

   The tabs do not appear until you select Custom Query. Not all features are supported by all adapters. If an adapter does not support a function (such as sorting or filtering), the tab is unavailable.

4. Click the Data Objects tab and select a primary data object from the list of available objects.
5. Click the Fields tab.
6. Select a data object, then select a field for that data object.
7.  Click Add to add more fields.
   • Enter an alias to distinguish between fields with the same name.
   • Select a row by clicking the row heading box to the left of the row, and use the up and down arrows to move the row up or down in the list.
   • Click Add All Fields to display each field in a separate row, rather than one row marked with an asterisk.
8. Click the Filters tab and define any filters for this query.
   • Click Add Condition to add or modify a condition used to filter the query results. The Query Condition dialog box appears.
   • Click Edit Condition to modify a condition used to filter the query results. The Query Condition dialog box appears.
   • Link conditions with the AND or OR operators.
   • Use the arrow buttons to rearrange the filter conditions, if necessary.
   • Click the Query Test tab and review the XML code generated by the query builder for the objects, fields, and filters you have defined.

     Click Test/Requery to test the syntax and execution time of your query.

9. Click the Actual Query tab and view the values substituted for the variables used in the query.

   Note: The Actual Query tab only becomes available after you run a test query.

10. When you are finished creating your query, click OK.

See Also

Query Condition dialog box

TIBCO Scribe® Insight Help Library