Login Register

New Widget: FilteringTable

I've just finished some final touches on FilteringTable, SortableTable's big (I mean BIG) brother...complete with multiple column sorting, much cleaner data access, the ability to filter, sorting in place, data binding to a simple JSON-based data store... There's a lot there, so for now I'll point you to the tests in the nightlies. Current feature list:
  • Multiple Column Sorting (number of columns settable, default is 1
  • Sorting in place (non-destructive)
  • Per-column programmatic filtering
  • Add and remove rows on the fly
  • Update field values (with typing) on the fly
  • No restrictions on sorting on markup
...I'm sure I'm forgetting something. Behind all of this is a simple DataStore object, which the FilteringTable is bound to; all of your updates are made to the store, and the FilteringTable will update automatically. This data store is based on an array of JSON objects, and each object in this array can be complex--and you can use the results of methods to display data in the FilteringTable! This widget was designed to replace SortableTable; if you are working off nightly builds, I suggest you try this out, and give it a spin, and see how you like it.

[...] Además, por lo que

[...] Además, por lo que nos comenta su autor, la cantidad de datos que puede manegar es bastante grande. [...]

Any chance locked columns or

Any chance locked columns or rows (Freeze Panes) will be included as part of this widget?

Can i have the url where i

Can i have the url where i can download this source

"Update field values (with

"Update field values (with typing) on the fly " Does that mean inline editing of the cell values? That would be awesome

1. No, FilteringTable does

1. No, FilteringTable does not alter the presentational aspects of a table at all, so no freeze pane or column locking. 2. You can download this source with the rest of the anonymous head from http://archive.dojotoolkit.org/nightly/ 3. I did not enable inline editing of cells; all I did was enable the updating of cells based on the data binding mechanisms of the SimpleStore. However, that doesn't mean that inline editing can't be attached or done.

Filtering table

If possible can u send me full example of filtering table.
i want a table with sorting and resizeble column.
so please send me this example if possible

Wow! This is VERY nicely

Wow! This is VERY nicely done! Is there a plan for a paging mechanism for cases when there are too many records? Reg

I put checkbox in

I put checkbox in FilteringTable and it got reset on sort

also You defined rowClass

also You defined rowClass and do not use it how about if(this.alternateRows){ + dojo.html[((i % 2 == 0)?"addClass":"removeClass")](row, this.rowClass); dojo.html[((i % 2 == 1)?"addClass":"removeClass")](row, this.rowAlternateClass); } hmm wher can I put comments about this

Can someone from dojo

Can someone from dojo explain the relationship between sortable table, filterable table and dojo's grid (http://dojo.jot.com/WikiHome/GridWidget)? As I understand it: sortable table will be replaced by filterable table. Tables are esentially lightweight view components for the new simple data store framework. The grid widget has not started coding yet but is designed to be a far more complx widget with the list of features found on the jot page I linked to. Am I on the right/wrong track? Also, do you anticipate that simple store will be extended into things like pagingStore so that you can build paging and infinite scrolling UI tables on top of it?

I posted a widget called the

I posted a widget called the ReportGrid a few months ago on Trac(http://trac.dojotoolkit.org/ticket/570). It has paging included as well as filtering. I have been using the widget in production for a few months and ironed out the bugs. Tom if you are interested I can email the source. It has been very useful for reporting and can handle thousands of rows.

Andy, You have it right.

Andy, You have it right. Sortable was added to Dojo because people were screaming for some version of a grid; Filtering was built to fix all the issues with Sortable, plus to add a few new features and to start with some sort of example for a data API; the Grid widget is a contribution from IBM, and it is going to try to be the full-featured item that everyone seems to want--but it's nowhere near ready for production. Sortable *will* be replaced by Filtering, yes. In fact, I need to add the deprecation message (I'll do that today). Tables *should* be lightweight view components but until Filtering there was no design in place for it. I do actually anticipate that Filtering (not simple store) will implement an optional paging at some point; it may end up being another widget though, I'm not sure yet. Preliminary testing shows that SimpleStore has no problem handling thousands of complex data points (i.e. complex JSON objects or even a regular JS object structure), so the goal would be for the widget--not the data source--to implement the paging feature. It would also be completely client-side, so don't expect an implementation for server interaction (we are in the process of designing the dojo.data API which will be designed for that sort of thing). Tim--you posted that code without leaving your email, name or any other information in the ticket, including whether or not you filed a CLA with the Dojo Foundation. Without knowing if there's a CLA, I can't even start looking at your code. If you're willing to file a CLA (see the About page), then repost your code there and reopen the ticket, putting your email in the CC field and a little bit more info about you. Thanks.

I am desperately waiting for

I am desperately waiting for the GRID. When is it expected to come out. Tables solve no purpose for big datasets. Thanks Regards

How to use the results of

How to use the results of methods to display data in the FilteringTable ?

Hi. now, i have to hide an

Hi. now, i have to hide an id column, but the style cannot do it. how to i can hide a column in sortable table? Thanks. Carlos

What is the link to the GRID

What is the link to the GRID donated from IBM

Hi Friends, After extensive

Hi Friends, After extensive search i found this dhtml grid and it has all the features you would expect from a top class grid. I swear i found not a single grid which can match it. HAVE A LOOK AND YOU WILL BE DELIGHTED. http://www.scbr.com/docs/products/dhtmlxGrid/index.shtml PLS POST YOUR RESPONSE WHETHER U LIKE IT OR NOT. Regards Arun

Hi Arun, DHTML grid looks

Hi Arun, DHTML grid looks fabulous. All i would like to know if it is freeware. Because I did not come across any licenses related information on the given link. Thanks for sharing your research Arun. Thanks, Sandeep

In order to use that DHTML

In order to use that DHTML grid in a commercial application you must pay a license fee. It is clearly stated there on the main page under the 'Licensing' heading if you scroll down. Here's a cut/paste of it. Licensing # Open Source - GPL # Commercial License: in order to get support or to use any edition of dhtmlxGrid in a commercial project you can purchase a Commercial License ($149). Please, contact us to buy. =Perry

I got tired of waiting for a

I got tired of waiting for a dojo grid and switched from dojo to http://demo.qooxdoo.org/html/at-a-glance/index.html 3 weeks ago - check out the table demo for the grid. I mainly wanted inline editing of cells - qooxdoo provided this. There were also enough clear examples that I was able to setup something similar to the rico livegrid - where the table grabs new data as the user scrolls. It seems almost every business application has a need for something like this... Curious if others have found anything better that is opensource... Best regards, Alan

I'm using FilteringTable

I'm using FilteringTable from nightly builds. It says me, that: DEBUG: EXPERIMENTAL: dojo.i18n.common -- Not yet ready for use. APIs subject to change without notice. DEBUG: EXPERIMENTAL: dojo.requireLocalization DEBUG: EXPERIMENTAL: dojo.requireLocalization DEBUG: dojo.widget.Parse: error: [TypeError: this.store.getFromHtml is not a function, file: http://ochkarik.xpd.ru/js/src/widget/FilteringTable.js, line: 338] And, when i click on any of th elements, i get "Error: dojo.doc is not a function". I'm using FilteringTable because it doesn't block checkboxes to switch. Is there any way to avoid this or to fix FilteringTable errors? :( Excuse me my poor english :)

I think GRID is the widget

I think GRID is the widget which dojo has to focus to develop on top priority. Any serious application development badly needs a good grid with capabilities somewhat of DHTML GRID. I think dojo has enough widgets which are useful in any form EXCEPT GRID. So GRID DEVELOPMENT should be focused on with top priority leaving others aside for a while. I hope my friends in this blog also agree to it. Please voice your thought on this topic. Thanks Regards Arun

I had heard that IBM is

I had heard that IBM is donating a grid. Is it true?

DHTML GRID is GPL Licensed

DHTML GRID is GPL Licensed

Great stuff, but how do i

Great stuff, but how do i install this into the standard packages like (kitchen sink, io, ajax), if i use the nightly packs, than some errors are in other widgets..(check box, buttons dont render why ?) , i've copied every .js that the filtering table needs (on errors) but still not works..how to run it in a classic downloadable packages ? Thanks o lot Mike

Greetings All, how to

Greetings All, how to specify main sorting function for a string type, because non English Languages ... chars like ěšÄ?řžýáíé are on the end (i use all in UTF-8)

Hi TOM, nice work, can you

Hi TOM, nice work, can you update the filtering table to use in compare with strings with "localeCompare" function on browsers who support (FF,IE5,IE6 ?) i dont know where to update in sources .. any ideas somebody ?

Hi, as posted by Carlos on

Hi, as posted by Carlos on Sept. 22: "i have to hide an id column, but the style cannot do it. how to i can hide a column in sortable table?" I have the same problem, is there a solution? Thanks Andrea

instead of hiding an id

instead of hiding an id column set an attribute called value on the tr tag like this if you are just attaching to html. If you are using javascript data objects simply include a field named Id like this: var oRow = { Id: "my_unique_id", name: "Bob Smith", title: "COO" };

Is there anyway to enable

Is there anyway to enable copy so the user can pull data off a filter table? Baring that is there another widget gives you sortable tables that allow copy?

I'm using the latest nightly

I'm using the latest nightly source. I've noticed that sorting for dataType="html" includes the html elements and their attributes. This mean that a link will sort on the href...not good. I would think dataType="html" would sort ONLY on the text nodes inside of the TD. Minimally this should be an option you can declare in the thead somewhere. As a work around to get my sort order to come out correctly I added TEXT I WANT TO SORT BY to the beginning of the td content. P.S. The control is very nice...thanks for the effort.

Hi, I have value attribe

Hi, I have value attribe inside the , how should i update the value attribute.

Hi, I have a value

Hi, I have a value attribute inside the tr tag, how should i update the value attribute.

Hi, I put some codes (e.g

Hi, I put some codes (e.g onmouseover) inside . After parse, the codes disappeared. Are they removed intensionally or I don't know how to use filteringtable properly? Please help

Hi, I put some codes (e.g

Hi, I put some codes (e.g onmouseover) inside TR tag. After parse, the codes disappeared. Are they removed intensionally or I don’t know how to use filteringtable properly? Please help

Likewise, I put custom CSS

Likewise, I put custom CSS classes in each TD (first, middle, last) and these classes are wiped out when they get to the storage provider. How can I retain these classes? It seems I need to add a class/style field to the JSON data and then parse that out when displaying the HTML ?? thanks.

how can i add tr's onclick

how can i add tr's onclick dynamic,i don't see method ,how can i do ,thanks

You could do something like

You could do something like that for a filteringTable :

function init() {
    var filteringtable = dojo.widget.byId("id_yourfilteringtable");			
    var tbodie  = filteringtable .domNode.tBodies[0];
	
    // The onclick event on the tbodie		
    dojo.event.connect(tbodie, "onclick", "insideTBodie"); 
}

   function insideTBodie(evt) {						
	var tr = dojo.html.getParentByType(evt.target, "tr");
	if (tr)  {
                     var data = dojo.widget.byId("parsedFromHtml").getDataByRow(tr);
                     // Here, you can use the data coming from your clicked row
	    dojo.log.debug(data.Id + " " + data.Name);
                }	  

dojo.addOnLoad(init);

inline Editing

I really like filtering table and I used it almost everywhere in my web application. I am trying to add inline editing box to filtering table but failed. could you please let me know if there's a way to enable inline edit for filtering table. also, I add "maxSelect=1" to the filtering table to disable multiple selection, but it does not work. should I use some other function to disable multiple selection? Thanks a lot

filteringTable support for currency format

hi i would like to display amount in comma seperated format
e.g. 110229823.001 - 11,02,29,823.001
Is there any dataType supported in filteringTable which would server the purpose !!

Many Thanks,
Sandeep

This isnt an avenue for support...

Follow the support links in the left hand menu if you need help.

-Karl

column width resize with table filter widget

Hi

i am implemented dojo widget filter in my table and my table is working perfectly with filter and shorting.but i am not getting how can i resize
column width for my table. i saw in dojox.grid, in that grid resize is there but if i implement in my table it is not working.please somebody help me
in this topic and give me some idea,otherwise anybody have example please send me .my mail id (hai_bisu@rediff.com).

Advance thank you.

regards
Biswanath

where to download from

I downloaded the dojo release 1.2.2 and would like to use the Filtering Table, but it doesn't seem to exist within the download (I'm using dojo.require("dojo.widger.FilteringTable') and get a widget is unidentified error.

I've tried going to the link at the top which takes me here http://archive.dojotoolkit.org/nightly/tests/widget/test_FilteringTable....
to a 404 Object not found! error

it looks like the

it looks like the FilteringTable is depreciated?
http://dojotoolkit.org/book/dojo-porting-guide-0-4-x-0-9/widgets/filteri...