| 
24-03-2006, 04:04 PM
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. |