meta data for this page
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation [2020/07/09 16:42] jacobt created |
en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation [2020/09/03 15:52] (current) sylvainair |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Creating a consultation ====== | + | ====== Creating an inquiry ====== |
| <WRAP round important> | <WRAP round important> | ||
| As long as you have not reached the end of all screens (the last screen being the test screen), your query will not be saved. | As long as you have not reached the end of all screens (the last screen being the test screen), your query will not be saved. | ||
| Line 9: | Line 8: | ||
| In the case of JDE/World data sources, and the environment is required. Objects and data will be retrieved from this environment. | In the case of JDE/World data sources, and the environment is required. Objects and data will be retrieved from this environment. | ||
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:f1128b5bb816253b7c2c62a07b120b8d.png?nolink&500}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-164959.png?nolink&500}} |
| ===== Selection of tables and subqueries ===== | ===== Selection of tables and subqueries ===== | ||
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:f1128b5bb816253b7c2c62a07b120b8d.png?nolink&500}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-164959.png?nolink&500}} |
| [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:choixtables|Detailed page]] | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:choixtables|Detailed page]] | ||
| Line 20: | Line 19: | ||
| ==== Joints === | ==== Joints === | ||
| - | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:jointures|{{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200615-171444.png?nolink&500}}]] | + | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:jointures|{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-165409.png?nolink&500}}]] |
| [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:jointures|Detailed page]] | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:jointures|Detailed page]] | ||
| Line 28: | Line 27: | ||
| It is on this screen "Extraction according to the following rule" that the filters on the data will be made, using [[:en:v8_0_0:opmanage:start|operations]] or [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:parametres|parameters]]. [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:criteres|see detailed page]]. | It is on this screen "Extraction according to the following rule" that the filters on the data will be made, using [[:en:v8_0_0:opmanage:start|operations]] or [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:parametres|parameters]]. [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:criteres|see detailed page]]. | ||
| - | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:criteres|{{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200615-165803.png?nolink&500}}]] | + | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:criteres|{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-165517.png?nolink&500}}]] |
| ===== Field Selection ===== | ===== Field Selection ===== | ||
| - | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:champs|{{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200615-174455.png?nolink&500}}]] | + | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:champs|{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-165622.png?nolink&500}}]] |
| [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:champs|Detailed page]] | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:champs|Detailed page]] | ||
| Line 38: | Line 37: | ||
| ===== Appendices ===== | ===== Appendices ===== | ||
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200615-174935.png?nolink&500}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-170140.png?nolink&500}} |
| For JDE/World data sources, it is possible to retrieve the annexes. | For JDE/World data sources, it is possible to retrieve the annexes. | ||
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200618-161022.png?nolink&}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-170120.png?nolink&450}} |
| The Generic Text Cible (ex GT4201A) and the field or combination of fields that make up the key must be specified. | The Generic Text Cible (ex GT4201A) and the field or combination of fields that make up the key must be specified. | ||
| - | |||
| - | <WRAP round todo> #TODO: add example output with appendices. </WRAP> | ||
| ===== Currency decimals ===== | ===== Currency decimals ===== | ||
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200619-144320.png?nolink&500}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-170314.png?nolink&500}} |
| **If you uncheck the box** ''Use the number of decimals from the data dictionary for currency amounts'', the concerned fields will be displayed with the **number of decimal places** defined in the **data dictionary** (usually 2 decimals). | **If you uncheck the box** ''Use the number of decimals from the data dictionary for currency amounts'', the concerned fields will be displayed with the **number of decimal places** defined in the **data dictionary** (usually 2 decimals). | ||
| Line 56: | Line 53: | ||
| **Otherwise** Vigilens will use **the number of decimal places defined in the currency**. To find the currency and thus the right number of decimal places to display, the user must define whether the amount depends on **the company code currency** (the standard cost of an item for example) or **the transaction currency** (the amount of a sales order for example). | **Otherwise** Vigilens will use **the number of decimal places defined in the currency**. To find the currency and thus the right number of decimal places to display, the user must define whether the amount depends on **the company code currency** (the standard cost of an item for example) or **the transaction currency** (the amount of a sales order for example). | ||
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200619-144729.png?nolink&500}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-170446.png?nolink&500}} |
| <WRAP round important> | <WRAP round important> | ||
| Line 76: | Line 73: | ||
| ===== Parameters ===== | ===== Parameters ===== | ||
| - | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:parametres|{{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200629-150912.png?nolink&500}}]] | + | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:parametres|{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-170601.png?nolink&500}}]] |
| [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:parametres|Detailed page]] | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:parametres|Detailed page]] | ||
| Line 82: | Line 79: | ||
| ===== Restitution ===== | ===== Restitution ===== | ||
| - | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution|{{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200615-174809.png?nolink&500}}]] | + | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution|{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-170656.png?nolink&500}}]] |
| [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution|Detailed page]] | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution|Detailed page]] | ||
| Line 88: | Line 85: | ||
| ===== Finalization and testing ===== | ===== Finalization and testing ===== | ||
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-101452.png?nolink&500}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-170736.png?nolink&500}} |
| + | |||
| + | |||
| + | Congratulations, you're almost at the end! On this last screen, you can launch a test with the button of the same name. The output will be of type "Restitution in interactive mode". If the query uses parameters, they will be requested when the test is run. | ||
| + | |||
| + | <WRAP round tip> | ||
| + | As long as you don't exit the series of query creation/modification screens, the test execution parameters are kept. In the development phase, you can easily replay the last test with the same parameters. </WRAP> | ||
| + | If you want to do a quick test, you can choose with the checkboxes to retrieve only a few lines or simply count the records. | ||
| + | Finally, click on ''Finish'', the query is saved. | ||