process4.biz 7.x Documentation

features description for Process4.biz

Creating new queries

Start the Query Builder from the process4.biz menu. 
Create a new query, for which the dialog box with the properties opens first. Enter a name for this query that stores all your filter settings. 

329430

The queries are categorized using query classes. Query classes can be created in the Designer.

329305

New queries of the selected class can be created in the QueryBuilder. You can also change the classes of queries directly in the properties window.

329440

329301

In the next window, the Query Builder opens with its window views (overview of all queries, properties browser, query columns and the window for the query results). 

329307

In the properties browser, first select:

  1. Per hook in the checkbox, if you want to use administration items (e.g. user) design items (e.g. unit, class, property group, property, link type, …), or repository items (object, diagram, object link, …) or a combination of them for the report.
  2. In the folding menu underneath select, through which primary source type (object, diagram, object link, file) you want to create the report.
  3. In the tree underneath, you select then via the checkbox for filtering which desired parameters of the above selected primary query type should be considered when creating the results. 

329310

You can extend the tree for each parameter in the tree view with individual selection criteria, by clicking on the plus sign. You can also select which information, such as properties (also shape-specific properties), linked objects and/or diagrams etc., are to be displayed, but you can also restrict the query according to certain criteria such as Unit and/or class, etc.

In the example below we have selected objects for which the properties Name and Description are displayed; in addition, the class name should be displayed and the searched objects should have linked objects, whose names will also be displayed. 
The ticked fields and branches of the tree are highlighted in bold.

329293

329295

Moreover, it can be displayed on which page within a Visio diagram an object is stored (in the node UsedOnPage) or the files linked with that object can be processed (in the node LinkedFile).
*It can also be displayed on which diagram this object is being used (
UsedInDiagram) as well as any diagrams linked to this object (LinkedDiagram*).

329297

There is a possibility to place constraints not only on objects, but on object links as well. This can be done in the {Link} section. For example, to see on which diagram a link was created, simple choose {LinkOriginDiagram}:

329603

When you define a query on a diagram, you can display the name and other properties of the diagram page (DiagramPage) and display the files linked with the diagram (LinkedFile). 

329299

In order to execute a query based on the selected settings in process4.biz and to display the result, click Execute Query: 

329285

Subsequently, the Query Builder Report with all objects (or other items) are created, to which the conditions apply. Each item you have selected appears with its relevant properties as a row in the evaluation result. 
All items in the query results list can be edited and deleted here directly, but this has the same consequences on the listed items, as if you were editing or deleting them in the repository or designer! The hyperlink values can be opened directly from this window using the mouse. Even diagrams can be opened directly from here. 

329287

If you select the source type diagram, it is possible to select the properties of the diagram classes and restrict the list of the diagrams to the selected classes.

329289

You can copy, cut and paste the queries using the right mouse button, as for all other entries in the database.

329291