[storm] Order By Reference

[Gerdus van Zyl]

On Thu, Sep 17, 2009 at 11:18 PM, Jamu Kakar <jkakar at kakar.ca> wrote:
>> How can I order a resultset of statement_transform by cat_description?
>>
>> something like
>> store.find(Statement_Transform).order_by(Asc(Category.cat_description))
>> except that doesn't work.
>
> I haven't tested this, but I believe you want something like:
>
> result = store.find(Statement_Transform,
>                    Statement_Transform.cat_id == Category.cat_id)
> result.order_by(Category.cat_description)
>
> Thanks,
> J.
>

Works great! thanks for the quick reply.