Two questions re SQLFORM.grid sorting.
1. Is it possible to specify the initial sort order?
2. I'm displaying a table that includes a foreign field. When I click on
the header to sort by that field, it sorts by the field id rather than by
the (displayed) foreign field. Can I sort by the displaye
If one clicks on 'data modified' in a windows folder, the files are
ordered with the most recent first.
In SQLFORM.grid if one has a column with a date in it, and one clicks
on the heading, they are sorted with the oldest first.
See www.ukjazz.net/store/albums
It would be nice if SQLFORM.grid ac
You can specify the sort order using the orderby parameter. But, I
don't know how you get it to sort by the displayed value of a foreign
key column.
Ex:
orderby = [~db.asset.acquiredOn, db.asset.assetTag, db.asset.description]
~ orders descending.
-Jim
On 5/21/2012 2:23 PM, Keith Edmun
foreign key. You can do a join.
On Monday, 21 May 2012 14:49:06 UTC-5, Jim S wrote:
>
> You can specify the sort order using the orderby parameter. But, I
> don't know how you get it to sort by the displayed value of a foreign
> key column.
>
> Ex:
>
> orderby = [~db.asset.acquiredOn, db.asse
Thanks Jim, I somehow missed the 'orderby' parameter to SQLFORM.grid
On Mon, 21 May 2012 13:11:31 -0700 (PDT), massimo.dipie...@gmail.com said:
> foreign key. You can do a join.
Thanks Massimo; however, that's a little cryptic. Could you explain how a
join can be used to determine the sort order
Massimo - Is there a way to do it with a .smartgrid. I know the
question wasn't on .smartgrid, but I'm using that extensively and too
would like some sort of solution.
-Jim
On 5/21/2012 3:11 PM, Massimo Di Pierro wrote:
foreign key. You can do a join.
On Monday, 21 May 2012 14:49:06 UTC
something like this?
SQLFORM.grid(db.table1.field1==db.table2.id,fields=db.table1.ALL,orderby=db.table2.field2)
smartgrid cannot do this.
On Monday, 21 May 2012 15:24:23 UTC-5, backseat wrote:
>
> Thanks Jim, I somehow missed the 'orderby' parameter to SQLFORM.grid
>
> On Mon, 21 May 2012 13:11
Hi,
I solved it putting the foreing key format in the controller, before the
grid:
def familia_manage():
*db.auth_user._format = '%(last_name)s %(first_name)s'*
fields=[db.t_familiares.f_nombre,
db.t_familiares.f_apellidos,db.t_familiares.f_titular]
form = SQLFORM.grid(db.t_familia
You cannot a have an inner join in smartgrid. That's the biggest difference
in this case. You can have orderby.
On Monday, 21 May 2012 15:47:53 UTC-5, Jim S wrote:
>
> Massimo - Is there a way to do it with a .smartgrid. I know the question
> wasn't on .smartgrid, but I'm using that extens
9 matches
Mail list logo