Saturday, July 25, 2020

Removing List as Entry Point feature for Newer Versions

Hi Everyone,

If your clients are not really fond of this "new feature", especially when you open a data entry screen menu item and all of a sudden user is getting 100,500 records into your screen, with all server burden overload attached. We have an option now.

There is a way to switch it off. 

Via user interface it has to be done One by One for all the data entry screens, as shown here:



Note the screen name, open it, then click CUSTOMIZATION -> EDIT GENERIC INQUIRY:


And once opened here is the option you need to amend:


There are two ways of doing it - complete removal of the entry list, then un-tick the option, save, done. OR you can leave entry list there but restrict the initial load to 50 records only. then amend Select Top to 50.

This will guarantee no strain to your server any more.

Now, for those who read it up to here, a bonus, here is a script that will do all this for all screens at once, it works for all implementations, as long as you have not modified the GI manually:

update GIDesign set selecttop = 50 where companyid = 1 and PrimaryScreenIDNew is not null



All the best,

Sergey.