meta data for this page
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:v8_0_0:designer:menus:accueil:nouvellerequete:start [2020/09/03 15:55] sylvainair [Reconciliation] |
en:v8_0_0:designer:menus:accueil:nouvellerequete:start [2021/02/01 16:14] (current) sylvainair [Data Source] |
||
|---|---|---|---|
| Line 23: | Line 23: | ||
| **Restitution of data meeting selection criteria**\\ | **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]] | This is the most common type of request. [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|See dedicated page]] | ||
| ==== Consistency ==== | ==== Consistency ==== | ||
| - | **Restitution of data that doesn't meet business rules**\\ | + | **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]] | This type of query is appropriate for searching for anomalies. [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:coherence|See dedicated page]] | ||
| Line 42: | Line 40: | ||
| [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:union|See dedicated page]] | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:union|See dedicated page]] | ||
| - | ==== Group of queries ==== | + | ==== Query Group ==== |
| **Sequential execution of selected queries**\\ | **Sequential execution of selected queries**\\ | ||
| [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:groupederequetes|See dedicated page]] | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:groupederequetes|See dedicated page]] | ||
| - | ==== SQL Input ==== | + | ==== SQL Entry ==== |
| **Direct SQL syntax entry of a script __(SELECT only)__**\\ | **Direct SQL syntax entry of a script __(SELECT only)__**\\ | ||
| Line 58: | Line 56: | ||
| Choice of data source and JDE/Oneworld environment. | 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 ===== | ===== Other Options ===== | ||
| ==== Automatic disconnect ==== | ==== Automatic disconnect ==== | ||
| - | {{section>projet:todo#todo_009&nofooter&noeditbutton}} | + | 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 ==== | ==== Time out ==== | ||
| - | {{section>projet:todo#todo_009&nofooter&noeditbutton}} | + | 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 ==== | ==== Data Recovery Optimization ==== | ||
| - | {{section>projet:todo#todo_009&nofooter&noeditbutton}} | + | 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.\\ |