Sort multiple tables

[pbt]

I am new to web2py .Thanks in advance. Please help me doing this. I have multiple tables with one record in each table as shown in the screenshot.I want to sort the tables using different parameters of the table. I want to keep a drop-down to sort records according to rent,size,location,etc...

[isi_jca]

Hi!!!

Look at in attached file, maybe you can get some idea.

Regards.

[pbreit]

We might need to see some of your code, specifically your models.

Why do you have multiple tables?

I could see you having one table called "property" such as:

db.define_table('property',
  Field('location'),
  Field('size'),
  Field('rent'))

And then in your controller:

def search():
  if request.vars.orderby == 'size':
    orderby = db.property.size
  elif request.vars.orderby == 'rent':
    orderby = db.property.rent
  else:
    orderby = db.property.location
  properties = db(db.property.id>0).select(orderby=orderby)
  return dict(properties=properties)

Then a URL:

http://mysite.com/search?orderby=rent

[pbt]

@pbreit
In models,I have only 1 table.By multiple tables,I mean multiple tables in view.I found a jquery plugin for sorting data in a single table.That is why I wrote multiple tables so that no one will suggest jquery plugin for that.

[pbt]

@pbreit

I tried your code,it did not work.It works for sorting by location. 

In models

db.define_table('listspace',
  Field('warehouse_location','string'),
  Field('warehouse_totalsize','string'),
  Field('contract_rent','string'))

In controller

def GetAllApprovedWarehouses():
    print request.vars.sort
    if request.vars.sort == 'size':
        order = db.listspace.warehouse_totalsize
    elif request.vars.sort == 'rent':
        order = db.listspace.contract_rent
    else:
        order = db.listspace.warehouse_location
    listSpaceRequests = db().select(db.listspace.ALL,orderby=order)
    return dict(listSpaceRequests=listSpaceRequests)

[pbt]

@pbreit

I found the mistake. I wrote string instead of integer for rent and size. Thank you for helping.