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 Simon |
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, 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
|
Hi Simon,
Is the datasource in question set to work with infiite scroll in query as needed mode?
Kind Regards, Yalim
Its fetch mode is currently set to Fetch All not infinite scroll
Simon