-----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: gsoll...@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----- -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 & 29, 2011