This forum is in READ-ONLY mode.
You can look around, but if you want to ask a new question, please use Stack Overflow.

sort by foreign field in backend

This is for discussion, mainly on 1.x but there's some 2.x topics here too.

sort by foreign field in backend

by palmaro1 » Thu Aug 04, 2011 5:04 pm

I need to sort a list in backend by a foreign column.
this is the schema.yml:
RDA08RDA:
tableName: rda08rda
actAs: { Timestampable: ~ }
columns:
id: { type: integer(8), fixed: false, unsigned: false, primary: true, autoincrement: true }
numrichiedente: { type: string(8), fixed: false, unsigned: false, primary: false, default: '', notnull: true, autoincrement: false }
rda08RDAitems:
tableName: rda08RDAitems
actAs: { Timestampable: ~ }
columns:
id: { type: integer(8), fixed: false, unsigned: false, primary: true, autoincrement: true }
rdaid: { type: integer(8), fixed: false, unsigned: false, primary: false, default: '', notnull: true, autoincrement: false }
rdadescitem: { type: string(255), fixed: false, unsigned: false, primary: false, notnull: false, autoincrement: false }
relations:
RDA08RDA: { onDelete: CASCADE, local: rdaid, foreign: id }
in backend, I do a list in which row there is rdaid, numrichiedente and rdadescitem.
Normally the list is sorted by rdaid and rdadescitem, but i'd like to sort it by nurichiedente, that is a foreign field.
Is it possible and how can I do?
Thanks a lot
palmaro1
Junior Member
 
Posts: 1
Joined: Fri Mar 18, 2011 4:20 pm