meta data for this page
  •  

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
en:v8_0_0:designer:menus:accueil:nouvellerequete:union [2020/07/21 14:48]
jacobt 		en:v8_0_0:designer:menus:accueil:nouvellerequete:union [2020/09/10 16:55] (current)
sylvainr [Screens out]
Line 1: Line 1:
-====== UNION Request ​======+====== UNION query======
 ===== Usage ===== ===== Usage =====
  
 This type of query is similar to the [[https://​en.wikipedia.org/​wiki/​Set_operations_(SQL)#​UNION_operator|SQL UNION]] function. This type of query is similar to the [[https://​en.wikipedia.org/​wiki/​Set_operations_(SQL)#​UNION_operator|SQL UNION]] function.
 +These queries are used to display the rows extractedby two (or more) subqueries.
 ===== Difference from query ===== ===== Difference from query =====
  
 ==== Selecting Subqueries ==== ==== Selecting Subqueries ====
  
-As for the [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​rapprochement|reproach]],  +As for the [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​rapprochement|matching], at [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​choixtables|data source selection]],​ no table can be selected, only queries.
-At the time of [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​choixtables|data source selection]],​ no table can be selected, only queries.+
  
 {{:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200625-144813.png?​nolink&​500}} {{:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200625-144813.png?​nolink&​500}}
 +
 +<WRAP round important>​
 +All subqueries must use the same data source as the one selected in the union query.
 +</​WRAP>​
 +
 +<WRAP round alert>
 +Vigilens checks that the structures of the subqueries are consistent with each other, i.e. :
 +  * they have the same number of fields
 +  * the field types (in the order they appear) are identical
 +</​WRAP>​
  
 ==== Screens out ==== ==== Screens out ====
  
-The following screens of the [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​consultation|consultation]] are absent when creating a UNION :+The following screens of the [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​consultation|inquiry]] are absent when creating a UNION :
   * [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​jointures|Join screen]]   * [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​jointures|Join screen]]
   * [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​criteres|Criteria screen]]   * [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​criteres|Criteria screen]]
   * [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​consultation#​annexes|Appendices screen.]]   * [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​consultation#​annexes|Appendices screen.]]
   * [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​consultation#​decimales_devises|Currency decimal screen]]   * [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​consultation#​decimales_devises|Currency decimal screen]]
 +