Home Menu > New Query

The name of the query need not be unique. It just has to be unique in the directory where the query is located. This applies to the user's directory but also the shared query directory. The icon to the left of the name entry field allows you to modify the icon assigned to the query.

Restitution of data meeting selection criteria

This is the most common type of request. See dedicated page

Restitution of data that doesn't meet business rules

This type of query is appropriate for searching for anomalies. See dedicated page

Restitution of data resulting from various data sources and meeting selection criteria
See dedicated page

Consolidation of data from other queries or multiple tables
See dedicated page

Sequential execution of selected queries
See dedicated page

Direct SQL syntax entry of a script (SELECT only)
See dedicated page

Choice of data source and JDE/Oneworld environment.