Manageable query wizard and object model of query scheme

We have modified the query wizard so that it can operate in the manageable mode in thin client, thick client and web-client. Previously, the query wizard was not available in the mode of manageable application.
Publications: Manageable query wizard and object model of query scheme

Most of the actions in the manageable mode are performed like in the «old» wizard. But there are a number of modifications. For example:

  • on some tabs we have changed the way to edit expressions (conditions, summary fields, expressions for summary fields);
  • query which destroys the temporary table is edited now in separated tab;
  • to change the current query and operator, we use drop-down lists in the bottom part of the form, instead of switching the tabs as before.

However, the biggest changes have been made with the tab Joins. Now the generation of joins is performed by dragging the one table on another.
Publications: Manageable query wizard and object model of query scheme

The work of query builder we have implemented in non-modal mode. To do this, we have added to it a new method Show() which opens a non-modal blocking window. A result of «building» (query text) is passed by the platform to the procedure that is called after the close of builder.
Publications: Manageable query builder and object model of query schemeObject model of query scheme
Periodically it is necessary in the script to change the query text depending on different algorithmic conditions. Previously, a similar problem was solved by direct generation of required text as a string. And it is not always convenient and often very tedious.
Now we have implemented in the script an object model of query scheme. You can create an empty query scheme by the builder and load some existing query text. Thereafter, the individual elements of query text are available for you as the properties of object model.
Arrows in the figure below show in which script objects the certain elements of simple query loaded in the scheme will be available:
Publications: Manageable query builder and object model of query scheme

Editing query text using object model allows you to simpler and easier modify the existing queries. Or even create them in the script «from scratch». And then just get the finished query text from the scheme using the method GetQueryText().

Manageable query wizard and object model of query scheme available since version 8.3.5 1C:Enterprise platform.

[Total: 0    Average: 0/5]

Leave a Reply

Your email address will not be published. Required fields are marked *