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:restitution [2020/07/22 11:14]
sylvainair 		en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution [2021/09/22 17:50] (current)
sabane [Email]
Line 5: Line 5:
   * Batch output: all queries of a directory are run   * Batch output: all queries of a directory are run
  
-These two modes are setup separately. ​+These two modes are set up separately. ​
  
 ===== Interactive Output ===== ===== Interactive Output =====
Line 26: Line 26:
 {{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-111056.png?​nolink}}\\ ​ {{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-111056.png?​nolink}}\\ ​
 {{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-111134.png?​nolink}}\\ ​ {{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-111134.png?​nolink}}\\ ​
 +
 [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​restitution:​excel|See dedicated page.]] [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​restitution:​excel|See dedicated page.]]
 +
 +=== PDF file ===
 +
 +{{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-111506.png?​nolink}}
 +
 +[[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​editeurimpression:​start|See dedicated page.]]
 +
 +=== Text File ===
 +{{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-111700.png?​nolink}}
 +
 +=== Email ===
 +{{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-111729.png?​nolink}}
 +
 +
 +<WRAP center round tip>
 +It is possible to use parameters to populate the list of recipients
 +</​WRAP>​
 +=== Export to database ===
 +{{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-111815.png?​nolink}}
 +
 +==== Output layout ====
 +
 +When printing, for example in a PDF, you can choose one of two types of output formats: grid format or report.
 +
 +=== Result Grid setup ===
 +
 +When you choose the [[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​restitution|interactive output]], click on ''​Setup...''​
 +
 +{{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-112226.png?​nolink}}\\ ​
 +{{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-112254.png?​nolink}}\\ ​
 +{{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-112333.png?​nolink}}\\ ​
 +{{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-112353.png?​nolink}}\\ ​
 +{{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-112412.png?​nolink}}\\ ​
 +{{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-112437.png?​nolink}}\\ ​
 +
 +=== Report setup ===
 +[[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​editeurimpression:​start|{{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-112546.png?​nolink}}]]
 +
 +[[:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​editeurimpression:​start|See dedicated page]]
 +
 +
 +===== Batch Output =====
 +
 +The batch output mode has a separate setting from the interactive mode, but the setting fields are the same.
 +
 +
 +<WRAP round tip>
 +In atch mode, you can choose not to produce an output if there is no data.
 +
 +This feature is heavily used in the case of consistency check queries (searching for clients without a G/L key). The scheduled query runs every x minutes looking for the anomaly and for example sends a mail if the result is positive.
 +</​WRAP>​
 +
 +[[:​en:​v8_0_0:​howto:​schedule|See scheduler page]]
 +
 +{{:​en:​v8_0_0:​designer:​menus:​accueil:​nouvellerequete:​pasted:​20200722-113107.png?​nolink}}
 +
 +All output types __except grid__ are available, as well as grid or report output formats.