Good point. I guess it depends on how many features are needed. My own experience is that using the DOM parser to modify grid parts like the buttons gets it pretty far along -- obviously, a lot would be missing, but there is so much useful stuff even with a very basic version of the grid (i.e., search bar not included).
On Tuesday, September 22, 2015 at 3:22:00 PM UTC-4, Anthony wrote: > > 1. Create a Table object with appropriate fields and set migrate=False >> (This creates a dummy table) >> 2. Convert row values into a list of tuples >> 3. Use db._adapter.parse to create a DAL Rows object using the dummy >> table: >> >> t_rows = db._adapter.parse(rows, fields=[f for f in db.dummy_table], >> colnames=db.dummy_table.fields) >> >> >> 4. Create a SQLFORM.grid in controller and then replace the rows with >> your rows object using the DOM parser. >> >> grid = SQLFORM.grid(db.dummy_table) >> table = grid.element('.web2py_table') >> table[0] = t_rows >> >> > I'm not sure this will be a fruitful approach. The code above won't quite > work as is, as table[0] is supposed to be a TABLE html helper object, with > a very specific structure and format, but the above code attempts to > replace it with a DAL Rows object (which will ultimately get rendered as a > SQLTABLE, which is not quite the same as the grid HTML table). This > approach will also break pagination, searching, sorting, and downloading. > So, without the standard grid HTML table or any of the other grid features, > you really get very little out of using the grid in this way. > > Instead, you could do steps 1-3 above, and then replace step 4 with: > > grid = SQLTABLE(t_rows) > > However, it would probably be easier to just write some code to directly > build an HTML table from the original JSON data rather than bothering with > steps 1-3. This would also allow for more flexibility in specifying the > HTML structure of the table. > > Even better, just use an existing data grid solution, such as Datatables > <http://datatables.net/>, which can consume JSON data directly. > > Anthony > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.