process4.biz 7.x Documentation

features description for Process4.biz

Query columns and filter settings

In addition to the items selected on the left in the properties window, the primary query types, and the parameters, you can define additional filter settings on the top right of the window query columns for selected objects.

Path: The first column shows all properties and other items selected by you. If you double-click with on a row, the tree in the Property Browser is extended and you can select the corresponding entry. If a property, which appears in the Path column, was deleted in the designer, it is marked with a Symbol 328495

329341

Visible: You can make each property visible or invisible in the second column by enabling / disabling the hook.

Sort: You can define in the third column, “Sort”, whether the evaluation results should be sorted by the values of the selected criterium in alphabetical order, either in ascending or in descending order.

Order: After having selected in the 3rd column the type of alphabetical sorting, you can specify in this column the order in which the individual criteria should be used for sorting. Assume that you have defined for the properties Name and (Class) Name that you want them sort in ascending alphabetical order. If you now specify as sort order in the next column for the Name “2” and for the (Class) Name “1”, the objects of the query are sorted alphabetically in ascending order first by class name and then by name in the query result (report).

As a result, you can determine in the column “Condition” further filter conditions for the query. Click twice in this column on the line for which you want to define the filter in more detail. A window opens where you define one (or more) conditions for the item of this column: 

  • *is any value: *Objects with any values are listed (corresponds to the default setting - no limitation). 
  • is empty / is not empty: Only objects with empty or not empty value entry are listed in this property / item. 
  • is equal to / is not equal: By selecting this filter condition, you can specify a value, to which the items of the query either correspond or not. 
  • is / is not like: Here you can choose between asterisks (* *), which serve as placeholders, which symbols should or should not contain the value. For example, *sa* gives the result of all values, which contain “sa” in the description, sa*: all values beginning with “sa” and *sa: all values ending with “sa”. 
  • is one/ is not one: with this condition objects are listed that belong to one of the selected values or that cannot be assigned to them.

The condition is activated automatically when you select specific classes or units in the object tree using “(confined to)“. This restriction can be changed later, by selecting a different value. 

329343

You can also define simultaneously several conditions. 

In the dialogue box conditions for the columns value (which can be opened by double-clicking in the table cell of the query column “Condition”) open the small drop-down menu under “More …” and select the combination of several conditions with either AND or OR. You can delete an additionally entered condition by clicking on ”<delete last>“.

329329

In the column Identifier, you can assign a self-defined name to the associated column in the query results. By default, the value is taken from the column “path”. With this field you can replace the often long and incomprehensible path names with short names.
For example: Instead of {Link}.{LinkedObject}.{Link}.{LinkedObject}.Name you name the column “Rolle”. This name is then used in the column description in Excel, as the figure below shows. The name in the column **identifier **can also be translated to other languages.

329331

In MS Excel, the report looks like this:

329333

The advantage of using the column identifier is that their values can be translated into other languages. The small icon  329323 opens the window in which translations for all languages currently available in the database can be added. Therefore, an “international” query can be produced.

329335

Each path has also its unique Db name, which cannot be translated. The DBNames in the database are used for example in properties or classes, in order for the process4.biz to recognize the path. 
By right-clicking on the row “Query columns”, on the top right** **in the QueryBuilder, which includes the filter settings, you can remove rows or move them up or down. Moving rows is also possible via these arrows  329321 and influences the order in which the columns are then listed with the evaluated properties in the window below.