Quick search does not work in 1s 8.3. What is quick search

Tricks when working in 1C: Accounting 8.3 (edition 3.0) Part 2

With this article, I continue a series of notes on effective methods of working in 1C: Accounting 8.3. I talk about tricks that few people know and even fewer people use in their work. The techniques that will be discussed can significantly save time and improve your skills as a specialist. The first part is available.
P

Technique #4: Search in the current column right after you start typing.

How are you not taking advantage of this amazing opportunity? In any magazine (be it a reference book or documents), highlight any line in any column and just start typing.

The system will automatically select rows that contain the value you enter in one of the columns:

If you need to cancel the filter - press the Esc button on the keyboard or on the cross in the search field:

But what if we need to search not in all columns, but only in a specific one?

To search in the current (selected) column, use the Alt + F combination or the "More"->"Advanced search" menu item:

For instant selection (without displaying a dialog box) by the current column and by the value selected in it, use the combination Ctrl + Alt + F or the "More"->"Find:..." menu item.

For example, let's select all documents in the number of which the number 8 occurs. To do this, select the "Number" column in any row and press Alt + F.

In the window that opens, type the number 8 and click "Find":

Great, there are documents in the list in the number of which (in any position) contains the number 8:

To cancel the selection, press the combination Ctrl + Q or remove the selection from the top panel (cross):

Attention! If the search does not work (an empty selection is obtained) - you probably have full-text search enabled and its index has not been updated.

Full-text search is configured in the "Administration" section, "Support and maintenance" item:

Reception number 5: Input in the input field by line.

Suppose you need to fill in the counterparty field in the document "Receipt of goods and services" and you know that the counterparty is called something like "aero".

And you, instead of choosing a counterparty from the list, just take it and start typing the text "aero" in the counterparty input field. As you can see, the system itself suggests possible options for counterparties that begin with these letters. The desired Aeroflot has been found - it remains just to select it.

And so it is possible in any fields!

Technique #6: Summarizing selected cells in reports.

Just select the desired cells with the mouse - the amount will automatically be displayed in the field indicated in the figure. And if you need to select cells that are not adjacent - use the CTRL key. Hold it and select the desired cells in the report to get their sum.

Reception number 7: Save any printed forms in any convenient format.

Any report or printed form document can be saved in a suitable format to a computer. Just create a printable and click on the floppy disk icon at the top of the program window.

Now choose a name and format for the document. It can be excel, word, pdf, html and many other popular formats.

In this article I will tell you about the quick search function 1C Enterprise 8. What's happened quick search? Very simple. Quick search is one of the ways to navigate in large lists of 1C records. These can be lists of documents, directories, registers - everything that is represented by tables.

What is a quick search?

The quick search function in 1C Enterprise documents is extremely convenient and allows you not to scroll through huge arrays of data (for example, using the scroll bar), but to immediately jump to the desired place in the list. Unfortunately, novice users of 1C Enterprise 8 (including 1C Accounting 8) at first do not use the quick search capabilities, preferring to scroll through the lists of documents manually (and they can be Very large). This article will help you figure out how to use a quick search in 1C.

First of all, it should be noted that in 1C Enterprise 8 configurations built on managed forms, quick search works differently than in previous versions 1C. Therefore, we will analyze separately the use of quick search in managed forms and in ordinary.

Quick search in 1C Accounting 8.2

In versions of 1C Accounting from 8.0 to 8.2 function is intended for transition to the desired part of the list. For an example, look at the chart of accounts window shown in the figure.

A line is selected in the window. Note the subtle triangle of stripes pointed to by the red arrow. As in other Windows programs where there are lists (for example, in Explorer), the position of this marker (triangle) determines the sorting of the list as a whole − in which column the marker is set, the entire list will be sorted by that column. In the figure, the marker is in the Code column, so the accounts in the chart of accounts will be sorted by code.

The marker can be moved from one column to another by clicking on the desired column ( on the HEADING column!) with the mouse. If the marker is already in the current column, then clicking will reverse the sort direction (i.e. from larger to smaller or vice versa). This is standard behavior for any Windows programs. What is the peculiarity of this marker in 1C Enterprise and how is it related to quick search?

A quick search in the 1C Enterprise 8 lists is carried out according to the column in which the marker is located. In this case, a quick search in the chart of accounts will be carried out in the Code column.

There was an important part of the article, but without JavaScript it is not visible!

How to use quick search in 1C? Easily! Just start typing what you want to find in THIS column, i.e. where the marker is. In the example in the figure above, you must enter the account number. For example, you want to find account 50 Kassa . In this case, enter ( You don't need to click anywhere!) the number 50 from the keyboard, and if there is an account with this number in this column (and, of course, there is one), then the list will scroll to this line, and the line itself will be highlighted. The result is shown in the chart of accounts screenshot below.

The text that the arrow points to no need to wash afterwards- he will disappear.

If, in the above example, you start typing the word "Cashier", then the text at the bottom of the window will be entered and then erased. This happens because as soon as Start of the entered quick search line no longer matches the beginning of at least one line in this column, 1C Enterprise concludes that the searched line was not found and automatically erases it. Due to this two rules to remember.

In 1C Enterprise 8, a quick search is performed at the beginning of the line, i.e. in the column, the match of the input text with the beginning of one of the lines of this column is searched.
This leads to an important recommendation: when entering data into directories, name the elements so that it is convenient to search for them using a quick search. For example, it is better to write the name of the counterparty as "Company Name LLC" than "Company Name LLC". And even more so, you should not use quotation marks and other unnecessary characters in the name ( we are talking about filling in the Name field in the forms).

If you start typing text and it is erased, what you are looking for is not in this column! In this case, check the input language, as well as the column in which the quick search is performed. Common Mistake- Wrong column selected. For example, the marker is set in the Code column, and the search is performed by the account name.

Quick search in 1C Accounting 8.3

Now let's see how quick search differs in version 1C Enterprise 8.3. Usage is very similar to version 8.2, but there is one major difference to remember.

In 1C Accounting 8.3, as well as in any other configurations on managed forms (the same new interface) works as a filter. Simply put, as a result of the quick search function, part of the list hiding.

How to use it, we will now find out. To get started, look at the screenshot of the chart of accounts window 1C Accounting 8.3 below.

As you can see, the same marker is in one of the columns. The search is also performed by the column in which the marker is set. This has all remained unchanged. However, if you start typing text (in the example, the account number), the following will happen.

As you can see, the search box just automatically opened. The exact same window will open if you click on the search button on the window toolbar (underlined in the figure). As a result, when you click the Find button in the search window (hidden behind the drop-down menu in the picture) or simply Enter, you will get the following result.

From here it is clear that a quick search in 1C Accounting 8.3 simply leaves the part of the list that meets the search conditions visible. In this case, the Find button disappears, and instead of it, a lens with a cross appears (underlined in the figure), when pressed, the list returns to the initial state(while the line found as a result of a quick search remains selected).

Another important feature of a quick search in 1C Accounting 8.3- a match is not searched at the beginning of the line, as in version 8.2, but a search is made for a match with any part of the lines in the column. Thus, if the counterparty is called "Company Name LLC", and when searching, start entering "Company Name LLC", then the line will still be found!

Drawing conclusions

Thus, quick search in 1C Accounting 8.2 and earlier versions is intended to scroll the list to the desired line, and in 1C Accounting 8.3, quick search works like a regular filter, hiding the part of the list that you do not need.

Despite the fact that full-text search on the 8.3 platform was announced by developers a long time ago (since the 8.3.5 platform), it was not actively used in standard configurations. In recent releases of Enterprise Accounting 3.0, developers have included full-text search in many lists. For my users, this turned out to be a shock - the program stopped searching.

Of course, full-text search works, but users, not seeing the "Find" window, are confused. Typical usage scenario: Start typing on the keyboard, while typing, a "Find" window appears, indicating the field to be searched, the text to be searched, and the search mode "Part of the string".

By pressing the enter button, the list is filtered, a search status bar appears above the list. The user himself determines in which field and what he is looking for. The new search starts working as soon as you type it and affects all fields displayed in the list. Separate window does not appear, all matches of search words are highlighted in color.

For several days we lived with a new search. Users suffered, complained, sabotaged. Complaints did not stop, the management was given the task to "make everything as it was."

Where to begin? You need to understand how the forms differ from each other. Unloaded source codes configurations with the new search behavior and with the old one and compared the source codes of the forms.

The addition of a form element with the "Search string" type is responsible for the functionality of the new full-text search. It became clear what to look for. Found an article on ITS 7.3.1.5. Search in a dynamic list. Examining this article led me to the conclusion that the new way search works depends on two factors: 1. The form must have the above form element completion, 2. dynamic list on the form must have the "SearchStringPosition" property not equal to "None".

In theory, when creating a form on the server, it is enough to set the "SearchString Position" list property to "SearchString Position. No", but this did not work with all forms, in some cases the new search continued to work. We cannot programmatically delete non-programmatically created form elements, but visibility can be controlled. If the form element "AdditionSearchString" is removed from visibility, the full-text new search also stops working. During the experiments, the following code was born, which I placed in the general module:

Procedure Disabling NewSearchInLists(Form) Export List = Form.Items.Find("List"); If List = Undefined Then Return; EndIf; List.SearchStringPosition = SearchStringPosition.None; AdditionSearchString = Form.Elements.Find("AdditionSearchString"); If NOT ComplementSearchString = Undefined Then ComplementSearchString.Visibility = False; EndIf; EndProcedure

In the procedure "Disabling New Search in Lists" you need to pass the corrected form. But how can this be done for all forms at once?

The first solution is to manually fix the necessary forms in the configurator using the form editor. I immediately refused this decision - it is long and dreary, and it is difficult to update the configuration later.

The second solution is to call a procedure when opening the form, which will programmatically disable the new search. The procedure can be called from any other procedure, the launch of which is already registered in all forms, in this case, with further updates, we will only need to monitor this procedure - so that it does not change. I chose the GeneralModule.ManagePrint, which has:

OnCreateOnServer(Form,DefaultCommandPlace,PrintObjects) Export

This procedure is called when a form is created on the server to fill in print commands. In this procedure, we write the code that calls our function to disable new search in lists:

MyGeneralModule.Disabling NewSearchInLists(Form);

Accountants are enjoying the old search, and we're gearing up for when Enterprise Accounting 3.0's compatibility mode will allow us to port this functionality to an extension.