I realized in a paging grid and table it only filters the page it is showing and not query a new result using the filter,
just wondering is there a model of that set up or do that or not.
if not most likely have to make a new textbox that when inputted will query the store for a new type of filter or something. but not sure will that affect the sort orders too. DevBlog: Dont FILTER Data in a Grid::
Look at this form, that uses a filter. The underlying table has over 200,000 rows. VFP Home Page. Visual Studio Home Page. C# Home Page. VB Home Page. Archives
http://www.craigberntson.com/blog/2008/08/dont-filter-data-in-grid.aspHOME |
Ajax Grid, Components & UI Builder - Integration With PHP, Java, ASP.NET::
Sigma Grid 2.1 released. Client paging, more attributes and events. Power filters make it easy to search any data. Sigma Visual - AJAX UI visual builder
http://www.sigmawidgets.com/HOME |
And how did that solve the problem of server-side filtering?
As I see it, if you have a large number of entries (thousands), you don't want to push them all into the client, so you display things with paging. But when you filter, you do want to filter the whole data set, not only the page being displayed. So you either filter on the server, or you push the whole thing on the client and filter there. But for a large number of entries, this is not practical. Besides, I read in an older post that server-side filtering will be available in 1.1, and now that 1.1 is out, I cannot seem to find it. Any ides on this? Thanks.
@TheBuzzer: I understand that it works, but it's not very extensible because you have to declare all your parameters in your service function.
@Me:
I've found a way to implement it as a plugin more easily:
1- Using HeaderContextMenu event of the Grid it's possible to add MenuItems on the headers' menu.
2 - Using BeforeLoad Event on ListStore or Loader I can't add the parameters in the LoadConfig.
well the textbox for fitlering i submit it as more data where on server side i use that string as part of mysql string to do the filters.
here is my getorders class header
public GetOrders(PagingLoadConfig config, Integer ordertype, String username, String filtertext, Date filterstartdate, Date filterenddate){
when i make a sql query
mytable.makeTable("SELECT * FROM `orders` WHERE " + wherefield + employeeid + filterstring + filterstartdatetext + filterenddatetext);
Oh ya I coded my own sql wrapper to get results quite easily by putting them into a vector of treemaps
well do whatever works for u.
I was just giving a example on how i got server side filtering to work
That would essentially be a server side filter. I need this as well. Any ideas out there? Thanks.
To implement more easily this functionality the GXT API should be improved.
Let's explain the main difficulties:
1 - Extend the menu to add the filter item:
You can't extend the menu from a plugin (ComponentPlugin) because menu in GridView is a private member and GridView doesn't provide a getter from it.
Workaround: extend GridView and override createContextMenu, and set the GridView in the Grid after constuction.
2 - Passing the filters as parameters with the rest of the LoadConfig (SortInfo, offset, etc.)
There's no easy way to access the lastConfig associated with the Loader' Store.
WorkAround A: retrieve lastConfig via JSNI (tricky but works)
WorkAround B: subclass BasePagingLoader for instance and store the last config there.
Do anyone has another ideas?
well I just did some extra textfields to input filters along with the sort and stuff.
 Red Hat's Rough Recovery From CFO Exit
 Windows Live Finds a New, Pre-installed Home
|
Paging Grid / Table with filter?