OK, so I have a question about about datasources and clearing a grid filter.

Say I have a grid based on a table with 10 rows in it with a key column with values going from 1-10.

The user deletes row 8 but doesn't save the changes, he then applies a filter to the block to restrict only those rows 1-5... he then clears the filter and the rows come back... including row 8 that he deleted previously, is there any way to make it so that when the user clears the filter it doesn't requery the database but just returns the all the rows in the unsaved datasource? ie 1,2,3,4,5,6,7,9,10


asked 04 Feb '16, 10:46

apacheuk's gravatar image

accept rate: 0%

Hi Simon,

Is the datasource in question set to work with infiite scroll in query as needed mode?

Kind Regards, Yalim

(04 Feb '16, 10:57) Yalim ♦♦

Its fetch mode is currently set to Fetch All not infinite scroll


(04 Feb '16, 11:00) apacheuk

Hi Simon,

The Grid built-in filters always re-query the database.

You can however build your own filters using the applyfilter API. They work the way you described.

The only exception is datasources with infinite scroll in query as needed mode. They always requery. (I think if the mode is query all, applyfilter works the way you expect it to work but I am not 1005 sure, have to doblecheck.)

Kind Regards,


answered 04 Feb '16, 11:11

Yalim's gravatar image

Yalim ♦♦
accept rate: 20%

edited 04 Feb '16, 11:14

OK, another question then.... users really like the functionality of the Grid (built in query method) is it possible to utilise the drop down menus in the same way??

(04 Feb '16, 12:09) apacheuk
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 04 Feb '16, 10:46

Seen: 1,589 times

Last updated: 04 Feb '16, 12:09

© Copyright Gerger 2017