====== Home Menu > New Query ======

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200721-142904.png?nolink&40}}

===== Focus =====

<WRAP round important>
Depending on what is selected in the [[:en:v8_0_0:designer:start#panneaux|panels]], the behavior of the ''New request'' button changes, see [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:focus|this page]] for more details.
</WRAP>


===== Name of the 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. \\ 
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200721-143421.png?nolink&300}}

===== Query Type =====

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200721-143551.png?nolink&500}}


==== Inquiry ====

**Restitution of data meeting selection criteria**\\ 
This is the most common type of request. [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|See dedicated page]]

==== Consistency ====

**Restitution of data that doesn't meet business rules**\\ 
This type of query is appropriate for searching for anomalies. [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:coherence|See dedicated page]]

==== Matching ====
**Restitution of data resulting from various data sources and meeting selection criteria**\\ 
[[:en:v8_0_0:designer:menus:accueil:nouvellerequete:rapprochement|See dedicated page]]


==== Union ====

**Consolidation of data from other queries or multiple tables**\\  
[[:en:v8_0_0:designer:menus:accueil:nouvellerequete:union|See dedicated page]]

==== Query Group ====

**Sequential execution of selected queries**\\  
[[:en:v8_0_0:designer:menus:accueil:nouvellerequete:groupederequetes|See dedicated page]]

==== SQL Entry ====

**Direct SQL syntax entry of a script __(SELECT only)__**\\  
[[:en:v8_0_0:designer:menus:accueil:nouvellerequete:sql|See dedicated page]]

===== Data Source =====

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200721-143808.png?nolink&500}}

Choice of data source and JDE/Oneworld environment.

Choice of the data source and (possibly) the JDE/Oneworld environment (for the data sources concerned). 
 
<WRAP center round important> 
The "Allow environment modification at runtime" check box allows to allow or disallow the modification of the environment defined in the query when running in Web mode. 

**This checkbox only appears after you have selected the environment**
</WRAP>
===== Other Options ===== 

==== Automatic disconnect ====

By default, any database connection remains active until :

  * the closing of the application
  * a connection to another database
This saves time during, for example, successive executions on the same database.\\ 

When this box is checked, the connexion is killed just after the query runs.

==== Time out ====

Allows you to define a specific timeout for the request. This timeout cannot in any case exceed the possible timeout defined for the Vigilens user or the group to which he belongs.

<WRAP round tip>
When creating / adjusting a query, it can be interesting to define, temporarily, a relatively short timeout to facilitate testing.
</WRAP>


==== Data Recovery Optimization ====

This option saves some time during the data recovery phase by limiting the dialog box redisplay. However, it does not allow you to monitor the progress of data recovery or cancel it if necessary.\\