How do I relate the tickets table to the customfields table?

slarson

I need to be able to report off of my custom fields, but I am unsure as to how they relate back to the tickets table.

Thanks

**Jamie Edwards** · 14-05-2007, 02:43 PM

Hi slarson,

Have you had a look at the ERD in the help folder of your SupportSuite package?

slarson · 14-05-2007, 05:09 PM

Figured it out myself.

swcustomfieldvalues.typeid=swtickets.ticketid

slarson · 14-05-2007, 05:11 PM

Quote:

Originally Posted by Jamie Edwards

Hi slarson,

Have you had a look at the ERD in the help folder of your SupportSuite package?

Jamie,

Thanks for the response. No I didn't know the ERD was there. I will take a look.

Thanks!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

slarson Offline New Member Posts: 26 Join Date: Jul 2006	How do I relate the tickets table to the customfields table? - 14-05-2007, 02:37 PM I need to be able to report off of my custom fields, but I am unsure as to how they relate back to the tickets table. Thanks

slarson Offline New Member Posts: 26 Join Date: Jul 2006	14-05-2007, 05:09 PM Figured it out myself. swcustomfieldvalues.typeid=swtickets.ticketid