On May 7, 2:05 pm, surge <[EMAIL PROTECTED]> wrote:
> Hello everybody,
>
> I've tweaked Trac to my needs pretty well now. The flexibility of Trac
> reports is unbelievable.
>
> Got a question though about SQL syntax. In one of the built-in reports
> I saw this in the ORDER statement:
>
> ORDER BY (status = 'assigned') DESC,...
>
> What does the part in parenthesis do? Is it only sqlite or mysql as
> well?
>
> Thanks,
> Sergei
That phrase is evaluated as though it were a column in the database.
i.e. any record with a status other than assigned is set to false and
will sort accordingly.
It's stock sql.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
