====== Query Menu ======
{{:en:v8_0_0:designer:pasted:20200910-145814.png?nolink&}}
This menu appears only if a query is selected [[:en:v8_0_0:designer:start#panneaux|in one of the panels]].
===== Run =====
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-150533.png?nolink}}
* ''Execute'' = executes the query using the interactive restitution mode defined at the query level.
* ''Print'' = prints the summary of the query.
===== Edit =====
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-151210.png?nolink}}
Most of these buttons are not used very much, as they have intuitive shortcuts.
* ''Open'' = open in edition the selected query = double click on the query.
* ''Rename'' = single click on a query or ''F2'' on an already selected query.
* ''Delete'' = button ''Delete'' on the keyboard.
The ''History'' button details the modifications and publications of the selected query.
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-151238.png?nolink}}\\
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-151254.png?nolink}}
===== File =====
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-151328.png?nolink}}
==== Publish ====
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-151443.png?nolink}}
Once the development of a query is complete, it must be published to make it accessible to other users. A location in the shared directory is then requested, as well as a name. Overwriting a shared query is possible with a warning.
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-152314.png?nolink}}
//It is not necessary to publish subqueries, only the final execution request must be published (subqueries are automatically integrated into the main request).//
==== Inserted Files ====
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-152435.png?nolink}}
This button allows certain actions on subqueries that have been incorporated into the main query. See [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:choixtables#choix_des_requetes|Query selection]].
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-154247.png?nolink}}
* {{:v8_0_0:designer:menus:requete:pasted:20200702-112345.png?nolink}}: Displays a preview similar to the main Designer screen.
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-154359.png?nolink&300}}.
* {{:v8_0_0:designer:menus:requete:pasted:20200702-112559.png?nolink}} : allows us to directly edit the embedded query.
* {{:v8_0_0:designer:menus:requete:pasted:20200702-112650.png?nolink}} : execution of the embedded query alone.
* {{:v8_0_0:designer:menus:requete:pasted:20200702-112754.png?nolink}} : extract the embedded query.
{{:v8_0_0:designer:menus:requete:pasted:20200702-112816.png?nolink}}
==== Linked Queries ====
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-152753.png?nolink}}
The [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:requeteliee|linked queries]] are a powerful way to improve the user experience. See [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:requeteliee|dedicated page]].
==== Result file ====
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-154546.png?nolink}}
Gives access to all the results files available for this query.
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-154635.png?nolink}}
It is possible to:
* {{:v8_0_0:designer:menus:requete:pasted:20200702-114633.png?nolink}} : open the result file.
* {{:v8_0_0:designer:menus:requete:pasted:20200702-114641.png?nolink}} : save it on the disk.
* {{:v8_0_0:designer:menus:requete:pasted:20200702-114650.png?nolink}} : Delete it.
You can select several result files simultaneously to make a mass deletion.
You can't delete a query that has result files.
It is possible to prevent a user from deleting files that are not his or her own. See [[:en:v8_0_0:admintool:menus:gestion:groupe:start#autorisations|Authorizations]].
===== Clipboard =====
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-154714.png?nolink}}
Classic editing menu
===== Translation =====
{{:en:v8_0_0:designer:menus:requete:pasted:20200910-154756.png?nolink}}
When creating a query, all text fields followed by a button {{:v8_0_0:designer:menus:requete:pasted:20200814-145202.png?nolink&}} can be associated with multiple translations.
The ''Export'' and ''Import'' menus allow respectively :
* create a csv file with all the translations existing in the selected query and the framework to add more translations.
* to integrate in the query all the descriptions in a csv file