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:rapprochement [2020/07/08 14:43] jacobt |
en:v8_0_0:designer:menus:accueil:nouvellerequete:rapprochement [2020/09/03 15:57] (current) sylvainair |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== Reconciliation ===== | + | ====== Matching ====== |
| - | ==== Usage === | + | ===== Usage ===== |
| - | Reconciliation allows you to do what [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|consultation]] does not allow: to have in the same query several data sources coming from several databases. | + | Matching allows you to do what [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|inquiry]] does not allow: to have in the same query several data sources coming from several databases. |
| - | ===== Difference from consultation ========== | + | ===== Difference from inquiry ===== |
| - | ==== Creation Screen ===== | + | ==== Creation Screen ==== |
| - | When the reconciliation type is selected, the choice of the data source is grayed out, as well as the checkbox for time out and automatic disconnection. | + | When the matching type is selected, the choice of the data source is grayed out, as well as the checkbox for time out and automatic disconnection. |
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200707-174714.png?nolink&650x}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-150017.png?nolink&550}} |
| - | + | ==== Choice of Queries ==== | |
| - | ==== Choice of Queries === | + | |
| At the time of [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:choixtables|data source selection]], no table can be selected, only queries. | At the time of [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:choixtables|data source selection]], no table can be selected, only queries. | ||
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200707-174849.png?nolink&650x}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-150706.png?nolink&600}} |
| - | + | ==== Matching Criteria ==== | |
| - | ==== Reconciliation Criteria === | + | |
| - | This is the analog for [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:jointures|the joints screen]] for a [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|consultation]]. | + | This is the analog for [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:jointures|the joints screen]] for a [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|inquiry]]. |
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200707-175121.png?nolink&500x}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-150801.png?nolink&500}} |
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-142521.png?nolink}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-150855.png?nolink&400}} |
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-142603.png?nolink}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-150945.png?nolink&300}} |
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-142628.png?nolink}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-151720.png?nolink&300}} |
| {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-142749.png?nolink&500}} | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-142749.png?nolink&500}} | ||
| Line 35: | Line 33: | ||
| </WRAP> | </WRAP> | ||
| - | ==== Field Selection === | + | ==== Field Selection ==== |
| - | Here again, the screen differs from the [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|consultation]] ([[:en:v8_0_0:designer:menus:accueil:nouvellerequete:champs|see field selection]]). | + | Here again, the screen differs from the [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|inquiry]] ([[:en:v8_0_0:designer:menus:accueil:nouvellerequete:champs|see field selection]]). |
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200707-175746.png?nolink&500}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-152212.png?nolink&500}} |
| * We can't sort the records. | * We can't sort the records. | ||
| - | * The fields used in the reconciliation criteria are obligatorily displayed in the final report, so this screen only offers the **additional** fields. | + | * The fields used in the matching criteria are obligatorily displayed in the final report, so this screen only offers the **additional** fields. |
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-143731.png?nolink&500}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-152308.png?nolink&500}} |
| The rest of the screen is similar. | The rest of the screen is similar. | ||
| - | === Screens not present === | + | ==== Screens not present ==== |
| - | The following screens of the [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|consultation]] are absent when creating a reconciliation : | + | The following screens of the [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|inquiry]] are absent when creating a matching : |
| * [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation#annexes|appendix screen]] | * [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation#annexes|appendix screen]] | ||
| * [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation#decimales_devises|Currency decimal screen]] | * [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation#decimales_devises|Currency decimal screen]] | ||