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
