TECHNICAL Sign up Sign in EN
Universal directory

Universal Reference

The system of universal reference books is designed for convenience and automation of use.
Instead of creating a table for simple things, you can use universal reference books.
Their device is as follows:
  1. post ID
  2. Title
  3. Numeric field
  4. Text field
For example, there is no need to create a separate table with statuses for the Status of the application.
In the status there is: Name, Serial number, Information about the color. For this, this guide is sufficient.

Also, the reference book contains language information. If you click in the status on Editing (Ed.), Then you can fail in it and make a translation of the status into any language.

Any user can create directories and enter statuses. But there are statuses highlighted in green. These statuses are systemic, they cannot be deleted, but they can be edited. You can add any statuses to them, you can edit and delete them.

Using in the configurator

Universal references are built into the configuration system.


If a field in the database is associated with a universal reference (this is specified in the table configuration), then you can specify what to display in reports for this field.
  • Empty - the original field will be displayed (as a rule, it is just an identifier)
  • N - the Title will be displayed (i.e. what is entered in the Reference field in the Title field)
  • 1 - information from a numeric field will be displayed
  • 2 - information from the tectos field will be displayed
Procedures and SQL Queries

References can also be used flexibly in procedures and SQL queries. Access in SQL to universal references is carried out through the table [DIRECTORY_Universal] . It can be joined without any problems through left join in any SQL queries and get information on the required fields.

You can also use all the power of PL-SQL here, i.e. perform any processing of this information, for example, build a case, use any text or numeric processing functions. Use in different SQL queries and organize the transfer of information between them.
Use in interface elements

Universal directories can also be used to display information in interface elements. For example, for fixed elements when creating something. Or in the editing interface in relation to the current value.

In the example shown in the picture, information from directories is displayed in the opening lists:
  1. # 23 Task type
  2. # 25 Evaluation of labor costs
  3. # 22 Task status
For example, in the interface editor, the "Task view" field looks like in the picture.

This field is a list, and the information in it is taken from the source "U_Task_view" - this source is the standard procedure for obtaining information from the universal directory with the parameter - directory number. Those. when loading the page when displaying this field, the system will turn through this procedure to the reference book # 23 and receive from it a list of information to be displayed with the ID and Name of the field.

Automation was also introduced in the form of US and U buttons and a numeric field. In this case, it is not necessary to specially create a standard procedure, but it is enough to indicate the reference book number and click on the button. The system will automatically create a source from the standard procedure, adding the reference number to it, and also link this procedure to the current output element.
Y is standard output. US - output sorted by name.
The system of Universal References and their automation greatly simplifies and accelerates configuration programming in general. A very convenient mechanism for both the configuration programmer and ordinary users.

This gives ordinary users a lot of flexibility in editing and adding new parameters.

This gives configuration programmers ease of creation and integration of list parameters, and flexibility in the use of information.