[rt-users] Sorting custom fields

[Giuseppe Sollazzo]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Thanks Ruslan,
I'll see if this doesn't overcomplicate things.

Giuseppe

On 14/11/11 18:09, Ruslan Zakirov wrote:
> ustomFields 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;


- -- 
____________________________________

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/

iQEcBAEBAgAGBQJOwjtPAAoJEAqigArPBfJXgSQH/iJfiBVMxUvofXN6aJsO2GJi
qgJ9yE57ylSYaOulctEDkYbXzR0t1RudFZnDhCdDM9aVvl0qIB6BDp4v5kSaueNd
4p1vR//oYQKkR6K/wxXYoeqbsTouy2lU414O9fZ2PWrm9D0aNpfrErLJ5ysRtp0+
W5J3L/nAPWMghB+xWSm5EH43ldPbJJeH/grdLFhcgelBo5uwTeK9relxlrLcnj9e
/z9Nl7K7uGiw2bGkz4+ELk84V3Wr+e/TGziPBsfzn/3jSyvK1IETtCzg4s4PfEe4
SErGXIxCF+VQ6BfdZYslwKkDMA5XJ1MeVm0tLFZyV/y8F33uRR43C5ZhB7lt+YA=
=3vhB
-----END PGP SIGNATURE-----