The 1C data separation mechanism. Using the data separation mechanism instead of RLS. Example of using a total details
In the 1C system: the company exists the possibility of maintaining in one information database for several enterprises. This uses the accounting separator.
Using the accounting separator is set in the configuration. If the configuration defines the use of the accounting separator, then in the scoreboard scoreboard, there is the possibility of selecting the specific value of the accounting separator, according to which accounting results will be issued.
To set the value of the accounting separator, use item "Accounting separator" menu "Actions" or corresponding to the toolbar button. At the same time, a dialog is displayed on the screen to set the value of the accounting separator.
In field "The value of the accounting divider" You can specify the specific value of the accounting separator. The input method depends on the type of accounting separator defined in the configuration. As a rule, this is a reference book. In this case, to select the value, use the selection button and select the desired value from the list of reference values.
Button "Empty meaning" Allows you to erase the entered value of the accounting separator, that is, set an empty value. It makes sense if, along with the specific values \u200b\u200bof the accounting separator, an empty value was used in the wiring.
Flag "ON ALL" Allows you to set the output mode over all values \u200b\u200bof the accounting separator.
To install the selected values, click the button. "OK". To refuse to set values \u200b\u200b- button "Cancel".
After installing the selected values \u200b\u200bof the accounts, the accounts will display the results on the specific value of the accounting separator or on an empty value or in all values \u200b\u200bin the amount, depending on the option chosen in the dialog.
Once we discussed mechanisms for limiting the access of users in 1C and in particular.
It allows you to allow the user to work not with all documents, but only with those that specify a certain organization or warehouse. Selects are produced dynamically, so impose a certain load on the database operation.
Property of the General Divider Requisite - Separation of 1C users - allows you to set the availability of a list of users depending on the use of delimiters.
If the separator is enabled for the user, it will be visible in the list of users in the 1C enterprise mode - otherwise it is not visible.
Thus, you can organize various user lists for different parts of the database.
Property of the General Divider Requisite - 1c authentication separation - allows you to start users with the same user names for different parts of the base.
Conditional separation 1C.
The conditional separation of 1C allows you to enable and disable the separator based on the database data. Thus, you can create chains of additives dependent on each other dynamically operating in one way or another.
To enable 1C conditional separation - you need to specify in the property of the total separator property - the conditional separation of 1c - which will be responsible for determining the fact of inclusion of separation 1c.
It is possible to use a constant with the type of boolean or the requisite of the directory with the type of Boolean.
Important - this constant / this reference book needs to disable the use (select not to use) in the separators, only then it can be selected.
Data separation mechanism Allows you to store data from several independent organizations in one information base.
This becomes possible due to the fact that the general details of the configuration objects can be used not only as "the same props that all objects have", but also as an identifier that the data refers to some of several independent areas. This can be explained in the following example.
Suppose in the configuration there is a general proper "Organization". This means (simplified) that each reference book, a document or other configuration object will also exist the "Organization" props.
At the same time, any of the users of the information base has access to all data that is stored in this database, regardless of which organization is specified, for example, in a particular document.
Now we indicate that the general props "organization" will be a separator.
Then (simplified) in the information base will create several independent data areas, in each of which data will be stored only for one particular organization:
Now, entering the program, the user will access the non-all information that is in the information base, but only to the "its" field data, in this case, to documents, reference books, etc. of their organization.
Another use of this mechanism is also possible when there are several independent data areas in the information database and along with this there are data that is available to all users of the program. For example, they contain a directory of banks that are the same for all organizations.
In this case, the user has access to "its" data area and to the field of unrelated data, which is common to all users.
The data separation mechanism is quite flexible and universal:
- it allows you to use not one, but several dividers;
- there are different modes of using shared data; they differ in how the situation is processed when the value of the separator is not specified;
- using a general details as a separator can be controlled during the operation of the program from the embedded language without changing the configuration; This is called conditional division.
General props in 1C 8.3 is a platform metadata object that allows you to use one props for many configuration objects (directories, documents, account plans, etc.). The object is created mainly to facilitate the labor of the developer and separating data.
The common details were originally implemented in version 1C 7.7, but immediately in the platform 8 versions did not turn it on. The mechanism of common details was introduced by 1C developers only in release 8.2.14.
Common details are very convenient to add not to change the standard objects in the configuration, I often use them along with.
After adding a total details, it can be used in queries and output objects - Externally, it does not differ from the usual props.
The only limitation of common details is the impossibility of using them in.
Consider the basic settings and properties of common details other than other configuration objects:
Structure - The list of objects to which the general props will be used, the setting reminds the setting of the exchange plan.
Get 267 video tutorials for 1C for free:
Auto use - The setting determines whether the general props will be used for those objects in which the "automatic" mode is specified.
Data separation - Consider this setting separately.
Data separation in 1C using a total details
Data separation - mechanism similar to the mechanism. However, the performance of this mechanism is more efficient, and it is configured easier.
The mechanism allows you to configure the display of only items that the user can see. For example, you can distinguish all objects (documents, reference books, etc.), where a certain organization is installed.
Setting the separation of data using general details 1C
To configure, in general details, you must specify the data separation - Divide. Immediately after clicking, the system will propose to create default accounting parameters:
It will be necessary at the start of the system to specify the session parameters how to do it, with an example was described in the article.
On this setting is over - the user will only be available to the information specified in the selected session parameters.
Example of using a total details
We will analyze the setting of the total props in 1C 8.3 on the example of a frame configuration and props Organization:
The system has 3 documents where the instructions of the requisite is needed. Organization: This is a parish invoice, consumables, salary accrual.
Setting is simple:
- Create a new common details, specify the type - Directory. Organization.
- As part of the part of our documents - Use.
All, the setting is over!
We look the result:
The system displays the overall props "as its": both in queries, and in form details, and in other places. Here is such a magic! 🙂
Not added total props 1C 8.3
The element of the 1C separator is needed in order to redistribute the form area since it is convenient to the user at the moment. The skill use of separators is available almost every Windows user. Suppose you created a simple shape of two controls.
Traditionally, the items of any list can be located on the left side. In the right part, respectively, there is a detailed detail of these very points. If the left list consists of short names, it logically reduce this column to a minimum. Accordingly, in this case, the readability of the right-hand side will increase. Conversely, if there are long names in the left side, the column should be expanded. Separators provide the user to customize the form arbitrarily, simply dragging the border with the mouse.
This method of control is used when editing tables in Word and Excel. When creating a form, you can create both the vertical and horizontal element of the divider form. In general, it is most preferable to create forms that are visually within the screen.
Separator 8.2, 8.3 (managed forms)
Divider in a managed form 1C Add can not be added, it is added by the program automatically before / after the table field
