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:coherence [2020/07/09 15:23] jacobt created |
en:v8_0_0:designer:menus:accueil:nouvellerequete:coherence [2020/09/03 15:56] (current) sylvainair |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Creating a consistency query ====== | ====== Creating a consistency query ====== | ||
===== Principle ===== | ===== Principle ===== | ||
+ | A consistency query is used to find anomalies in the data. Technically, the same result could be obtained by constructing a simple [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|inquiry]], but it is often easier to express the criteria that records must meet than those that they must not meet. | ||
- | A consistency query is used to find anomalies in the data. Technically, the same result could be obtained by constructing a simple [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|consultation]], but it is often easier to express the criteria that records must meet than those that they must not meet. | + | The steps for creating a consistency query are identical to those for a [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|inquiry]], except for one difference: the choice of filters. |
- | + | ||
- | The steps for creating a consistency query are identical to those for a [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation|consultation]], except for one difference: the choice of filters. | + | |
In the criteria entry interface, we find the classic tools ([[:en:v8_0_0:designer:menus:accueil:nouvellerequete:criteres|see dedicated page]]), with in addition a button: {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-140855.png?nolink&}} It allows you to copy a selected criterion from the ''If...'' area to the ''Then...'' area or vice versa. | In the criteria entry interface, we find the classic tools ([[:en:v8_0_0:designer:menus:accueil:nouvellerequete:criteres|see dedicated page]]), with in addition a button: {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-140855.png?nolink&}} It allows you to copy a selected criterion from the ''If...'' area to the ''Then...'' area or vice versa. | ||
Line 10: | Line 9: | ||
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-152308.png?nolink&550}} | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-152308.png?nolink&550}} | ||
- | Contrary to consultation, there are 2 zones to enter criteria: | + | Contrary to inquiry, there are 2 zones to enter criteria: |
* **IF ...** | * **IF ...** |