How to expand the number of strings used for search from the database (static field option) in Flexilayout.
The search is done by the function of the FlexiLayout language called SearchTextFromDB. It is possible to observe this function if you switch to the Advanced tab of your Static text element and hit the button Code, which shows the representation of the settings made in the Static Text tab.
To speed up the search, only the first 1000 strings are used by default, please see the SearchTextFromDB description in the article:
To use more strings, specify the required number in the SearchTextFromFile command in the Advanced tab → Advanced pre-search relations.
SearchTextFromDB: "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\\FCS\\DBKeywords.mdb", "SELECT Words FROM WordsTable", 500;