grid reference: SQLFORM.grid()

5281 views
0 comments
loading...

SQLFORM.gird gives you the ability to browse, search, sort, create, update and delete records from a single object It is based on SQLFORM and it has a lot of similarities with it.

In order to use more than 1 grid on one page, you will need to use formname

@auth.requires_login() 

def manage_users(): 

    grid = SQLFORM.grid(db.auth_user) 

    return locals()

Attributes / Arguments

fields

Specify which fields are fetched from the database

auth.requires_login() 
def manage_users(): 
    grid = SQLFORM.grid(db.auth_user, fields=[db.auth_user.id,auth_user.name]) 
    return locals()

query

Retrieves record based on search query.

  grid = SQLFORM.grid(db.auth_user.disabled==True, user_signature=False)

None

field_id field_id=None,

field_id must be the field of the table to be used as ID, for example db.mytable.id.

This is useful when the grid query is a join of several tables. Any action button on the grid (add record, view, edit, delete) will work over db.mytable.

@auth.requires_login() 
def manage_users(): 
    grid = SQLFORM.grid(db.auth_user, fields=[db.auth_user.id,auth_user.name]) 
    return locals()

Examples

How to obtain and save IP address in the database

Snippet
10682

plugin_manage_groups

Manage groups and group membership of the users.

Plugin
5481

URL rewrite with pattern based system used by web2pyref

Simplified example of routes.py used by web2pyref

Snippet
10697

Create custom URLs

Snippet
13348

Bootstrap carousel for your web2py application

Create simple carousel for your pages for you app

Snippet
14675

Contact form with reCaptcha and gmail SMTP service

Add contact form to your app

App
18282

Enable record delete option using SQLFORM()

Snippet
7688

Append the same fields to all the tables

Common fields shared by different tables

Snippet
6135

Calculate the size of uploaded file using compute and lambda function

Snippet
8217

How to use URL redirect

Snippet
17451

LDAP auth configuration using login_methods

How to configure LDAP auth with login_methods

Snippet
7284

Add placeholder text to a web2py form

Snippet
8283

grid SQLFORM.grid()