Dynamic list settings

General
How to place a dynamic list in a form
How to set up dynamic data reading
Other settings

Dynamic list provides a developer with a rich functionality of using various queries to infobase objects for the displayed lists.

This feature is based on the data composition system and allows to apply sorting, filtering, grouping and conditional appearance to the retrieved data.

To place a dynamic list in a form, create an attribute in the managed form editor by using the attribute editor and assign it the Dynamic List type. You should also specify the main table. After that, open the Dynamic list dialog by clicking the List settings link in the list's properties palette and set up the required options.

One of the main features of the dynamic list is a description of data query in the query language. In the forms generated by the system with the help of a wizard, the data query is created automatically.

The query can retrieve data fom multiple tables. You should indicate the main table. It is required so the dynamic list knows which data is primary and which is secondary, so it can select and display the information correctly and provide the standard commands.

Note. You cannot use union in the dynamic list queries.

The Read data dynamically checkbox in the attribute property palette indicates that the dynamic list will read data in small portions. If this checkbox is not set, all the data will be read at once. Independently from this attribute value, in the hierarchical preview mode only the data of the current group will be read, and in the tree preview mode only the data of the expanded tree nodes will be read.

When the query text is entered, the Settings tab is enabled. In the configuration, in the dynamic list settings, the application solution developer can do the following:

  • describe the list filtering;
  • specify the fields to order by;
  • specify the fields for grouping the data;
  • specify conditional appearance settings.

You must specify the sort settings if the default sorting set up by the system is not acceptable. The other settings can be specified if you want to provide them to the user as the list's initial display settings or available options that the user can switch on if required. In the latter case, they should be created with the use attribute unset.

User entered filters are saved automatically for a dynamic list in a managed form. Upon the next opening the stored filters are added to those defined by configuring and in 1C:Enterprise script.

For each settings group, you can specify the following options, which take effect in 1C:Enterprise mode:

Include in user settings - if this check box is selected, the setting is available to users.

Presentation - the text presentation of the setting.

Editing mode - defines where the setting is available:

  • Normal -  the setting is only available in the settings form;
  • Quick access - the setting is available in the settings group of the list form.

1C:Enterprise Developer's Community