Vigilens Reporting Knowledge Garden en:v8_0_0:designer:menus:accueil:nouvellerequete https://vigilens.wiki/dokuwiki/ 2026-05-26T07:23:17+0200 Vigilens Reporting Knowledge Garden https://vigilens.wiki/dokuwiki/ https://vigilens.wiki/dokuwiki/lib/exe/fetch.php?media=wiki:favicon.ico text/html 2020-07-09T14:56:40+0200 Anonymous (anonymous@undisclosed.example.com) Field Selection https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:champs&rev=1594299400&do=diff Field Selection This screen displays a list of all fields displayed, whether they come from a table, a field in a subquery, or a calculated field (operation, see OPManage). Whether it is for fields to be edited or fields for sorting, the checkbox allows you to disable a line, which can be useful when designing or debugging the query. text/html 2020-07-10T11:48:57+0200 Anonymous (anonymous@undisclosed.example.com) Table and subquery selection https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:choixtables&rev=1594374537&do=diff Table and subquery selection Choice of tables The same table can be added several times. An index (_1, _2, _3...) allows distinguishing the different occurrences. Ex: You can also customize the Table Name by using the F2 key. Selection of Queries text/html 2020-09-03T15:56:34+0200 Anonymous (anonymous@undisclosed.example.com) Creating a consistency query https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:coherence&rev=1599141394&do=diff 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 inquiry, but it is often easier to express the criteria that records must meet than those that they must not meet. text/html 2020-09-03T15:52:53+0200 Anonymous (anonymous@undisclosed.example.com) Creating an inquiry https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation&rev=1599141173&do=diff Creating an inquiry As long as you have not reached the end of all screens (the last screen being the test screen), your query will not be saved. Choice of environment In the case of JDE/World data sources, and the environment is required. Objects and data will be retrieved from this environment. text/html 2020-07-28T15:14:20+0200 Anonymous (anonymous@undisclosed.example.com) Criteria https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:criteres&rev=1595942060&do=diff Criteria In the designer, you can specify criteria on the data : * in the general case, at the query filtering level #TBC * in rarer cases, at the joints level. #TBC * In both cases, the entry and the combination are very close. Disable a Criteria Each criteria is preceded by Chaque ligne de critère est précédée d'une case à cocher. Si la case n'est pas cochée, le critère n'est pas pris en compte. text/html 2020-07-09T10:44:37+0200 Anonymous (anonymous@undisclosed.example.com) Focus and query creation https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:focus&rev=1594284277&do=diff Focus and query creation * if the focus (highlighting) is on a sub-element of the Shared Queries folder of Existing and Shared Queries panel, it is not possible to create a query, the button is grayed out. Queries __ can only be created or modified in the user directory. To make them accessible to other users, you must text/html 2020-07-28T15:13:51+0200 Anonymous (anonymous@undisclosed.example.com) Result Grid https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:grille&rev=1595942031&do=diff Result Grid The result grid is the most favored reporting output. Tools Filtering tools The following three icons allow you to apply, modify or delete filters respectively: These filters are applied at runtime and therefore after the filters at the join or text/html 2020-09-03T15:59:02+0200 Anonymous (anonymous@undisclosed.example.com) Query Group https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:groupederequetes&rev=1599141542&do=diff Query Group Usage This involves launching several queries successively, with a possible passing of parameters. Difference from inquiry Creation Screen As for a reapprochement, the choice of the data source is grayed out, as well as a checkbox for time out and automatic disconnection. text/html 2020-07-22T11:41:25+0200 Anonymous (anonymous@undisclosed.example.com) Joints https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:jointures&rev=1595410885&do=diff Joints Standard joints The tool Add Standard allows you to create automatically the links between tables: When joints have been modified or added manually, it is possible to add them to the Vigilens standard joints library: just use the button text/html 2020-07-16T11:47:17+0200 Anonymous (anonymous@undisclosed.example.com) Parameters at runtime https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:parametres&rev=1594892837&do=diff Parameters at runtime Usage Parameters are typically used by Vigilens to filter a subset of data when creating the report: for a particular company code, for a date or a date range, etc... Creation Parameters can be created in the screens that can use them, for example in conditions on joints or extractions according to criteria. text/html 2020-09-03T15:57:17+0200 Anonymous (anonymous@undisclosed.example.com) Matching https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:rapprochement&rev=1599141437&do=diff Matching Usage Matching allows you to do what inquiry does not allow: to have in the same query several data sources coming from several databases. Difference from inquiry Creation Screen When the matching type is selected, the choice of the data source is grayed out, as well as the checkbox for time out and automatic disconnection. text/html 2020-07-28T15:13:17+0200 Anonymous (anonymous@undisclosed.example.com) Linked Queries https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:requeteliee&rev=1595941997&do=diff Linked Queries Usage Linked queries, or Drill-Down, are a powerful way to improve the user experience. In a query grid, rather than constantly accumulating new columns, it is better to let the user choose to “zoom in” on a record to get more detail. The grids flow seamlessly into each other. text/html 2021-09-22T17:50:16+0200 Anonymous (anonymous@undisclosed.example.com) Output https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution&rev=1632325816&do=diff Output There are two outputs modes : * Interactive output: user actively run the query * Batch output: all queries of a directory are run These two modes are set up separately. Interactive Output Output types Result Grid Most used output text/html 2020-09-03T16:08:43+0200 Anonymous (anonymous@undisclosed.example.com) SQL Entry https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:sql&rev=1599142123&do=diff SQL Entry Usage This type of query, available only for SELECT, allows you to enter directly in SQL code the selection of data Difference from inquiry SQL Input This screen provides a text field for entering the query. You just have to make a “ text/html 2021-02-01T16:14:11+0200 Anonymous (anonymous@undisclosed.example.com) Home Menu > New Query https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:start&rev=1612192451&do=diff Home Menu > New Query Focus Depending on what is selected in the panels, the behavior of the New request button changes, see this page for more details. Name of the query The name of the query need not be unique. It just has to be unique in the directory where the query is located. This applies to the user's directory but also the shared query directory. The icon to the left of the name entry field allows you to modify the icon assigned to the query. text/html 2020-09-14T15:58:12+0200 Anonymous (anonymous@undisclosed.example.com) Pivot Table https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:tableaucroise&rev=1600091892&do=diff Pivot Table Usage Result grid is the easiest and most versatile output type, it may be interesting to present the data in a synthetic form using a pivot table or pivot chart. When you are on result grid, you can access the pivot table/chart tool using the icon in red box below. text/html 2020-09-10T16:55:28+0200 Anonymous (anonymous@undisclosed.example.com) UNION query https://vigilens.wiki/dokuwiki/doku.php?id=en:v8_0_0:designer:menus:accueil:nouvellerequete:union&rev=1599749728&do=diff UNION query Usage This type of query is similar to the SQL UNION function. These queries are used to display the rows extractedby two (or more) subqueries. Difference from query Selecting Subqueries As for the matching], at [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:choixtables|data source selection, no table can be selected, only queries.