====== Creating a consistency query ======
===== 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.

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.

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.

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-152308.png?nolink&550}}

Contrary to inquiry, there are 2 zones to enter criteria:

  * **IF ...**
  * **Then...**<WRAP round important> it's mandatory to enter **__ at least__** a criterion in ''If...'' and one in ''Then...'' </WRAP>
===== Example =====

  * Criterion ''If...'' ⇒ SHKCOO = '00001'.
  * Criterion ''Then'' ⇒ SHDCTO = 'SQ'

==== Case 1 ====

  * Criterion ''If...'' set to ''Respected''.
  * Criterion ''Then...'' set on ''Respected'' ⇒ We get the records for which SHKCOO = '00001' and SHDCTO <> 'SQ'.

{{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-112058.png?nolink&}}

=== Case 2 ===

  * Criterion ''If...'' set to ''Respected''.
  * Criterion ''Then...'' positioned on ''Not respected'' ⇒ We retrieve the records for which SHKCOO = '00001' and SHDCTO = 'SQ'.

{{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-112131.png?nolink&}}

=== Case 3 ===

  * Criterion ''If ...'' set to ''Not met''.
  * Criterion ''So...'' positioned on ''Respected'' ⇒ We retrieve the records for which SHKCOO <> '00001' and SHDCTO <> 'SQ'...

{{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-112157.png?nolink&}}

=== Case 4 ===

  * Criterion ''If ...'' set to ''Not met''.
  * Criterion ''Then...'' positioned on ''Not respected'' ⇒ We retrieve the records for which SHKCOO <> '00001' and SHDCTO = 'SQ' (in this case none)

{{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-112242.png?nolink&}}