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:consultation [2020/07/09 16:44] jacobt |
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}} |