• State Verified Answer
  • +1 person also asked this people also asked this
  • Locked Locked
  • Replies 7 replies
  • Answers 1 answer
  • Subscribers 96 subscribers
  • Views 7978 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Web Designer: Interacting with Grid filters

Christian Stevens
over 6 years ago

Hello,

Can anyone provide insights on how to handle the new Grid / Grid Band components correctly?

Specifically, I'd like to:

  1. 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 (?).
  2. 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).
  3. 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?

Parents
  • +1 over 6 years ago
    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
Reply
  • +1 over 6 years ago
    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
Children
No Data