[rt-users] Help with Custom Fields

[Autrijus Tang]

On Tue, Apr 20, 2004 at 07:01:45AM -0400, phillip wrote:
> mysql> select Name.Company Name From CustomFields;
> ERROR 1109: Unknown table 'Name' in field list

You want:

    SELECT * FROM CustomFields WHERE Name = "Company Name";

You may want to use the ID of the custom field to find out the
values each ticket associates with the field:

    SELECT * FROM TicketCustomFieldValues WHERE CustomField = 7;

Thanks,
/Autrijus/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20040420/21041824/attachment.sig>