TTS and MYSQL question

Old eGW-users
1

I have a request to produce a report/display of all records for a specific
user of all closed records for a particular date. My query thus far is:

select * from egroupware.phpgw_tts_tickets where ticket_owner = 10 and
ticket_status = ‘X’

but I see no definition for the Date or Closed Date. Information does not
seem to be in the ticket_detail, and I do not seem to be able to find any
other tables correlate to ticket data.

Any help would be appreciated.

Thanks,

Paul Wiley

2

Hi Paul,

without checking in the sources, I guess they are in the
phpgw_history_log table.

Ralf

Paul Wiley schrieb:

I have a request to produce a report/display of all records for a
specific user of all closed records for a particular date. My query
thus far is:

select * from egroupware.phpgw_tts_tickets where ticket_owner = 10 and
ticket_status = ‘X’

but I see no definition for the Date or Closed Date. Information does
not seem to be in the ticket_detail, and I do not seem to be able to
find any other tables correlate to ticket data.

Any help would be appreciated.

Thanks,

Paul Wiley

This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users