SQL query tool

This code is used to identify a request.

Use this field to assign a description to each record.

This title, which describes the record, is used in some screens or records when there is not enough space to display the long title.

Select this checkbox to activate the current record.

Inactive records keep their content and configuration but cannot be used by recalling their code:

• On other records such as documents and settings
• On mass processes

Authorizations for a given function can restrict the creation of an active record. In this case, the checkbox is disabled by default. It can only be modified by an authorized user or through a signature workflow.

This field controls how your query displays in inquiry mode. Three options are available:

• Normal: Displays the query results only if you have previously executed the query. If you don't select this option, each user runs the query independently, generating a private dataset that others cannot view.

• Shared: Allows results generated by one user to be visible to other users. This option is useful for large queries: one user runs the query, and others can access the shared results.

  Limit the execution to a single user. Others should only view the results. For very large queries, run in batch mode using the CALALH batch task code .
• Recalculated: Results are never displayed automatically. You need to refresh the data or re-enter criteria to view updated results. This query type is ideal for data that becomes obsolete quickly, as it avoids unnecessary reloads.

This indicator defines how data will be displayed on the screen. The available display modes are as follows:

• Character:  Data is displayed exclusively in a grid format.
• Character or Graph: Data can be displayed either as a grid or as a graph. You can select the position in the Default display field.
• Character and Graph:Data is displayed in both grid and graph formats simultaneously. You can define the graph’s position relative to the grid in the Graphical position field.
• Graph: Data is displayed exclusively in graphical format.

This setting defines how the graphical representation is positioned relative to the grid when the data display mode allows both formats.

• If the representation is Character or Graph, select the table or graph display.
• If the representation is Character and Graph, define the position of the graph relative to the data grid.

An activity code is used to:

• Make an element optional in the dictionary if the value associated with the activity code is null

• Identify the specific/custom elements if they are marked with a code starting with X, Y, or Z

Define the report code associated with the File / List function from the query inquiry.

If no report code is specified, the ALISTE report is used, which applies a standard page format.

You can duplicate this generic report and adjust the page format to create a custom report tailored to the inquiry.

The report code entered here can also be linked to a set of print codes using the dedicated function.

Define the report code associated with the File / List function from the query inquiry.

If no report code is specified, the ALISTE report is used, which applies a standard page format.

You can duplicate this generic report and adjust the page format to create a custom report tailored to the inquiry.

The report code entered here can also be linked to a set of print codes using the dedicated function.

Define the report code associated with the File / List function from the query inquiry.

If no report code is specified, the ALISTE report is used, which applies a standard page format.

You can duplicate this generic report and adjust the page format to create a custom report tailored to the inquiry.

The report code entered here can also be linked to a set of print codes using the dedicated function.

Define the number of logical lines displayed per page in the inquiry screen generated by the query designer.

If the specified number exceeds the available physical display space, a vertical scroll bar appears on the right side of the grid.

Navigation buttons at the top of the screen allow you to move between logical pages (First, Previous, Next, Last).

Specify the maximum number of lines to return.

This corresponds to the query parameter maxrows, which stops the search once the specified number of rows meeting the conditions is found in the database.

These rows are then sorted, but the database does not guarantee that the retrieved rows are the first N in the final sort order.

This parameter is an optimization to reduce database load.

You can make a classification criterion available for use in queries.

Use this field to fix the first X columns of a grid when horizontal paging is enabled.

Specify the maximum execution time for the search in seconds. If this time limit is reached, the search stops automatically.

This helps avoid long wait times, especially when setting up a new query.

Enter your query in standard SQL syntax recognized by the database.

Key points:

• You can enter any Select statement, including complex queries, provided the number of returned fields does not exceed the maximum allowed.

• The NOMCHAMP(index) field in the NOMTABLE table is stored in the database as NOMCHAMP_indice in the NOMTABLE tables, where the index values range from 0 to N-1 (N being the field’s dimension).

  For example, you can write:

  Copy

  Select LOGIN_0, CHEF_2 From AUTILIS
  Where USR_0 like %1%
  Order by CREDAT_0

• In this type of query, you can define parameters using the %N% syntax, where N corresponds to the parameter number defined in the Parameters grid (%1% in the previous example). These parameters are entered via the Criteria button during query execution.

This data type specifies how the data displays.

For a local menu, enter the corresponding menu number.

If the selected data type is linked to an object, a tunnel to the object management screen will be available during the inquiry.

Specify the local menu number used to display the numerical value of the corresponding column returned by the query.

You can only modify this field if the representation mode in the header is not set to Character. It specifies how the field is used in the graphical representation.

Possible values:

• For alphanumeric fields:

  • None: The field is not used in the graph.

  • Label: The field is used as the graph title.

    Note: Only one line in the grid can have the value Label. To assign it to another line, you must set the existing Label line back to None.

• For numeric fields:

  • None: The field is never displayed in the graph.

  • Value: The field can be used as a data series in the graph.

  • Default:

    • If the graph (defined in the last tab) displays multiple series, all fields marked Default will display (unless already shown).

    • If the graph does not display multiple series, the column for the first field marked Default will display (or the first one encountered if none is declared).

You can only edit this field:

• if the representation method chosen in the header is not Character.
• on the numeric fields where a value will display.

Used to manage graph combinations when the selected graph type (defined in the graphical parameters) supports multiple series, even of different types.

If the graph type does not allow multiple series, this setting is ignored.

Available combinations include:

• Type = Multi graph, Default graph=Lines, Representation=Multi
• Type = Multi graph, Default graph=Bars, Representation=Multi

The rule is as follows :

• Defaultmeans that the series will use the default graph type defined in the last tab (Bars or Lines in this case).
• Bar or Line forces the series to use the corresponding presentation style.

If this field is filled in, you can enter a parameter with a title matching this field before executing the query via the Criteria button.

You can reference this parameter in the query body using the %N% syntax, where N is the line number of the parameter in the Parameters grid.

This data type simplifies the corresponding parameter's entry.

• When a type is specified, format validation is applied automatically.

• If the data type is linked to an object, the corresponding selection window becomes available.

Specify the local menu number used to enter the parameter value.

You can enter a default value for the parameter.

You can use this field when the grid contains multiple numeric values that can be displayed graphically. It supports two options:

• Single graph: Displays one column of values at a time, with a selector to choose the column.
• Multi-graph: Displays all columns together, combined according to the setting defined in the Representation parameter.

When multiple series are displayed in a graph, provided they share the same presentation style and are not of the sector type, you can define how their values are combined by selecting one of the following options

• Multi: Displays the values of each series side by side. Each series displays in a different color.

• Cumulative: Stacks the values vertically to show a total.

• Comparative: Displays the series in relative proportions, keeping the overall graph height constant.

This field defines the type of graphical representation used to display the data. Options include Bars, Lines, Area, or Sectors. An image displays based on the selected option.

If only one data series is available, the default representation is determined by this parameter.

If multiple series are present, you can mix presentation modes (for example, one series as bars, another as lines). In this case, each series uses the value specified in the Representation field in the grid:

• If set to Bar or Line, that mode is applied to the series, provided it is compatible with the default representation. Mixing Sectors with Bars or Lines is not allowed.
• If set to Default, the series uses the default graphical representation.

When only one series is displayed, a graph type selector is available, allowing the user to choose a different presentation mode.

Visual representation of the previously entered information.