1C:Enterprise 8.3. Practical Developer’s Guide. Lesson 19 (0:40). Database search. Full-text search basics

Full-text search basics

Full-text search in 1C:Enterprise is based on two components:

  • Full-text index
  • Full-text search tools

A full-text index is required for full-text search to be available. A full-text index is created once and then should be updated regularly.

The search only covers the data contained in the full-text index. So if a database is used heavily (data is modified, new data is added), the full-text index should be updated as frequently as possible. But if there are moderate volumes of modified or new data, full-text index can be updated less frequently, for example, once a day when the system experiences the least load.

A full-text index can be created and updated both interactively in 1C:Enterprise mode and using 1C:Enterprise script tools. In this lesson we will cover interactive indexing, while the next lesson will show how to update a full-text index automatically.

In a running infobase the platform tracks modifications of data in the configuration objects that can be included in the full-text search. Such objects include exchange plans, catalogs, documents, charts of characteristic types, charts of accounts, charts of calculation types, registers (information, accumulation, accounting, and calculation), business processes, and tasks.

When the full-text index is created or updated, the platform analyzes the data stored in attributes of such objects and includes this data in the index. Note that it is true only for some attributes: those of the Ref, Number, Date, and ValueStorage types, and those of referential type (for example, CatalogRef.Products).

The full-text search itself is performed using 1C:Enterprise script tools. Leaping ahead, we will note here that full-text search is performed in compliance with user rights. So if some data is not available to a specific user, this user cannot obtain this data using full-text search either.

The results of a full-text search are retrieved in batches and they are sorted in a specific order. This increases the chance to find the required data in the beginning of the first batch. In practice, when a search query is written well, the required data is retrieved in the top three to five results.

Now that you understand how full-text search works in general, let us proceed to the first part of the full-text search tutorial: the creation of a full-text index.

Then you will run the full-text search based on the created index.

Leave a Reply

Your email address will not be published. Required fields are marked *

1C:Enterprise Developer's Community