1C Selection Form of the list. Useful features of the selection mechanism

And here the chef says - and what profit is in our northwestern division?

You immediately formed the report. Per year. For all divisions of the transnational company producing thousands of goods. The report will turn out long (if not to say steeper). So it will be difficult to find the desired figure.

In order to see only those numbers that are needed in any 1C report to 1C. So in 1c called a universal filter, which selects the data you need under the conditions that you install.

1C selection is available not only in reports, but also in reference books, in documents - in any lists.

Other information with the mounted selection 1c does not disappear - it is simply not shown now to establish focus on the required information.

We will look now how to use selected in 1C.

What is 1C selection

Data in the report and lists are presented as a table. Any table has columns. In each row of the table, some value is displayed in each column.

Suppose we have the code and name columns in our table. We can set one condition:
Code \u003d "2209"

In this case, only those lines in which the value in the code column is as we indicated will be displayed.

We can also set several conditions:
Code \u003d "2209" and name \u003d "Chicken"

In this case, only those lines in which the value in both columns will be displayed.

Setting such conditions and is called - set the selection 1C.

Selection 1C in a thick client:

The screenshot shows a reference book. Press the button in the Selection panel. A window opens with 1C selection options in columns. Install the filters we need, click OK. Only those lines that satisfy the conditions will be shown.

Subtle client:

1c selection can be set using the All Actions / Configure List, 1C Selection tab. Bookmark action is similar.

What is the selection condition 1c

Each 1C selection condition is made to a value in one column. Accordingly, the second is on another column, etc. The valid (included) conditions have a check mark in front of the name.

This screenshot shows an example of setting one condition: "If the value in the column is equal to this."

The word "equal" is specifically allocated. There are other options. If you think about how at least the head comes that if you can select the lines where the value is "equal to something", then it may be necessary to look at and where "not equal."

Different installation options for conditions depend on the types of values \u200b\u200bin this column.

For the number we can compare more and less.

If the values \u200b\u200bin the column are a directory or document, you can specify "in the list" - this means you can list several options for values.

Some reference books have groups. For example, the Handbook "Nomenclature" and "Counterparties". To select 1C in the speakers in which the values \u200b\u200bof such reference books are indicated, you can specify "in the group".

This means - check - the value that is specified in this row is inside the group or not? The groups invested in each other are also taken into account.

If we want to specify several groups at once and check whether the item is entered into one of them - then you need to choose "in the group from the list."

If the type is a string, then you can search not for its full value, but only by part. To do this, select the option "Contains".

Basic selection of 1C documents and reports

As we have already discussed earlier. Therefore, the basic selection of 1C in any list of documents is the period.

To set the desired period, press the corresponding button in the panel. Period can be installed arbitrary dates or as one of the pre-trial - month, quarter, year.

IN thin client 1C. appearance Forms to set up the period has changed a bit, but the point remains the same.

Selection 1C in any list

These rules are valid for any table in 1C, wherever it is located.

Usually above the table is the panel on which there is a selection button 1C, the same as on the above pictures.

If so is not - right-click in any place table. Select the menu item "Set 1C selection and a list sorting".

When working in a thin client 1c, there is no such menu item. Similar actions can be performed only if this list The "All Actions" menu is displayed. Then in it you can choose the "Configure List" command.

Selection 1C in the report (for reports is not CCD)

1c selected in reports different versions Configurations look different and are in different places. This is due to the fact that the reporting system in 1C is very violently developing and the standards change from the editors to the configuration editor (.,.).

Usually 1c selections are available when you press the Settings button in the report.

In the Accounting and Salary Configuration Reports in the Tolstaya Client (and in these configurations, the reports are made without, 1c selections are open on the Settings button. They are located in the pop-up panel, most often at the bottom.

In the configuration reports "Trade Management", "UPP" in the Tolstaya Client (also not CCD), on the "Setup" button opens the settings window, at the bottom of which 1C selection is located.

Selection 1C in SCD

In the configurations of new versions - on the fine client 1C - all reports are made in the SCD system. 1c selected in them are standardized.

Fast 1C selection are removed directly to the report panel.

More detailed selection 1s can be seen by clicking the Settings button.

You can fully manage the entire report, including 1C selection by selecting All Actions / Change option. On the selection tab it is possible to control 1C selection.

In order to open the selection form with selection in 1C 8.2 (Ordinary forms), we need to perform some actions. First we get it. After that, put the selection and programmatically open, here is an example code:

Selection on form in the input field 1C 8.2 with several values

In the example above, we considered how to install selection on the form of choice Specific value. Now let's consider the situation when you need to substitute several values, it can be for example a array and unloading from the query result. This selection in the input field 1c with several values.

To begin with, we obtain the selection form, send the "Element" settings, set the selection mode flag. Then create a list of values \u200b\u200band an array, note that as a selection when the type of comparison is set in the list, the object can be present only with the type. Slip list. Add items to an array, then this array is loaded into the list of recognition that, as a result, we set in the selection. We also do not forget to enable the use flag of this selection, and install the vocabulary.

Setting the selection in the input field in 1C 8.3, start-up event

Now consider selection in the input field on a controlled form in 1C 8.3. Find on the form of an element of interest to us in which we will set the selection, in our case this field "Organization". We find the starting event, click on the magnifier and turn out to be in the procedure. We see the data parameter, this parameter has a type of list. In order to limit the choice of the necessary elements, we need to fill the list of accommodation. We can only select items on the server, so we create a procedure with a compilation directive & nasserver. In this procedure, fill in this data.

The list is an integral attribute of information displaying in any configuration created on the 1C: Enterprise 8.1 platform. For efficient work With lists containing a variety of data in the program on the platform "1C: Enterprise 8.1" are implemented comfortable and powerful selection and sorting mechanisms. On the peculiarities of their use tells V.V. Fishing, firm "1C".

Fig. one

Lists

What lists are users faced? These may be lists of documents in the respective magazines. Almost any directory filled with data is presented in the form of a list in which, as a rule, there is hierarchy (group-folder groups or subordinate elements). Often to select any item, the program generates lists automatically or submitted by the logic laid by the developers.

In almost all lists, you can use the selection mechanisms (if it is clearly not prohibited by the developer) and a variety of sorting (Fig. 1). In the program, these mechanisms are inextricably linked with each other. Consider how to use them correctly and efficiently.

Fig. one

Sort mechanism

Why do you need a sorting mechanism? First, he, as follows from the name, allows you to sort the list according to the desired criterion.

Secondly, in the "1C: Enterprise 8.1" platform, a quick search mechanism is actively used. This mechanism allows you to quickly find the desired element in any list by typing the first characters (Fig. 2). But in dynamic lists (for example, a list of directory elements or document list) Quick search works only on details for which sorting is available.

Fig. 2.

You can view all the details available for sorting the list by opening the "Selection and Sorting" window. This window is usually available on the panel of action (Fig. 3) or in context menu The list that opens the right mouse button (Fig. 4). In the Selection and Sorting window, you need to go to the Sort tab, where all available details are shown for which sorting is possible.

Fig. 3.

Fig. four

Figure 3 shows that for the list of documents "implementation of goods and services", sorting is available for two details: "Date" and "number". However, the information content of the sorting window is not limited. Here you can see what kind of sorting is currently included (the left side of the window) and the list of all available for sorting the details (right side). Immediately you can adjust the desired sorting and its order. Please note: the current props of sorting will be marked in the list special symbol - Arrogance denoting the direction of sorting. Three examples of various sorting (including combined) and the methods of its display in the list are shown in Figure 5.

Fig. five

Note that the lower example illustrates the possibility of using a combined sorting (simultaneously in several details). In our case, this is a sort by date descending (the oldest dates below) and by numbers ascending (the largest numbers below).

In each list, you can individually save the desired sorting. It is enough to turn on the tick "Use this sorting setting when opening" and click "OK". The system will remember the setting and the next time you open this list will install the saved sorting.

You can quickly sort the list by the desired details by clicking the header with the title of this props.

For example, in our case, you can click on the details of the "Date" (the dates are turned on ascending on, and you can use a quick search by date) or by the details of the "number" (sorting by numbers will be switched by increasing, after which you can quickly search by number). Invert the sorting is also simple - sufficiently click on the same props in the list header.

Selection mechanism

Selection is a powerful platform mechanism "1C: Enterprise 8.1", which allows you to work effectively with lists, even if they contain no one dozen or hundred thousand items. To begin with, consider the work of the selection mechanism in the general case.

Almost everywhere, where there is a list (as a rule, in the form of a table), you can use the selection mechanism that is activated by either the corresponding button on the action panel, or in the context-dependent list menu (Fig. 3 and 4). If the selection from the desired list is possible, the Selection and Sorting window opens. It will displays all possible species available for selection of details. The list of available selection elements depends on where this selection will be used. In general, you need to find one or more selection items, specify the values \u200b\u200band activate the configured combination of criteria.

The list of possible conditions for one or another selection type depends on the type of items used in it. For example, for numbers and dates will be available indication of the ranges, for strings - search for substring (the conditions "contains" / "does not contain"), and for the elements of reference books - filling lists and analysis of the hierarchy.

If you simultaneously specify several selection criteria, only such elements that satisfy all these criteria will be displayed in the list.

Selection and sorting mechanisms on examples

Let's try to solve several tasks in the demonstration base ("Accounting Company", editors 1.6). For example, you will see the documents formed for the Counterparty "Simon and Schuster LLC" in the journal "Customer Documents". Immediately alleged that we will describe the standard for the "1C: Enterprise 8.1" platform, the rules and logic of selection logic, without binding to any particular configuration and additional service capabilities, in it implemented.

So, open the log of documents "Customer Documents". In a standard state, all the documents of all buyers are displayed without the selection on the screen (even in the demo-based database it takes not one page).

We need to quickly see all documents of the counterparty "Simon and Schuster Ltd.". The task is implemented as follows - the selection window opens, the "Counterparty" element is selected by the "Simon and Schuster Ltd." from the reference book (Fig. 6) and "OK" is pressed. The task is solved (Fig. 7).

Fig. 6.

Fig. 7.

To quickly use the desired selection, it is enough to immediately proceed to the choice of the desired criterion. You do not need to put a tick in front of the selection used. The program will make it itself after the required criterion is specified. Quickly apply configured selection criteria, by pressing the Ctrl + Enter key combination.

Please note that when specifying the values \u200b\u200bin the selection elements (in our example, Simon and Schuster LLC), in most cases a quick selection mechanism will work, widespread in the platform "1C: Enterprise 8.1". In our example, it was enough to dial the first symbols of the counterparty name or its code directly in the selection value field, press ENTER or TAB and the system would automatically "guessed" the element of the directory.

Keep in mind - the quick selection significantly speeds up the choice of values \u200b\u200bknown to you. Use it where possible.

Now display the list of nomenclature, in the names of which contains the word "kettle". To do this, open the Handbook "Nomenclature", call the selection window, in the "Name" element, select the comparison condition "contains" and specify the required word (Fig. 8).

Fig. eight

The view of the comparison "contains" is not accidentally selected. It is he who allows you to find the right word (or part of it) anywhere in the name of the nomenclature. If you leave the form of comparison "equal", only such elements of the nomenclature will be displayed in the list, which is called exactly how the request is written. And there are no such in our demobaz (that is, no element would not be displayed).

Since the nomenclature in our demobaz has a "full name" props, it is present in the list of available selections with a separate position. But at the same time, only "contains" / "does not contain" as the comparison conditions is available. The reason is that the props "Complete name" in our demobaz - a line of unlimited length.

If you look no name, but on the full name, the tick of using the selection is better to remove it. Otherwise, the selection will be used both by name, and in full name, which can not always be necessary (Fig. 9).

Fig. nine

For convenience of working with the elements of the reference book, when using the selections, it is better to turn off the display of the hierarchy (Fig. 10).

Fig. 10

As a third task, I will look in the journal of documents "Documents of buyers" only documents "Implementation of goods and services". The solution to this task will demonstrate the feature of one of the types of selection, available only in document logs.

Open the "Documents of Buyers" and specify in the selection element "Type of document" Document "Implementation of goods and services". The program itself provides the ability to select a certain type of document from those included in this magazine. There is a personal button on the action panel (Fig. 11).

Fig. eleven

Similar to the selection by type of documents, the platform will automatically offer the selection element "Subordination", if the relationship between documents is configured in the configuration.

Let's try to view in the journal "Documents of buyers" only documents "invoice" for counterparties located in the Buyers group of the directory. This task is similar to the first one with the only difference that we do not specify a specific counterparty, but by analyzing the invoice of the whole group of counterparties that are in the "Buyers" group.

The task has several ways to implement. Consider the most efficient. Open the "Customer Documents" log, indicate in the selection element "Type of document" Document "Account Issued". After that, in the element of the selection "Counterparty" indicate the type of comparison "in the group". We choose the type of "counterparties" and open the form of the choice of counterparties. In it, choose the group "Buyers" (Fig. 12).

Fig. 12

This type of comparison implies that the condition will satisfy all the elements of the reference book that are in the specified group. Moreover, even if there are subgroups within the specified group, all the elements embedded there will also satisfy such a criterion.

And now complicate the task: I will look at the "Customer Customer" documents "Documents" only documents "invoice", but at the same time you need to view documents for buyers, and for suppliers. We solve it similarly to the previous one, with the exception of one imposed selection criterion.

The human language task is formulated as follows: "Display all the necessary documents on all counterparties in groups of reference books Buyers, suppliers, providers for implementation". It is implemented simply - in the selection condition, the "counterpart" is chosen "in the group from the list" (Fig. 13). After that, the mechanism of filling the list in which you can add the required groups (or items) of the reference book can be added. And the list can be filled manually. By analogy with the solution of the previous task, find the desired group and select it, repeating it for each new list item. However, it is more expedient to use the convenient selection mechanism that is automatically implemented by the program. With the help of the selection, much easier and fill in the list of the necessary components. After the list is filled, press "OK" and activate the configured selection criteria. The task is solved.

Fig. 13

The difference between the selection conditions "in the group from the list" from the condition "in the list" is that in the first case, the condition will be executed for all elements of the reference book, which is either explicitly listed on the list or are within the list of groups. The second case simply indicates the program to be checked with a list when selected. That is, if you specify a group there, the group itself (as an independent element of the reference book) will fall into the selection, and the elements that are included in it, the selection criterion will not be satisfied. It was possible to solve the task and "in the forehead" - to choose the "list" condition and using the selection to add all the items contained in the necessary groups.

The selection conditions "not in the list" and "not in the group from the list" allow you to specify the desired data sets that should not be selected. That is, it would be possible to solve the task and from the reverse - to specify "not in the group from the list" and add all the directory groups there, except for the three necessary (Buyers, suppliers, suppliers to implement).

And finally, you will see in the document "Implementation of goods and services" with the TDN00002 number in tabular part only the nomenclature containing the word "stynol" in the names. This task will allow you to see the universality of the selection mechanism itself, as well as how diverse it can be used. The task is based on real situations, when, for example, in a tabular part of the invoice of several hundred (or even thousands of thousands) rows and it is necessary to quickly analyze its composition. Our demobaz has a document "Implementation of goods and services" with the TDN00002 number, which has several lines in the table part. Despite the fact that in the document use buttons is not observed, the selection call is accessible through the context menu (right mouse button).

Next we impose the selection criteria in the section of the nomenclature. There is also another question - how to select "Stinol" if the conditions for choosing the nomenclature are quite limited (available "equal", "not equal", "in the list" and "not in the list"). It is possible to solve the problem under such conditions. Select the condition "in the list", open a familiar window to fill the list, use the selection of the nomenclature (Fig. 14, 1). The list of nomenclature may be a large number of Elements, so we will not look for your eyes the necessary positions. We use the selection in the list of the nomenclature, specifying the selection condition "contains" for the name of the nomenclature (Fig. 14, 2).

Fig. fourteen

After that, it remains only to add selected positions to the selection list for the document and apply the selection criteria.

Useful features of the selection mechanism

Consider a few more points related to one way or another with the selections in the system "1C: Enterprise 8.1".

In the lists of configuration objects, which uses a binding to dates (for example, documents lists), and in document logs, you can use a quick selection by the dates range. To do this, it is enough to press the corresponding button "Setting the period" on the action pane (or select in the context menu) (Fig. 15). In this way, you can individually adjust the display criteria for the dates in each list.

Fig. fifteen

You can quickly select the selection in the current list of the list by clicking on the "Selection value in the current column" button (Fig. 16). When you click on this button, select the current value in the column. This feature only works for those columns by the details of which you can install selections. If the list is already using any selection, the new will be attached to it. Moreover, the button becomes active for this column. You can cancel such a selection similarly - "Out" the button in the appropriate column.

Fig. sixteen

Another useful property The mechanism of selections is the maintenance of the history of the selections (Fig. 17). The program remembers which selections were installed, so you can quickly return to any of them by simply by selecting it from the drop-down list. By the way, in the "Selection and Sort" window, pay attention to the "Selection" button (Fig. 6). By clicking on this button, you will be taken to the interface in which you can save and restore the settings of the selections so that in the consequence it is possible to return to them (Fig. 18).

Fig. 17.

Fig. eighteen

And the last function is the cancellation of all selections (Fig. 19). By pressing the "Disable Selection" button, all selections set in the list are disconnected. A similar action can be achieved by opening the "Selection and Sort" window and removing the tick opposite all active elements.

Fig. nineteen

The program also has the ability to quickly search by document number on documents or logs. This feature is called by the "Search by" button (Fig. 20) and allows you to find necessary document, Flexible configuring the search parameters. Found documents on the specified criteria are displayed at the bottom of the window of this service, and you can go to the desired document.

This code allows you to open a list of documents with the set selection, you can also open a list of reference items with the desired selection.

Code 1C V 8.2 UP Form \u003d open form ("Document. Source. Form. Formscribe"); // Open form
Folder \u003d Form. Learn. Title.Elements. Addly (type ("elementotorbone-block")); // add selection
Decabloser. Width \u003d Victims CommunicationCompon. // How to compare
Selection holder. Using \u003d truth; // Install the tank using the Poland) ("Nomenclature")
Selector. Alexification \u003d New Poland-shaped ("counterpart"); // According to which details we will make selection
Selection holder. The definition \u003d object. Kontragent; // and the selection value

In order to open the list form with a predetermined selection Use the following ways:

First method It is that when opening a form, you can set the form parameter, and open the list form with this parameter.

The selection parameter is a structure. The names of the elements correspond to the names of the fields for which the selection is made, and the values \u200b\u200bcontain the selection values. This is the parameter extension of the managed form of the dynamic list. That is, it exists in forms, the main details of which is the props of the type of dynamic list, for example, the forms of the list and forms of choice.

For example, the following example opens a list of parish invoicing with the selection by the field number equal to 333.

Code 1C V 8.2 UP Viotab \u003d New Structure ("Number", "333");
Parameters Customer \u003d New Structure ("Selection", LaborBaby);
Open form ("document. GrittyNaster. Formatic", parameters!

Second way

You can open the list form without parameters:

Code 1C V 8.2 UP Opener ("Document. Greater-Knowledge. Formatic");

And then, in the event handler, the list of the list of arrival overheads will serve the server, which creates a selection in a dynamic list, which is the main details of the form:

Code 1C V 8.2 UP & Nasserver
Preservation procedure (failure, standardworking)
Elementotor \u003d list. Options. Elements. Addly (type ("elementotorbone-block"));
Elementatub. Lowerness \u003d new half-blooded ("number");
Elementatub. Vidolation \u003d vocational assemblyCompon.
Elementatub. Using \u003d truth;
Elementator.Rezhymographed \u003d modular procedures. ElementNewsCompon.
Elementatub. Actuation \u003d "000000001";
Extrudresses

Benefits this method The fact that the selection should be specified not only as in the first case, and more, less, etc.

But this method has a very significant disadvantage: with this selection the form will always be opened. From where it would be called. Therefore, this form should not be prescribed the main one. And if nevertheless it is the main one, before installing the selection, it is necessary to provide some kind of analysis of where this form opens. For example, analyzing form parameters.

Third way

Finally, the selection condition can be placed in an arbitrary request, selecting data for a dynamic list.

For example, we need to open a list of parish invoices, in which a nomenclature has been present in the list of nomenclature.

To do this, in the form of a list of the nomenclature, we will create a command and the corresponding coming overhead button.

The execution handler of this command is filled as follows:

Code 1C V 8.2 UP & Clause
Property Procedure (Team)
Parameters Captivity \u003d New Structure ("FilterPotor", Elements. Site. Candles);
Open form ("document. GrittyNaster. Formatic", parameters!
Extrudresses

In this handler, we open the list of the list of arrival invoices, passing a link to the current item in the list of the nomenclature in the form.

Then create the form of the list of documents. Parcels and create a form parameter to the filterpoter, which we will use to open a form with the desired selection.

Now open the properties of the Property Properties of the Properties list. Set the flag of the arbitrariness and in the row setting the list click open.

In the Request field, you enter the following query text:

Code 1C V 8.2 UE Select
Document factory. Maker,
Document Company. Data.
OF
Document. Greater coordinate as Document Company
WHERE
Document factory. Tasters. Tier \u003d & Product

In the query, we use the item parameter to which will be transmitted to the link to current line In the list of the nomenclature contained in the parameter form of the list of receipt overhead filterpotor.

To do this, in the Event Handler, the driver forms will write the code to set the query parameter value. Goods:

Code 1C V 8.2 UP & Clause
Operating procedure (refusal)
List. Parameters. Installingparameter ("Product", Parameters. Filterpotor);
Extrudresses

Here is the list. Parameters are a list of dynamic list request options for props list. The value of the product is set to equal value of the form parameter to the filterpoter.

As a result, by pressing the button, the receipt overheads in the form of the list of the nomenclature, we will receive a list of only those parcels in which the nomenclature has been present currently in the list of nomenclature.

Selection on managed forms in 1C 8.3

The article will consider the options for installing the selection in managed forms 1C 8.3. The selection for the dynamic list can be set statically or dynamically in the user interface or configurator. All selection options we will consider below.

• Setting the selection in the configurator

Setting the selection in user mode

The dynamic list in contrast to the table or tree of values \u200b\u200bis a more appropriate solution for implementing forms of containing any lists, because dynamic list Provides the most wide range of tools for working with selection, grouping fields, sorting. This selection You can set when working in a user mode or configurator, the principle of the same.

To set the selection in the enterprise mode, you must call the "Configure List" command.

Window opens.

The "Selection tab" contains a list of fields that are in the current list. Select the list fields for which we will filter. You can do this double click or using Drag and Drop.

We specify the type of comparison and value, click "complete editing", the selection is set.

When installing the selection in the enterprise mode on the list form, the fields of so-called fast selections are automatically created.

In order for the 1C platform automatically created the rapid selection fields, when developing a form in the configurator, you must specify a group of custom settings.

This selection will be saved only for current userthat allows you to flexibly produce customized dynamic list settings. However, if the task is to make a fixed selection for a specific list for all users of the system, we can solve it only through the configurator.

Setting the selection in the configurator

Working in the configurator, we can set the selection of a dynamic list of two species - fixed and dynamic. Fixed selection is configured once, dynamic or software - can be installed depending on any data in the system.

The principle of installing fixed selection in the configurator does not differ from the installation in the user mode described above. To set the selection, we must open the dynamic list settings.

Window opens.

Selection is asked the same as in user mode.

The option "Include in custom settings"Determines whether the selection installed in the configurator will be available in the user mode through the menu item" Configure List ".

Dynamic (software) selection

Often there is a need to set the selection programmatically, for example, when opening a form of choice, when we need to open managed form With the selection. The form pass parameter and the selection is set to this parameter. A frequent example of this is the selection of the elements of the directory by the owner.

Methods

If the configuration is present in the configuration, the BSP subsystem "Basic Functionality" is present, the software selection in the dynamic list can be installed using a typical method:

OutstandingClinerWerver. Establishing elementotor creativity ()

Signature of this method:

Dynamic list Type: Dynamic List - list in which you want to set the selection.

NamePole Type: Row - field for which you want to set the selection.

Running Type: Arbitrary - Selection (Optional. The default value: undefined. Attention! If you are able to convey indefinitely, the value will not be changed).

Victims Type: Vocational CommunicationComponation - Selection Conditions.

Representation Type: Line - Data Layout Element (Optional. The default value: Undefined. If it is indicated, only the use flag with the specified view is displayed (the value is not output). To clean, so that the value is displayed again, you should pass an empty string).

Using Type: Booleo - Use this selection checkbox (Optional. Default value: Uncertain).

Modatography Type: Model Management TelecommunicationCompletes - Method Displays this selection to the user. Possible values:

• Model showing elementNewsCompones. Fast-access - in the group of fast settings above the list.
• Model showing electro-setkomponovkyda. Live - to setting the list (in the submenu still).
• Model showing elementNewsComponovkydata. Extafeated - to prohibit the user to change this selection.

Identifier services Type: String - Unique identifier for this selection (Used to communicate with user settings).

To remove some selection value, you must use the Type method:

OutstandingClinerver. DeleteElementsGroupsTootableDannamic position ()

Signature of this method:

Dynamic list Type: Dynamic Scripts - Props forms for which you want to set the selection.

NamePole Type: Row - the name of the layout field (not used for groups).

Representation Type: String - layout field view.

In the event of the absence in the BSP system, the selection can be installed on its own using the Poland object.

Elementotor \u003d list. Options. Elements. Addly (type ("elementotorbone-block")); Elementotor.levativeness \u003d new half-pink ("FULL NAME"); Elementatub. Environmentalization \u003d vocational assemblyCompon. Elementatub. Himmability \u003d Telecommunication ComplexComotive modes. Estimate access; // Optional elementator. The definition \u003d "Ivanov";

This selection will select the lines in which the value "FULL NAME" \u003d "Ivanov".

For the use of logical "and", "or", "not" is intended for the type of group-elementboratory data

Accounting \u003d list. Options. Electronts. Addly (type ("groupalemotabcompare")); Groupotherapy.TypeGroups \u003d TiberoupElementSeboLeblomBolds. Group. Elementotor \u003d groupotabbing. Elements. Addly (type ("elementotorbone-type")); Elementotor.levativeness \u003d new half-pink ("FULL NAME"); Elementatub. Environmentalization \u003d vocational assemblyCompon. Elementatub. The definement \u003d "Ivanov"; Elementotor \u003d groupotabbing. Elements. Addly (type ("elementotorbone-type")); Elementotor.levativeness \u003d new half-pink ("FULL NAME"); Elementatub. Environmentalization \u003d vocational assemblyCompon. Elementatub. The definement \u003d "Petrov";

This selection will select the lines in which the value "FULL NAME" \u003d "Ivanov" or "Petrov".

The selection in the dynamic list can also be used via a change in the text of the dynamic list request. This option is running when the dynamic list is made through a "arbitrary request".

To do this, add the condition "where the truth" to the query text ...

As can be seen, this approach is more compact from the point of view of writing code. Than more difficult condition The selection in the tabular part we want to establish, the more bulky there will be an option using the selection through elementabon-binding. However, the example with a change in the text of the query has its drawbacks - this implementation is not resistant to changes in code. For example, you made this implementation and forgot, but if in the future you want to modify the query text by adding any operator to it after where (arrange, grouped), you need to not forget about the fact that there are in the program code:

List. The setproof \u003d list. Butterproof + "and directover. FIO in (" "Ivanov" "," Petrov ")";

If this is not to take into account the error, but to avoid this, you can remake another implementation. In the Tex request, add such a condition:

Where (not & selected or the directory users in (& permitted))

List. Parameters. Setting the recognition ofparameter ("selected", FULL NAMES ()\u003e 0); List. Parameters. Installingparameter ("Allowed", FULL NAME);

Here the name is an array.

Ka is seen, 2 lines of code versus 10. Which method to choose depends on a specific applied task.