[rt-users] Custom Field ordering problem

[Kevin Falcone]

On Fri, Jul 10, 2009 at 12:37:03PM -0700, Jennifer Scales wrote:
>    Hey all,
> 
> 
> 
>    I'm having a problem with the ordering of custom fields on the "Create a new ticket" page, and
>    I'm hoping someone can point me in the right direction.
> 
> 
> 
>    The order in which the custom fields display on the 'Create Ticket' page bears no actual
>    relationship to the ordering set with the web-based admin tools.

You don't say, but I assume you're using Postgres as your database.
Try coming up to DBIx::SearchBuilder 1.55, it contains some fixes 
for complex order bys on postgres

-kevin

>    I verified the SortOrder directly in the DB, and this matches what I see on the admin config
>    page.
> 
> 
> 
>    I then did some digging in the source code and traced it to the
>    /Ticket/Elements/EditCustomFields code and the 'iterator'-like calls to the
>    $CustomFields->Next function. Seeing that, I tried re-calling the OrderByCols function of the
>    CustomFields collection in the %INIT block of the EditCustomFields like so:
> 
> 
> 
> 
> 
>    $CustomFields->OrderByCols(
> 
>             { ALIAS => 'main',
> 
>               FIELD => 'SortOrder',
> 
>               ORDER => 'ASC' }
> 
>         );
> 
> 
> 
>    Still no dice - the Next iterator is ignoring the SortOrder for no reason I can fathom, and
>    trying to make a coherent layout is nigh impossible.
> 
> 
> 
>    Has anyone else seen this, or can suggest a solution or workaround?
> 
>    FWIW, I'm using RT 3.8.2.