Links between Tickets & CustomFields tables?

[jonmoore]

Can someone please tell me one simple thing - what linkages exist in the mySQL database to link ticket records to the customfield values for those tickets?

I need to do some custom reporting and need to pull custom field info along with standard ticket information.

Cheers,

Jon

[jonmoore]

Solved this if anyone's interested. It appears that you can join on tickets.ticketid = customfieldvalues.typeid.

You do get multiple records returned per ticket, but as you can also bring back the customfieldid you can filter out to specific customfieldvalue values.

I think this is a oversight in the schema as if it hadn't have been for the fact that I had some data in the tables - I'd never have seen the link.

This nugget could've saved me 3 days worth of wasted time this week.