As for 1.99.2, grid is stable. Using fields = [db.table.field, db.table.otherfield] does not work on the index table. I am using columns and planning to update my controllers when the next release becomes available.
On Nov 14, 12:13 pm, Jim Steil <[email protected]> wrote: > Ok, columns are gone again... > > Might just be best to stick with using fields. > > -Jim > > On 11/14/2011 8:47 AM, Jim Steil wrote: > > > > > > > > > I stand corrected on the 'columns' comment. Massimo added it back in > > this morning. > > > -Jim > > > On 11/14/2011 8:45 AM, Jim Steil wrote: > >> here are a few thoughts... > > >> 1. Make sure you create this test in a new app. If you're updating > >> or adding functionality to an already existing app, then your layout > >> and base.css need to be updated. > >> 2. If using jquery-ui, then you need to download jquery-ui and > >> include it in your layout.html with a line like this: > > >> {{response.files.append(URL('static','jquery-ui/js/jquery-ui-1.8.16.custom. > >> min.js'))}} > > >> {{response.files.append(URL('static','jquery-ui/css/sunny/jquery-ui-1.8.16. > >> custom.css'))}} > > >> 3. Don't use the 'columns' argument. It is going away in the next > >> release. Instead, use 'fields'. In your case, use the following: > > >> fields = [db.projects_posts.title, db.projects_posts.project_details, > >> db.projects_posts.estimated_worth] > > >> 4. I typically do not specify the 'headers' arg. Instead, set the > >> 'label' on your table definition. That way you only have to do it > >> once and can use it all over. If you need to override it for a > >> particular function, then just set the 'label' attribute in that > >> function. > > >> 5. At this time there is no documentation available for SQLFORM.grid > >> or SQLFORM.smartgrid. The best thing to do would be to look through > >> this group for all the posts. Massimo is working on an updated > >> version of that manual that he is hoping to have complete by the end > >> of this month. That should contain information on .grid and .smartgrid. > > >> 6. If you are going to be playing around with this I would recommend > >> that you work with the code in trunk. I don't recall what state the > >> .grid was in when 1.99.2 was released. > > >> As for answers for your specific questions: > > >> Q: What is the exact proper method to use SQLForm.grid - > >> I think your on the right track. Just need to clean up your css and > >> layout.html files to get the proper formatting. > > >> Q: What all libraries do I need to include? where? > >> If you want to use jquery-ui then you need to download it and > >> reference it in your layout.html. > > >> Q: How to make links work the way they should ? > >> I'd like some more information on what is going on here before giving > >> an answer. > > >> Q: Can search be customized? How? > >> I don't remember if the search_form is implemented in 1.99.2, but > >> there is a search facility built in that allows the users to create a > >> custom search. I am not a fan of it and have some other ideas how > >> developers could be allowed to create custom search forms, but I > >> haven't opened a ticket on it yet. > > >> Q: Is this documented in online book? - did not find much about it in > >> version 3.2 though. > > >> Documentation will be coming with the next version of the book > >> targeted for the end of the month. > > >> Hope this helps. > > >> -Jim > > >> On 11/14/2011 6:54 AM, Rahul wrote: > >>> Hi All, > >>> Can anyone let me know how to use SQLForm.grid properly or tell > >>> me what I am missing. I have not installed any jquery plugin for the > >>> same (assuming that it is part of 1.99.2 by default). I cannot see the > >>> complete grid, just some buttons and data as per my query below. Also > >>> the links do not function when clicked. The table does not show any > >>> backgroud color or anything. Simply it doesnt look like a jquery > >>> grid. My code is as below - > > >>> My machine - Windows7 , IE9 and Firefox 7.0, Chrome. > >>> Web2py- Latest stable (1.99.1) > > >>> #---------Controller- (default.py)--- > >>> def index(): > >>> """ > >>> example action using the internationalization operator T and flash > >>> rendered by views/default/index.html or views/generic.html > >>> """ > >>> #Posts grid - SQLForm.grid > >>> #grid = SQLFORM.grid(db.projects_posts) > >>> query = ((db.projects_posts.post_visibility=="Classified")) > >>> columns = ('projects_posts.title', > >>> 'projects_posts.project_details', > >>> 'projects_posts.estimated_worth' > >>> ) > >>> headers ={'projects_posts.title': 'Title', > >>> 'projects_posts.project_details': 'Details', > >>> 'projects_posts.estimated_worth': 'Worth'} > > >>> form = SQLFORM.grid( query=query, columns=columns, > >>> headers=headers, > >>> deletable=False, editable=False, csv=False, > >>> maxtextlength=64 ) > > >>> return dict(form=form) > > >>> #--------- View --- (index.html) > >>> {{extend 'layout.html'}} > >>> {{=form}} > > >>> Also, if possible please refer me to the proper documentation for > >>> SQLForm.grid. Again, if I include the parameter form = > >>> SQLForm.grid(....., ui="jquery-ui") in above code, the buttons > >>> disappear and it only shows me links for 'view' etc. > > >>> Q: What is the exact proper method to use SQLForm.grid - > >>> Q: What all libraries do I need to include? where? > >>> Q: How to make links work the way they should ? > >>> Q: Can search be customized? How? > >>> Q: Is this documented in online book? - did not find much about it in > >>> version 3.2 though. > > >>> Please advice or refer me to the proper thread(though I checked > >>> several to find solutions). > > >>> Regards, Rahul
