Web Designer: Interacting with Grid filters

Question

Hello, 
 Can anyone provide insights on how to handle the new Grid / Grid Band components correctly? 
 Specifically, I'd like to: 
 
 Have Filters on columns containing additional properties (defined in WebDesigner) within "Database (automatic load)" data source GridBands. It seems this is only possible with "Collection" source GridBands (?). 
 Access which rows are currently visible after applying a filter ("Collection" bands). I.e. accessing the contents of the Grid as opposed to the contents of the collection (the primary goal is to provide a "select all/none" control - filters are breaking my attempts). 
 Access the properties of the built-in search field (contents, update events) of a grid. 
 
 I believe 1. is not possible at all, but 2. and 3. might be doable using Code Literals. Or maybe I am missing something and it's much easier?

Hanno Bunjes · Accepted Answer

Hi, 
 
1. Correct, this is not possible. The reason is that you would need to load the entire table from database in order to then calculate the additional property for each row. And this will never scale well. 
 
2. You may be able to use the built-in multi-select checkbox. Otherwise, take a look at the IsInIteration function which returns which rows are currently being displayed in a grid. 
 
3. You may be able to locate the search text box via javascript. Whether or not that's useful depends on what you want to do with the properties. 
 
Hope this helps 
 
Hanno

Hanno Bunjes · Answer

Not really. The IsInIteration function specifically exists to obtain the rows that are visible to the user.

Endpoint Privilege Management

Web Designer: Interacting with Grid filters