====== 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