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:rapprochement [2020/07/08 11:30] traducteur created |
en:v8_0_0:designer:menus:accueil:nouvellerequete:rapprochement [2020/09/03 15:57] (current) sylvainair |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ooko | + | ====== Matching ====== |
| + | ===== Usage ===== | ||
| + | |||
| + | 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 inquiry ===== | ||
| + | ==== Creation Screen ==== | ||
| + | |||
| + | 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. | ||
| + | |||
| + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-150017.png?nolink&550}} | ||
| + | ==== 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. | ||
| + | |||
| + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-150706.png?nolink&600}} | ||
| + | ==== Matching 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|inquiry]]. | ||
| + | |||
| + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-150801.png?nolink&500}} | ||
| + | |||
| + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-150855.png?nolink&400}} | ||
| + | |||
| + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-150945.png?nolink&300}} | ||
| + | |||
| + | {{: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}} | ||
| + | |||
| + | <WRAP round important> | ||
| + | Only "=" joints are possible. | ||
| + | </WRAP> | ||
| + | |||
| + | ==== 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]]). | ||
| + | |||
| + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-152212.png?nolink&500}} | ||
| + | * We can't sort the records. | ||
| + | * The fields used in the matching criteria are obligatorily displayed in the final report, so this screen only offers the **additional** fields. | ||
| + | |||
| + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200708-152308.png?nolink&500}} | ||
| + | |||
| + | The rest of the screen is similar. | ||
| + | |||
| + | ==== Screens not present ==== | ||
| + | |||
| + | 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#decimales_devises|Currency decimal screen]] | ||