====== 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]]