Requestor, cc and admin cc fields

Hi,

I was exploring the MySQL database to find places where the web interface is
fetching specific information. I could not find which table(s) and columns
are the email IDs of the requestor, cc and admin cc being pulled out for the
Tickets. Any helps?

Thanks and regards

-Ashish Gupta

Ashish,

That particular relationship is a bit complicated under the hood.
This gives a pretty good idea how it all connects:
http://wiki.bestpractical.com/index.cgi?GetReqestorInfoByTicketId

If possible it’s best to extract that info using API tools instead of
mysql commands.

Good Luck,
Mike

Ashish Gupta wrote: