Set the dynamic list parameter 1C 8.3
04/21/2014 Retrieving data from a dynamic list
Implemented in version 8.3.6.1977.
We realized the ability to simply and manually remove the data that is displayed behind the help of a dynamic list.
Data from a dynamic list may be needed in order to differentiate it into a non-standard, “specific” look. Or in order to evict these and other actions from them. For example, send the sheet to all the contractors you have selected from the list for certain characteristics.
In addition, there is a low requirement, in some cases, in addition to the list of elements, who would like more subbag data associated with this list. For example, having selected goods from a particular product group and from a particular postal buyer, you immediately want to increase the number of such goods in the database.
A dynamic list itself cannot provide such information. Maintaining a dynamic list - to ensure a quick review of the great obligations of data. Therefore, the data is calculated in portions required for display on one or two screens. And “he doesn’t know anything,” for example, about the hidden quantity of data that he must take into account.
In order to retrieve additional information, as a personal accountant, you need to enter the data base. Exactly repeats the one who is vikorist in the dynamic list.
You could have made money before. It’s just a matter of course. In addition to the text of the output query behind which the dynamic list is processed, you would need to know all the selections, sorting, etc. parameters that you can interactively set in the table that displays the data.
Now this misfortune is easy to believe. The dynamic list table now has two new methods:
- OtrimatiVikonuvanaData Layout Scheme();
- OtrimatiNashtuvannyaCompositionDanih().
In this way, you take away the very scheme of arranging the data, and, above all, all the adjustments, which is how you want to create the list yourself. You no longer have to programmatically compose the layout and enter its value into a collection (for program processing) or into a spreadsheet document (for display):
As a result, you find a structure (or sound) to place the columns and rows that are displayed in the dynamic list table.
An important point is that the scheme and adjustment, as you see in the dynamic list table, also affects the visibility of columns and search results. So, as the adjustment goes smoothly, you can, for your own purposes, change the field storage and remove, for example, all the items in the list, and not just those, as you can see from the list.
When displaying a spreadsheet document, there is one more important point. The current appearance of the table will be consistent with the current appearance of the dynamic list table at the time of editing and adjusting the schemas. This includes the intelligent design of the table. You will need any additional steps only in the event that you want to transfer the form to a new level.
During the process of further processing the skin configuration, the 1C program encounters dynamic lists.
A dynamic list is an interface object that is used to display various lists of database objects or non-object data - registry entries.
For example, a dynamic viklist is used to display a list of nomenclature:
To demonstrate the capabilities of a dynamic list, we create a new structure, adding the main form. A new detail with the “Dynamic list” type has been added to the form. Let's go to these authorities and marvel at what's there.
We are tsked by the authorities, “The happy drink.” This inclusion will demonstrate to us the power of a dynamic list. We can write a query that summarizes practically all the possibilities of your queries in the 1C system: Entrepreneurship. We establish the order and press the message “Vidkriti”:
Our list displays a list of items with surplus in all warehouses. To implement such a list, add the following command:
As the main table, select “Dovdnik.Nomenclature”, which allows us to work with the dynamic list, as with the list of nomenclature - add, change, mark selected elements of the dvdnik. Also, setting up the main table makes it possible to dynamically read data - this means that the selection will be carried out in portions, as needed.
Next you need to create form elements for our list:
If we try to run our processing in this way, then we remove the error:
To remove this, you must set the “Period” parameter. To do this, you can quickly use the “Set Parameter Values” method in the “Parameters” collection of the dynamic list. The method accepts two parameters:
. "Parameter" - Type: Row; ParameterData Layout. The name of the parameter or data composition parameter whose value needs to be set;
. "Value" - Type: Additional. Significance, which is necessary to install.
You can click in the “When created on the server” form:
Do you have a diet and need help from a consultant?
It is possible for us to change the period for removing surpluses. For this, add the details and associate the “Date” form element with it:
The “Change” function of the “Date” form element has a “SetParameterValue” method, passing the value of the associated attribute. Using a similar procedure, we can change the procedure “When created on the server” of the form. As long as the method is available on the client, calling the server will not be necessary:
Now, when you change the date, the surplus will be automatically updated:
It is acceptable that investors want to earn either surplus or planned expenses. Let's look at one of the implementation options. Dodamo props form a boolean type and connect with it a remix:
When changing the value of the jumper, the text will be changed. For this, the quick sampler of the “When Changing” form element “Display the Knackness of the Step”. We need to change the power of the text of the dynamic list entry in the position of the value of the details. Since this power is not available on the client, the server procedure needs to be called:
The result of the changes made: 
In addition to the primitive types of data that can be found in any kind of software, 1C has unique types. Each of them has its own powers, methods, functions, significance and nuances of the system. One of these types is a dynamic list, which greatly simplifies many application tasks. As a matter of fact, experts in the know and note rely on this universal tool.
Possibility of dynamic lists in 1C
The type assigned to the displayed information from any database table, regardless of its type. The mechanism of creation based on SKD has similar capabilities. But this does not mean that you will definitely have to write with my 1C, although you have the ability and need to speed up. You can simply enter a table, the information from which you can enter and 1C will independently form the simplest query.
To see how a dynamic list is formed as the data shows, you need to open the kerated forms, without deleting them, in the configurator: when transferring details through the context menu, open your authority and pay attention to item “Additional Refill”. If the Daily checkbox is selected, the “Main table” parameter displays the database table, and data is taken from the table. Otherwise, the dynamic list displays data from a wide range of queries, which can be accessed by opening the customized list.
A scheme with a large number of inputs is often used, which gives a wonderful ability to combine and show highly interesting data. Most often, this mechanism is used to display surpluses in warehouses, item prices, receipts, expenditures or purchases. You need to handle it carefully, as fragments of the speed code may change during folding applications.
Another advantage of the power of a dynamic list appears when you click on the message “Customizing the list.” This menu allows you to select a standard set of fields to create information that is more accessible and understandable for end users. Regardless of that, if you ask, you will go to the “Customization” tab, where you can enter:
- Select a dynamic list;
- Grouping;
- Sortuvannya;
- Decoration.
Select the parameters to make dynamic lists universal and complete. You can also link them to the details on the ceramic form, and the data can be changed according to the selected parameters. The nature of these mechanisms can be understood and assessed by looking at the applications of real tasks.
As a butt, let’s look at the design of the image on the cerated form of the excess nomenclature. In real practice, similar statements tend to occur often in different configurations, and a dynamic list is ideally suited as a tool. For this task, we have to make a lot of changes, parameters for the dynamic list and customization.
For greater precision, we will create a separate external processing and place a dynamic list on it. In order to realize the idea of a table with nomenclature, it is not enough for us to allow a sufficient supply. We will describe the left connection of the adviser with the transfer of items and the surplus register and install the adviser as the main table. This scheme allows traders, working with a dynamic list, to add and change the nomenclature.
Since our entry has the “Flow Date” parameter, we need to set this value in front of it in order to complete the calculation. For this purpose, in the form module in the “When created on the server” procedure, a standard command is given to the “Line Date to Session” function. We also need to display a dynamic list on the form that controls it, and change the order of the fields for accuracy. Drag the item “Surplus items” in the form element (upper left part) and use blue arrows to change the order of the fields in the table on the form.
&On the server Procedure When created on the server (vidmova, standard processing) surplus nomenclature. parametr.
Already at this stage we can open our current processing in 1C and see how the dynamic list works. We can marvel at the excesses, create nomenclature and groups, and make jokes. Deputies often ask for the ability to choose a date, as they may have leftovers. For any form with a dynamic list, you will be provided with additional assistance for the structure of the additional field and the installation of parameters.
We add the details “Date of Sales” to the “Date” type and transfer it to the form elements. In the subfield, create the “Change” subsection and write the code for setting the “StreamDate” parameter, which is used in the dynamic record. In order to open the form of the account for the reason on which date you want to collect surplus, make minor changes before the “Creation on the server” procedure.
As a result, our Dynamic List form can display surpluses for any date.
We have seen only a small part of the capabilities of this toolkit, but there is already enough of it to understand the usefulness of this type of dynamic list. A similar mechanism is used for the impersonality of the task, but is most often found in typical configurations in ceramic forms:
- Picking;
- Lists.
To select the dynamic list that appears in typical cerated forms, the designer needs to open the required form in the configurator. In the details section, find details with the “Dynamic List” data type (most often seen in bold). His power will replace the text with the text, selection and other adjustments.
Druk (Ctrl+P)
Dynamic list
1. Secret information
A dynamic list is a special data type that allows you to display additional information from a database table on a form. For which it is necessary to indicate a table, the data must be displayed or described in the selection of my queries.
The mechanism is based on a data composition system and provides the ability to sort, select, search, group and organize data intelligently. In this case, the data should be served by a command that is formed by the system automatically (on the data input base), or is written manually by the developer.
Small 1. Options for creating a dynamic list
When creating the details of the form and type Dynamic List The designer can choose two ways to formulate the data:
● Main table data – in this type, simply enter the table (Main table power) where you need to extract the data, and the system will automatically format the data (the right part in Fig. 1).
● Manually shaped watermarks – for which you need to set the power of the Additional watermark (div. left part small.1). After this, it will be possible to manually form a query to extract data from the information base.
For this additional question, you can select a selection of data from several tables, and then you can specify the main table. This is necessary so that the dynamic list can identify which data are the main ones and which are the other ones, and can correctly select and display information, as well as issue standard commands. However, if it is impossible to indicate the main table in the query, then it can be omitted, otherwise
dynamic list of non-pushable commands associated with the main table. In addition, this option (without inserting the main table) will significantly reduce the efficiency of capturing data with a dynamic list.
In order to increase productivity, it is recommended to use all connections that are used in a sufficient amount of time to extract additional data, and to work with the required data to further expand the data composition system.
For a dynamic list, which is the main form attribute, you can set selection values for an additional form parameter Vidber. For this purpose it is necessary for the name of the power structure to be in the parameter Vidber,
Got rid of the field names in the selection of the dynamic list. In this case, the significance of the power structure will be established as the right value of the selection element. If in the value element of the Select parameter of the form of a dynamic list an array, a fixed array or a list of values is passed, then the option is added to the list, in the right of which the value list is placed (into which the array and fixed values are converted y massif).
As an additional entry in a dynamic list, you can enter an entry in which a parameter is used to formulate the value of any field, for example:
VIBRATE
VIBIR
WHEN Delivery.Coefficient = 1 TODI &Post
Otherwise Delivery. Coefficient
KINETS YAK Coefficient
Z
In this case, the value of the parameter varies depending on the type of object details (for example, Props1 May type Number, and the parameter value is type Row), then for correct display of the track viscont field, explicitly adjust the parameter value to the required type:
VIBRATE
VIBIR
WHEN Delivery.Coefficient = 1 TODI VIRAZITI(&Podannya YAK Row(100)) Otherwise Delivery. Coefficient
KINETS YAK Coefficient
Z
Document.Delivery of Products YAK Delivery
If the field behind which the selection is set is enabled through additional functional options, the selection for such a field is not installed, since the selection value is passed as a form parameter or as a link to the selection parameters.
For the additional power of dynamically reading data to a dynamic list, it is necessary to read data in small portions.
(Report on ways to retrieve data with a dynamic list and cache data in div. below). Regardless of this, the signs are as follows:
● If the review mode is set in the hierarchical list view, only the flow group data and the data of all batch elements (without subordinate elements) will be read.
● If the tree view mode is set, only the data of the closed tree nodes is read.
● One-time acquisition of data from a dynamic list is not allowed between the installed hierarchical view (the authority of the Image is set to Tree) and the cob image of the tree installed in Uncover all Levels. To retrieve the data, as many queries will be sent to the server as there are nodes in the list that is displayed.
Within the framework of one abstraction of data, the dynamic list is re-visored from the previously created time table when the next minds are added:
● For a batch entry list, the daily entry is after the main entry of the package.
● The warehouse of time tables and fields is unchanged from the front window of batch power supply.
Its robot has a dynamic list of vikory values of the current authorities of the details of the metadata of objects:
● format,
● editing format,
● hint,
● sign of seeing negative values,
● mask,
● sign of a high-order mode,
● expanded editable sign,
● password mode.
When displaying and editing the selection and parameters of the data composition system, the format for editing the corresponding field is selected.
2. Limitation and particularity
When the selection of a dynamic list is set up, the memory trace is not included in the selection of groups if the display mode is selected for the dynamic list: Hierarchical list or Tree. By “groups” we mean the element of the witness and in terms of the types of characteristics that carry the power of the Group, the value of Truth is established.
Selections that are automatically superimposed by a dynamic list on the standard details Vlasnik, Batko, Date, Period and This Group will be fixed
standard features of the data composition system. The selections, which are automatically superimposed by a dynamic list on the key fields, can be combined both by standard methods of the data composition system and by the way of directly adding to the text in your mind U main table fields. As a result of stagnation of selections by layout methods, they may be stagnated both in embedded queries and in the parameters of virtual tables.
Before creating dynamic lists, it is recommended to check all dynamic lists with the correct queries. During the verification process, the track will be re-converted, so that when you enter a list of present contributions or virtual tables, and in them fields with aliases are available for selection, which are avoided with aliases of standard details Vlasnik , Father, Date, Period, Tse Group or key fields, then ts The fields effectively correspond to the standard details with which they are used as an alias. If this is not the case, change the next track to get rid of the stinks or
pseudonym changed.
If manual forming is selected, the following steps are superimposed on the input:
● It is not possible to change the number of insertions FIRST when entering a dynamic list. If it is necessary to select a selection in a dynamic list that is divided into a number of records, then rework the dynamic list formation in such a way that the replacement part of the query is placed in the feed and surround the number of holding records in this sub-subscription. Instead of subscribing, you can use the time table.
● Selection, sorting and grouping are not supported:
- For details of table elements.
- Fields
- DataVersion field.
- Field Name of Preliminary Data.
- Field for submitting the table to the layout plan.
- Field px of the accumulation register table.
- Field TypeValues of the table for the type of characteristics.
- Type field Type;
- Field of the Row type (doubles not demarcated).
- Field type DualData.
● Sorting and grouping by Subconto fields is not supported<НомерСубконто>that ViewSubconto<НомерСубконто>RuhuSubkonto tables of the accounting register.
● Grouping by fields is not supported, such as in the form of queries to accommodate aggregate functions.
● Once the main table is selected, the dynamic list can be entered as follows:
- They are not encouraged to eat.
- The following sections are not supported ORDER BY. The vikory track should be entered without the main table, or it is necessary to specify the ordering through customizing the dynamic list.
● If the dynamic list is displayed in the hierarchical list or tree view, the entry will not be displayed in the dynamic list, as one of its other entries will not be displayed. In other words, to display an element in a hierarchical list, a dynamic list must display all the members of that element up to the top of the list. With whom at the top of the list lies respect and authority
the root element of a hierarchical object, which is displayed by a dynamic list, or an element that is established as the authority of the Fatherland of the Upper Level of the extended table form for the dynamic list.
The main table of the dynamic list of successive tables is not supported:
● A table for which the daily key that uniquely identifies each table entry (sent for object tables and the entry key for the register table). However, such tables can be installed as the main table of a dynamic list (regardless of the presence of the key):
● Subconto table of the accounting register;
● all virtual tables of the accounting register, except the RuhuSubconto table;
● tables of constant values (including the Constanti table);
● tables of external data sources without key fields;
● tables of external data cubes;
● accumulation register tables:
- turnover table;
- surplus table;
- table of turnover and surplus.
● tables of the register structure:
- actual period table;
- graphics data;
- basic data.
● Tables of tabular parts of objects;
● Change registration tables (as determined by data exchange mechanisms);
● Sequence tables;
● Tables of reorganizations (which are determined in the mechanisms of periodic reorganizations).
● Tables that may be used only by outsiders.
In other words, a dynamic list from a designated main table works correctly in the case where the result is a search query,
designated as a body of data, the number of rows contained in the main table (with the arrangement of the applied selection) does not increase. As a result of editing, the number of rows that are removed from the main table increases, leading to the destruction of the uniqueness of the key of the table records that are displayed as a list. For this option, you need to include a vikoristan table in the dynamic list.
When working with a dynamic list, you must ensure access rights to the details that are displayed in the list:
● Data from dynamic lists is not transmitted to the client side, which is assigned to the authorities to review in the future, and for which the in-line correspondent has the daily right to Review. Access to the data of such columns (using the additional power of StreamData and the DataRow() method)
on the client side it is impossible.
● Since the flow-based account manager does not have the right to review the key field of the dynamic list, removing data from this dynamic list will result in violation of access rights.
For a dynamic list that displays the transfer list, it is possible to interactively customize the list.
The warehouse of columns and customization of the dynamic list associated with the fields will be filled with aliases of the selection fields. Just as in the entry for the selection field, the alias of the non-tasks is explicit and the field is systemic, then the name of the field for the English version of the downloaded language is used as an alias.
Specifying links means that when changing (or explicitly specifying an alias for the field that has an automatic alias)
The alias field of the query that forms the data for the dynamic list will be spent adjusting the details of the dynamic list, the form elements will “waste” the details that are displayed, adjusting the dynamic list will become incorrect, etc.
Since the data for a dynamic list contains a table (either virtual or virtual) that allows you to set a selection after a period, then the user sets the display period in such a dynamic list (the Set Interval command dates...),
the settings between the periods will be set as the values of the selection or parameters of the virtual table. How to expand the movie in your own way
In queries for the data composition system, the names of the parameters of the virtual table are explicitly specified - parameters will be installed from the specified ones
names. Tables that can be processed during the period of modification or data processing:
● tables of registers (basic and virtual), which can be selected by period (for a registry, by registration period);
● main tables of documents, business processes and tasks;
● main tables of document logs;
● main tables of sequences, tables between sequences.
As a parameter to a dynamic list, it can be an array or a list of values. However, if the parameter is a list of values, then the value of the selection will only come before the value of the list. Since the dynamic list of the vikoryst is loaded with parameters, the initial setting of the parameter values must be entered into the summary when the server is opened.
When displaying data in a dynamic list, remember the following features:
● If the program changes the authorities of the dynamic list, it does not automatically refill the command panels associated
From this dynamic list.
● Since a number of fields are grouped into a group using the grouping mode for the merchant, and in the grouped fields there is a field that is displayed as an ensign, then this ensign will henceforth be displayed as the first for the merchant that is released (left to the text ).
In a dynamic list, when a data type is assigned to fields, the warehouse of expressions which includes parameters, fields or literals, the resulting type is assigned to the types of fields and literals. If the value type of the parameter is not included before the resulting data type, that value will be truncated.
For example, for an offensive butt the field has a matime type of Number.
VIBIR
WHEN IT'S FALSE
TODI 5
Otherwise
&Parameter
KINETS
To customize the Parameter value parameter of another type, the dynamic list for this field has a value of 0 (the same value for the Number type).
In this situation, it is necessary to select a parameter of a different type - it is recommended to use the correct design of your queries VIRAZITY. For example,
If the hovered application needs to pass a row of no more than 100 characters to the parameter, then replace the simple insertion of the parameter with an explicit hover type:
VIBIR
WHEN IT'S FALSE
TODI 5
Otherwise
VIRAZITY(&Parameter YAK Row(100))
KINETS
If you enter a dynamic list in a sufficient text, the selection fields will have parameters selected, you must explicitly indicate the type of parameters behind the additional construction. VIRAZITY. For example, zamіst Nomenclature YAK Nomenclature vikorystuvati
VIRAZITY(&Nomenclature YAK Dovidnik.Nomenclature) YAK Nomenclature. In another case, you can search through the row by searching
incorrectly chi vidavati pardons.
3. Methods for extracting and caching data with a dynamic list
When selecting data for display in a dynamic list, choose one of three methods:
1. Reading from the database is compiled in portions from a large number of data elements, which greatly exceeds the number of rows that are simultaneously displayed in a list (at least 20). Data caching on the server is not configured.
2. Reading from the database is arranged in rows of 1000 data elements. Data caching is configured on the server. Hierarchical data is cached: the skin dad is cached with more than 2 sides of elements. One dynamic list caches more than 20 pages of elements. Cashing will be included in the dynamic list for the next table:
● Selection criteria;
● All tables in the accounting register, in addition to the main table and the RuhuSubconto table;
● All tables in the accumulation register, in addition to the main table;
● All tables in the income register, in addition to the main table;
● All tables in the register are organized, except for the main table;
● Virtual table ZavdannyaPo Vikonavtsyu;
● Tables of external devices without keys;
● Cubes of foreigners.
3. Reading from the database is arranged in sides of 1000 elements. The first portion is equal to 1 side. The portion applied to the skin will increase by 1 side (if the end of the front sampling has reached). The closer the “look point” is to the end of the data, the larger the selection is counted from the database, among all the data being processed. Data caching is configured on the server. The maximum number of entries in the cache and dynamic list is 1,000,000.
In addition to the fact that the main table of the dynamic list is compiled in such a way that the power of dynamic reading increases, other methods of reading data are also explored:
● In light of the importance of power, the main table is shown in the following tables: exchange plan, document, list of documents, document log, plan of types of characteristics, plan of divisions, plan of types of development, business process, task, table of business process points:
● As the meaning of power, the main table is indicated in one of the following tables: the main table of the accounting register, the accumulation register, the accounting register, the distribution register, the virtual table of the accounting register.
● Power Dynamic reading:
● Installed: method 1 is selected (a description of methods is provided below).
● Discarded: method 2 is being used (visible).
● How to power The main table shows the table for selection criteria or the table for the command of the Vikonavian (Zavdanya Po Vikonavts):
● The key that identifies the table row: Posted.
● As a power The main table contains a virtual table of the register of reports Slice of the First or Remaining:
● Key that identifies a table row: Record Key.
● Power Dynamic reading does not stagnate.
● Method 2 is used (visible).
● As a power The main table shows one of the virtual register tables, in addition to the reinsurance assets:
● Power Dynamic reading does not stagnate.
● Authority The main table is not specified, the additional entry is entered:
● Key that identifies a table row: Number.
● Power Dynamic reading does not stagnate.
● Method 3 is being tested (a description of the methods is given below).
For display, data is transmitted to the client in portions, the size of which is similar to the portion size in 1 method of reading data (descriptions on the beginning of this section).
When a form is created to accommodate a dynamic list, 45 data elements are transferred to the skin visible dynamic list (as the list has more than 45 elements). If the dynamic list displays more than 45 rows, then when you open the form, an additional server call will be displayed to extract all data elements.
4. Customizing the dynamic list
The power of customizing the list is the pressure of hyper-force to open until the form of customizing the dynamic list is opened. The customization of the list is completed in the same way as similar operations in the data composition system.
Small 2. Smarter design of a dynamic list Once the dynamic list of configurations has been adjusted, the application solution developer may be able to generate the following:
● set the fields that need to be sorted;
● describe the selection of data from the list;
● indicate the improvement of mental design;
● insert fields that require grouping of data.
Specifying sorting to the distributor makes sense, as it is not a power sorting that is installed by the system, behind the scenes.
PORADA. Keep in mind that the short selection of sorting fields (as well as selection and grouping of data) negatively affects the effectiveness of dynamic selection.
From the perspective of an applied developer, the development of a dynamic list consists of many parts interconnected. The main power through which you can adjust the dynamic list is CompositeNalashtuvan. This object contains three sets of adjustments, which, when the system is running, determine the remaining settings that will be consolidated to a dynamic list:
● Settings - Settings created in the Configurator mode. The power of the dynamic list The order gives quick access to the power of Adjustment. The order of the builder to adjust the dynamic list, in this manner, such constructions are equivalent:
List.Order and List.LinkerAdjustment.Adjustment.Order;
● Setting up the server – these are the settings that change the server in the “1C:Enterprise” mode;
● Fixed Settings – these settings are installed from the downloaded movie. Also, this power consumes the selection values that are transmitted to the form for additional parameters. The power of the dynamic list Select, Options, Smart Design gives quick access to fixing the layout parameters of the dynamic list. In other words, the data are equivalent:
List.LinkerAdjustment.Fixed.Adjustment.Select and List.Select.
When forming the residual configuration of a dynamic list of various options, the adjustments are combined in the following order:
● If any type of adjustment of a whole set of values is like a koristuvalnitsky one, then as a result the settings will be wasted by the koristuvalnik’s adjustment
(List.CompositorNalashtuvan.Nalastuvannya koristuvacha). If any elements of the configuration are marked as unavailable, then the configuration will be placed in the resulting configuration from the power of List.LinkerConfiguration. Adjusted.
● If there is any kind of adjustment of meanings, if not completely, but element by element, then:
● Elements designated as koristuvachka, to be used in the resulting adjustment from the power List.LinkerSettings.Koristuvachka settings.
● Elements marked as unavailable will be removed from the resulting adjustment from the power of List.LinkerAdjustment.Adjustment.
● Fixed adjustments (List.LinkerAdjustment.FixedSettings) are added to the resulting adjustments “as it is”. In this case, the situation is unacceptable if the fixed and adjusted values of the teacher are at the same time adjusted, for example, choosing from the same left values in the mind.
When setting up a dynamic list, there are parameters that are selected for additional functional options that will be removed from the list of available settings when the data from the dynamic list is removed.
The choice of which parameters will be available to the user, and which ones will not, is indicated in the dynamic list window.
Small 3. Control of inclusions until the controller is adjusted The sign at the bottom of the window (div. small 3) indicates placement in adjustments (either basic or short) of all types of adjustments. This potential is available for selection, order, grouping and mental design. If the adjustment is specified in the Quick select editing mode, then the power of the Group is to adjust the form table, which displays a dynamic list, it is necessary to indicate an empty group of the form in which the elements associated with this will be placed Visible adjustments to the dynamic list. If the group is not specified, the account settings details will not be displayed on the form. It is also possible to explicitly click on the creation of a kistuvach for an additional inspired language for the additional method of Creating Elements of the Form of a customizer () to expand the dynamic list.
It is also possible to select the placement of specific adjustment elements in settings. This potential is available for the elements of selection and mental design (div. Fig. 3).
If there is a need for special adjustments when creating a dynamic list, this can be done in two ways:
● For additional parameters of the dynamic list Adjustment of the koristuvach. The data that is contained in this parameter will be placed in a customized dynamic list.
● For additional parameters of the form of a dynamic list of Keys, adjust. If you enter this parameter when you open the form, then the dynamic list, which is the main requisite of the form, will include the settings of the user, which will be expanded in a manner similar to the settings from the designated key.
5. Search the dynamic list
A dynamic list, displayed on the form, allows you to select an interactive search from the data that is displayed. The search can be performed using the following tools: search rows, dialogue search, stream value search, additional search history and set periods (for dynamic lists that display documents). The result of the search is a set of records
dynamic list (of those available to this user) that meet the search criteria.
To explore the possibilities of searching in the dynamic list, there are three powers of the table of the ceramic form that displays the dynamic list:
● Poshuku row position—Value the poshuku row position. You can accept the following values: Auto, Command Panel, Ні, Top, Bottom.
Small 4. Search for a dynamic list If the value of this power is installed on the Command panel, then in the command panel of the form (as the dynamic list is the main requisite of the form) or in the command panel associated with the dynamic list, a search row will be displayed. The search row, placed on the command panel, is then pressed to the right edge of the command panel (at the same time as the buttons located to the right of the search row).
If power is set to Ni, then the search row will appear on the form, and when the search row is set, a dialogue will open.
If power is set to the Top value, the search row will appear between the command panel of the list and the table that displays the dynamic list. If the power is set to the Bottom value, the row of placements will appear immediately after the table, which displays a dynamic list.
● Powerful Power mode is set to Do not abuse or older than the value Version 8.3.4 – Command panel.
The transition to the search row proceeds as follows:
● Pressing the keys Ctrl+F;
● Misha;
● When you start typing in the dynamic list (with the understanding of the power of the dynamic search list).
● Position of the review – describes where the review position is displayed: what fields are searched for and what are the meanings
joked around the skin. You can accept the following values: Auto, Ні, Top, Bottom
Small 5. Look for a dynamic list If power is installed in the meaning of Ni, I will look at it in the form. As a result, if a search has been entered, you will no longer be able to click on the search button if the search button is available.
Once Power is set to Top, you will be able to see the changes between the list command panel and the table that displays the dynamic list. If the power is set to the value Bottom, it will look at the placements immediately after the table, which displays a dynamic list.
If the form was created in “1C:Enterprise” version 8.3.4 and later – the power is set to No. If the form was created in “1C:Enterprise” version 8.3.5 and older, the power is set to Auto. The real meaning of power is as follows:
● Powerful Power mode is set to the value Version 8.3.4 (and below) – value No;
● Like power The power mode is set to the value Do not vikorize or older than the value Version 8.3.4 – value Top;
● Sound check position – this means where the sound check button will be displayed. The button opens a menu where you can place the following information: commands Find more precise values, Extend searches, Extract searches, Set period (for lists of documents and journals) and history of search queries (the remaining 5 queries). Power can be set to: Auto, No, Command Panel.
Small 6. Manage searches from a dynamic list If the power is set to the value Н, then the search control button will be visible on the form (otherwise the commands will be available under the additional More menu). Power Values The Command Bar places a button on the command bar, linked to a table that displays a dynamic list.
If the form was created in “1C:Enterprise” version 8.3.4 and later – the power is set to No. If the form was created in “1C:Enterprise” version 8.3.5 and older, the power is set to Auto. The real meaning of power is as follows:
● Powerful Power mode is set to the value Version 8.3.4 (and below) – value No;
● Powerful Power mode is set to Do not abuse or older than the value Version 8.3.4 – Command panel;
Since the form has a number of command panels, the number of commands for which is one table of the form (which displays data from a dynamic list), then the search row and the search control button will only appear in one command panel:
● Or in the command panel of the dynamic list (where automatic filling is indicated for it)
● Or any of the command panels that are missing.
Let's take a look at the peculiarities of search for a dynamic list:
● In order for the search to be manually searched (including from the point of view of the speed code), it is necessary to open the full-text search for all configuration objects that can be searched as the main table dynamic list. Also, a full-text search is subject to all the details of configuration objects that may appear in the dynamic list for which the search may be needed.
If the object is turned off from full-text search, the search mechanism will work, otherwise the productivity of such search will be extremely low. It is not recommended to search search by object, as it is not indexed by full-text search.
● The application solution has a regulatory requirement that regularly updates the full-text search index.
● The search is not calculated for all columns of the dynamic list (and the configuration object), but only for the columns that are displayed in the table.
● The search for a dynamic list on the fields of the sent types with sufficient tributes is matched by the fields that are searched for
formative manifestation (div. here). The fields that must be entered before being entered will be removed from the ordering of the sampler.
● For dynamic lists with a designated main table, the full-text search behind the main table is searched. All non-indexed messages from the main table will be returned to the results of the full-text search. The result of a full-text search for the main vikory table is represented as a selection of key fields. The full-text search is also associated with the fields that are displayed in the list of other tables (as for the field and configuration object, the full-text search is displayed). Without a detailed full-text search, the data may be
It is known, but the search itself will be completely screwed up.
If you try to create a full-text search, the search will be canceled without stopping the full-text search.
For example, this may be the case when searching for one letter and a large number of rows in the information base that begin with this letter.
● If for the field of the main table of the dynamic list a selection with the type of equalization is selected, then when a full-text search is added to the search query for this table, the selection value will be added.
● The sequence is randomly broken down into words. This follows the following rules:
● The row is divided, vikoryst symbols, spaces and tabs as separators.
● Then the skin fragment is formed, which results in:
● Each fragment is a given date (with or without an hour) according to the exact regional settings of the session, in other words, the entire fragment.
● Otherwise, the fragment is split further, separated by the symbols “,.-/\”. In this case, how the word is taken is a skin fragment of a row, scho vyishov.
● For each word, its own set of minds is formed, as “ABO” is united. This set of minds is formed in the same way as the full-text search for a given word in the table from which this field was removed, rotating at least one object or the full-text search was not selected for that field. The mind is formed like this:
● For a field of the Mind Row type, the appearance of the Field Name is similar to %Word%.
● For a field of the Number type, the view is Field Name=Value, and the Value is the same word as it is pointed to the Number type. If it’s impossible to bring a visconty, you won’t be able to search across the field.
● The word appears as a sequence in a typical data for a Boolean type, intended for a threaded session. If a word is found in the given word, then the search for the meaning corresponding to the manifestation in which the word is found is concluded. In this case, for the sake of humor, the manifestations assigned to the additional power of the form element Format are not used.
● For a field of type Date of Mind, the view is Field Name>= CobDay(Word) and Field Name<=КонецДня(Слово). Если Слово подобно дате, в которой год
indications in one or two digits, the river will be given to the flow rate and then the value will be submitted to the sound mind.
● For posilalnyh fields, a search is made for the fields that are vicorized for molding the given poslannya. Look for the skin in these fields
follow the rules described above. Fields are not used for research, but fields are used to formulate a sufficient representation of the data.
The set of minds of each word is united “according to I”.
● For a value with leading zeros, searches can be entered either in the order with leading zeros or in the order entered without leading zeros.
● Since the dynamic list displays a list of documents or a document log, the task interval for reviewing the list is also displayed in the area of the form provided for displaying the review for the required dynamic list.
● The search for exact values command is not available, since the main table of the dynamic list is the selection criterion.
● Found fragments of rows are visible during the hour of display in the table.
● For one column, only one sound row is supported. When adding a new sound word to a column that already has a sound next to it, the sound word will be replaced, rather than adding two sound terms.
● If on the form there is an additional form element in the form of a display row, associated with the table (the power of the additional form element), which displays a dynamic list, then pressing the Ctrl+F keys will open the dialogue. ku.
Small 7. Dialogue by joke If the form has an additional form element that displays a search row, associated with the table (the power of Dzherelo is an additional form element) that displays a dynamic list, then to open the search dialog, use the Search Extensions command.
● When selecting a dialogue, keep in mind the following features:
● During the dialogue, click on the selected keys until the values of the flow mixer appear in the What to look for row, and the values of the jumper How to look for are set to the For exact run value.
● When opening a dialogue, search the path of the middle cob to set the search row in the dynamic list until the value of the switch How to search is set to the value Partially of the row, and the text that is being typed is lost in the What to search field.
6. Selecting data that is displayed in a dynamic list
When selecting dynamic lists, you may need to view various actions with the data that is displayed by the dynamic list, with the arrangement of selection overlays and frozen searches. Such actions include: processing of information that is displayed, for example, re-processing of viewed documents or setting any details for visible objects, generating a list of available objects (with forms, etc.), for example, for friends or for saving into a spreadsheet document.
To extract data that is displayed in a dynamic list, use the method OttrimatiVikonuvanu Data Composition Scheme () and
OtrimatiNashtuvannyaCompositionDanih().
The butt of the data:
Schema = Elementi. List. Otrimati Vikonuvanu Scheme Composition Data ();
Setup = Element.List.OtrimatiVikonan_NashtuvannyaCompositionData();
LayoutComponent = New LayoutComponentCompositionData();
LayoutLayout = LayoutLayout.Viconati(Scheme, Setup);
ProcessorComposition = New ProcessorCompositionData;
ProcessorLayout.Initialize(LayoutLayout);
ProcessorVivodu = New ProcessorVivoduResultCompositionDataInTabularDocument;
TurnProcessorOutput.Output(CompositionProcessor);
Taking data from a collection of values (table and list of values) is formatted in a similar way.
Retrieving data from a dynamic list with the specified order involves a few special features that need to be taken into account during the development of application solutions:
● The following table design is not supported:
● Drawing colors of rows;
● Header picture;
● Picture in the basement;
● Color the background of the footer;
● Color the text in the footer;
● Font footer;
● Horizontal position at the basement;
● Password mode.
● There is no need for careful decoration, as indicated for the ceramic form;
● When a hierarchical table is ordered by row, by a field of the Posting type, the records that are empty will be placed first.
The dream of some kind of “family man” was born. As often as not, users of programs 7.7 asked for a normal selection of nomenclature. So that the excess can be drained, priced, and filters installed. I had to figure out all sorts of tricks, right up to the writing of external components. 1C 8.2 introduced dynamic lists. I’d like to take a look at what this is and what the smell can be in 1C 8.3.
We take as a basis the 1C test configuration: “Business Accounting 3.0”. We won’t work on the selection at once, we’ll just add one more selection form to the “Nomenclature” adviser and select the main one:
When the system is completed, add a table field of the “Dynamic List” type to the form.
Let's go to these authorities and marvel at what's there.
The ensign tsked in front of us, “Good drink.” This will show us all the advantages of a dynamic list. We now have the opportunity to write a simple command with parameters. We establish the order and press the message “Vidkriti”:
A window with the prepared code will open. In fact, all the fields of the “Nomenclature” appendix have simply been redrawn.
Watch 267 video lessons from 1C free of charge:
As a matter of fact, there is a button on the “ ” button that allows you to dynamically change the list. So, if another client changes something with the agent, our list can change. In addition, there is a “Customization” tab, and we will refer to it later.
Powerful request to the dynamic list
From now on, we will immediately need the solution from surpluses and prices. Something like this:
Bookmark “Nashtuvannya”
The first axis is now the tastiest! Let's go to the "Customization" tab. And it is immediately important that on the first deposit we can work in any selection from any field in the entry:
Program for setting parameters in the dynamic list 1C 8.3
Don’t forget that we have two parameters for the entry: “Period” and “Price type”. It is our fault to pass them on, otherwise there will be a pardon.
We will write these parameters in the form parameters, and in the form module we will add the following rows:
&On the Server Procedure When Created on the Server (View, StandardProcessing) List. Parameters SetParameterValue("Period", Parameter. Date) ; Perelik. Parameters SetParameterValue("PriceType", Parameter.PriceType) ; KinetsProcedures