Scope: a managed application, a mobile application.
1.1. Upon development, developers can use groupings in dynamic lists (see List groupings).
Developers can do the following:
- Set default groupings in dynamic list settings.
- Add special controls to the form (menu commands, selection fields for quick grouping, and other). With these controls, users can set their own groupings.
This standard lists conditions that developers must meet if they anyhow manage dynamic list groupings.
1.3. Use groupings in dynamic lists with few entries (up to one hundred entries). You can ensure a small number of entries in the list by setting a filter in the dynamic list query or in the dynamic list form. Users must not be able to remove the filter.
This requirement is due to the following specifics of dynamic lists. To start grouping, a dynamic list needs to select all unique field values from the database table. The grouping is based on the selected field. After that, the results are sorted and displayed to users. When users expand a grouping value, a dynamic list selects all table entries with the specified value in the field.
- A field for the first grouping must be indexed.
- Few entries of the database table must correspond to each value of the field for the first grouping.
When users expand subsequent groupings after the first one, the dynamic list will process them without using indexes by all items selected in the first grouping.
1.6. We do not recommend that you make groupings by fields, which are metadata object characteristics. If characteristics are output, LEFT JOIN with the characteristics table is established. That is why a query with filter by a single characteristic will not be effective even if an index is available (anyway, scanning is performed by the main table).
For more information on specifics of dynamic lists, see the platform documentation (Dynamic lists).
3. You can disable search strings in command bars of dynamic lists if they do not support basic search scenarios. For example, search by product ID part is essential in the product list, but it is not supported by the search engine.
This limitation applies because usually the search starts from the beginning of words if a full-text search is used. In 1C:Enterprise 8.3.7 platform and earlier, this engine is even more limited. In particular, search results do not include the items, which are not indexed yet.
To disable a search string in the command bar, set the SearchStringLocation and SearchControlLocation properties of dynamic lists to None. None is set by default for the forms created in previous platform versions.
See also: Queries in dynamic lists