For Adapter connections that do not support SQL, the Custom Query option in the Configure Source dialog box enables you to filter the source data, select a subset of fields from an object, or join multiple objects.
If custom queries are supported by the Adapter connection, the following tabs display in the Custom Query window. Not all features are supported by all Adapters. If the Adapter does not support the functionality, such as Sort or Filters, the tab is unavailable.
After you click OK in the Configure Source dialog box, the result set that you choose displays in the Source pane of the main window.
See also