[rt-users] Sorting custom fields

[Ruslan Zakirov]

On Mon, Nov 14, 2011 at 9:31 PM, Giuseppe Sollazzo <gsollazz at sgul.ac.uk> wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 14/11/11 17:24, Kenneth Crocker wrote:
>> Giuseppe,
>>
>> Are you talking about hoe the VALUES appear or the way the Fields
>> themselves appear on a ticket page?
>
>
>
> Hi Kenneth,
> the order of the fields themselves.
> I know you can give a sort order for the values within the interface,
> so I was expecting something similar to be available for Fields order.
> The only way to do it seems to be swapping them around.
> Any other possibility?

Custom perl script that talks to API or direct SQL on
ObjectCustomFields table. It's better to use fresh 3.8 or 4.0. Here is
SQL to see the current state:

SELECT cf.Name, q.Name, ocf.SortOrder FROM CustomFields cf JOIN
ObjectCustomFields ocf ON ocf.CustomField = cf.id LEFT JOIN Queues q
ON ocf.ObjectId = q.id WHERE cf.LookupType = 'RT::Queue-RT::Ticket'
AND (q.Name IS NULL OR q.Name = 'Blocks') ORDER BY cf.LookupType ASC,
ocf.SortOrder ASC;

> Thanks,
> Giuseppe
>
>>
>> Kenn LBNL
>>
>> On Thu, Nov 10, 2011 at 6:49 AM, Giuseppe Sollazzo
>> <gsollazz at sgul.ac.uk <mailto:gsollazz at sgul.ac.uk>> wrote:
>>
>>
>> Hi there, maybe this is stupid but is there a quick way of
>> re-sorting custom fields?
>>
>> Thanks, Giuseppe
>>
>
> - --------
> RT Training Sessions
> (http://bestpractical.com/services/training.html)
> *  Barcelona, Spain  November 28 & 29, 2011
>
>
>
>
>> -------- RT Training Sessions
>> (http://bestpractical.com/services/training.html) * Barcelona,
>> Spain ? November 28 & 29, 2011
>
>
> - --
> ____________________________________
>
> Giuseppe Sollazzo
> Senior Systems Analyst
> Computing Services
> Information Services
> St. George's, University Of London
> Cranmer Terrace
> London SW17 0RE
>
> Email: gsollazz at sgul.ac.uk
> Direct Dial: +44 20 8725 5160
> Fax: +44 20 8725 3583
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iQEcBAEBAgAGBQJOwVCDAAoJEAqigArPBfJXAzsH/3fcawXwyosVR9yPP65qky2R
> PpgMozygRBcoJnlh1Ic6cURrcXUfhn+xDYtrtmHzD4W8Uk+bgFWNd7bSx+14/SJy
> I5WmqpLo1Cv79vY2OWDe/DQ1eCxS45lSMk0CtjqbZM0ljWjc00D+oFU+wbBOoska
> 1TJH9lXueZ7ckeuC35v/9tbuZBxQgwfcFk2IRTxQZkuMM2Y5O6pdVp8+y0uXGprC
> ECSsTd8F1LT0ymajsoUUJYM0ymZno0wyTbW0fsTsHjZKsjQxJcqVHo8KZ2SKY+t7
> gP4nXgGgE2yMk5ZXeEudtUdMUAH3waUSCM61oDMgnvKVoB1bWMZWmW9sR/AsXF4=
> =y21q
> -----END PGP SIGNATURE-----
>
>
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> *  Barcelona, Spain — November 28 & 29, 2011
>



-- 
Best regards, Ruslan.