GXquery 4.0 offers a simple and powerful way for end users to create their queries with no programming involved, in an agile manner through a web console!
It is never possible to know from the start, all the data needs that end users might have for the applications they ask. So, GXquery 4.0 offers to the end users the possibility of creating freely, on their own, their queries, as well as creating comparative graphs, or even analyze all that information on Excel afterward!
Thus, GXquery 4.0 is based on the premise that the task of generating queries must be very simple and agile, both for end users and technical users, to use the information stored in their systems’ databases for decision making.
For more information about the last available Upgrade of GXquery, please refer to GXquery 4.0 Upgrade 6.
Integration with GeneXus#
To start creating queries in a dynamic way with GXquery, once installed the GXquery extension, you only need to create a GXquery metadata from the GeneXus Knowledge Base, in order to have all the information concerning the data model.
Also, the queries defined in GXquery are Query objects that can later be imported in the GeneXus KB, with the advantage of integrating the queries defined in both work environments:
- inside the GeneXus KB
- from GXquery through the web console
Designing queries with drag&drop#
The web interface makes easy to edit queries using an editor that enables the user to drag attributes to create the query and show the results in various formats, including pivot tables and charts.
For more information, read HowTo: Build a Pivot table.
GXquery application for Smart Devices#
Its key new features include a new application for iOS and Android, which will enable GXquery users to connect to their metadata. From anywhere with their mobile devices (smart phones or tablets) they will be able to run the queries created using the web interface. Also, the access levels defined will be taken into account.
For more information, read Marketplace de GeneXus.
Add-in for Microsoft Office Excel#
This Add-in allows connecting to the GXquery installation and running the queries created in the web interface inside Excel, generating Pivot tables and Excel-native charts.
For more information, read GXquery Add-in for Microsoft Office Excel.
This API enables GeneXus developers to dynamically integrate the queries created through Web GXquery and run them inside the application developed in GeneXus. Read the documentation and download an example from GXquery API.
GAM-based Security Scheme#
GXquery uses GeneXus Access Manager (GAM) to implement the management of users, roles and permissions. This version incorporates the possibility to connect to a GAM other than the one installed by GXquery and thus centralize user management for both the applications that may be using it and for GXquery itself.
Scenario: Applications for several companies (multi-tenant)#
When GXquery is installed, it is set to a basic administration mode with a single user repository that is assigned to all metadata. To enable the option to reuse the same GXquery installation for several companies, it has to be changed to the "advanced" mode that allows creating N user repositories and assigning them to different metadata.
For more information, read GXquery Advanced administration.
Sharing queries among different metadata#
To this end, the possibility to import queries has been implemented; in addition, it is complemented with the export feature. The file that results from the query export can be imported into a GeneXus KB and into GXquery itself.
For more information, read Importing Queries from GXquery.
More power to analyze data#
Automatic grouping by date#
To create a Pivot table that shows invoicing data grouped by “Year” and “Semester”, we simply have to create a query with the “Date” attribute of the invoice, open the “Grouping” property and set it to “Yes”. This enables a group of properties that will allow us to group date values by year, semester, quarter, month and day of the week.
For more information, read Grouping time values in the Query object.
From general to specific data: Drill Down#
With this feature, the user can see the data he/she is analyzing in greater detail; for example, moving from sales by country to examining the sales by city within each country.
For more information, read Drill down in GXquery.
Highlighting data through conditional formats#
This feature makes it possible to define rules to apply to data, so as to use different colors or fonts to highlight those values that meet certain conditions.
For more information, read Styles and Conditional styles.
More flexibility to create In-line formulas#
This new feature adds the possibility to define different types of calculations over the values to be queried with no need to change the data model to do so.
For more information, read Expressions in-line in GXquery.