Applies to 8.3.x; Author: Łukasz Preiss
WEBCON BPS version 8.3 introduces a series of improvements to how SQL Grid form fields operate. Data will now be loaded asynchronously, which means that form load times should not be delayed by slow-responding data sources. Furthermore, data which is a burden to load but is not needed in every instance will greatly benefit from the new option: “load on demand”.
After migrating to version 8.3, every SQL Grid form field will operate in asynchronous mode (no additional configuration required). But how exactly does an asynchronous form field work? When a form is loading, if a data source happens to return large volumes of data, or is being particularly slow to respond, the rest of the page will load normally regardless. The slow-loading SQL Grid field will show a progress bar, and once it finishes loading the data will be displayed like normal.
Similarly, paging results on an SQL Grid in 8.3 is restricted to the form field, and does not require the entire form to be reloaded. For data sources the return up to 100 elements, the paging is done “browser-side”. This means that all data is loaded once (when the form is first loaded) and is then divided into pages accordingly. Data sources that return over 100 records, will cause each page (of the SQL Grid) to be loaded separately, referencing and loading information from the data source as needed. Since the SQL Grid is loaded in isolation in both cases, reloading the entire form won’t be necessary.
Load on demand
Another option introduced in version 8.3 is the so called “Load on demand” setting. The form field may be configured in a way to not show any data at all by default. This data will instead be loaded after clicking “Refresh to load data”. This option may come in handy if downloading data happens to be somewhat troublesome, but not entirely necessary at the given moment.