Azure Fulltext Search
Introduction
The Azure Fulltext Search supports the user in quickly finding items in sales and purchase. Searched tables are:
- Items
- Catalog Items
- Crossreferences (Customer/Vendor)
- Manufacturer Items
Therefore an Azure Search Service is necessary.
Setup
Search for Azure Search Setup.
- Assign a unique, customer-specific ID in Azure Index Customer ID.
- In the field Azure Search Url enter the URL of the Azure Search Service + /Index. It should be structured like https://<searchname>.search.windows.net/indexes.
- API version is currently supported up to 2020-06-30.
- API admin keys and API query keys can also be found in Azure.
- Now select the function Check Connection.
If you have configured everything correctly, the fields API Admin Key Connection tested and API Query Key Connection tested should be set.
Caution
If one of the above fields is changed, the fields API Admin Key Connection tested and API Query Key Connection tested are reset and no more queries can be made. The function Check Connection must be called again.
Finally, you should perform an initialization. To do this, select Initialize Azure Search. A confirm appears asking whether the data should be synchronized directly.
- If "Yes" was clicked, all data from the tables mentioned above will be transmitted initially once in the current session synchronously to the Azure Search Service (with progress dialog).
- If "No" was clicked, all data to be transmit is written to a table and can be processed manually once only afterwards or automatically permanently.
Transmission the data
If you selected "No" when initializing the search, you can open the Azure Search Synch. List page. Here you will always find all entries that have changed since the last synchronization and have not yet been transmitted. You can have these data processed manually or automatically.
- Manual Transmission: It can be started via Start synchronization.
- Automatic Transmission: For automatic transmission, set up a new job queue entry with codeunit 5374936. This ensures that all changes are transmitted at fixed intervals.
The transmission of data can be configured in such a way that a maximum number of entries is transmitted for each request. For this purpose the field Max. Records per Sync can be set on the Azure Search Setup page.
Note
A larger number means fewer requests and therefore an improved performance. However, if the query is aborted, this also means that a large amount of data will not be up to date until resynchronization. A smaller number means that even if the query is aborted, a lot of data is still current, but more requests must be sent. This value should only be adjusted if there are really problems in performance. The maximum value is 1000.
Use of the search
The search can be used up in both sales and purchasing documents. To do this, you must first display the Full Text Search field in the lines of the documents. The search performs a substring search as soon as you enter something in the Full Text Search field. Then the Azure Search Results page opens. On this page, you can restart the search using the action Start search or by entering something in the Searchbox field again. Additionally, the page offers the possibility to filter the displayed results.
Tip
Several search terms are separated by a space. Wildcards do not need to be specified. You can deactivate that item numbers are not considered in the search. To do this, you can activate the field Ignore Item No. in the Azure Search Setup.
Note
The Azure Lucene search syntax is currently not available.
Usually, only the item that was selected when the page was closed is taken from the results to the line. If you have selected more than one row (Ctrl + Click), all selected items are taken. Additionally, all items for which a quantity has been set or a substitute item has been selected are taken.
Important
Possible dialogs or windows that would open are suppressed.
Note
If a catalog item is selected that is not yet linked to an item (empty item no.), the item is automatically created and assigned to the document row.
If a search query would return more than 100 results, the search only returns the first 100 when called. If that happens, the user gets a notification with which they can fetch all results of the chosen query.