[ic] sort by a field in relational table

murahashi interchange-users@interchange.redhat.com
Fri May 24 22:41:02 2002


I know this question may be too basic but I could not find in doc and
mail-list.

How to sort search results by a field of another table ?

In my case, I would like to sort the search results like below by sort field
in state table.

The state table have fields like this: code contry sort name.

[loop search="
   st=db
   fi=userdb
   co=yes
   sf=membership
   se=A
   tf=state
   su=yes
   ml=99999
  "]
  [loop-change 1][condition][loop-data userdb
state][/condition]<br><b>[loop-data userdb state]</b>[/loop-change 1]
 [loop-data userdb username]&nbsp;
[/loop]

Murahashi