Forum OpenACS Development: Is it possible to have orderby for extended element in Multirow of listtemplate

Hi,
Logically speaking its an extended multirow element
which is not a column of original multirow query.
so orderby on extended column throws an error.

Is there anyway so that i can apply order by for
an extended column in multirow of list template.

My example looks like this :

list::Create \
- multitrow get_res \
- elements {
permitted_user_id

} -orderby {
permitted_user_id {
orderby permitted_user_id
default_direction desc
}
}
}

}

db_mutl.... get_res pingo {} {
set permitted_user_id $user_id
}

This throws an error .
If anyway is devised to apply orderby to extended column
of Multirow in list template . please post a reply to
this thread.

Any help is appreciated in this regard.

Regards,
Caops
To have it available for orderby you need to put the extended element into the sql query. So you need to perform the operation that you do in TCL in SQL (with user_id it should be easy). Guess there is no other way around it.