meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision 		Previous revision
en:v8_0_0:designer:menus:accueil:nouvellerequete:coherence [2020/07/07 10:28]
jacobt created 		en:v8_0_0:designer:menus:accueil:nouvellerequete:coherence [2020/09/03 15:56] (current)
sylvainair
Line 1: Line 1:
-bidon+====== 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&​}}