# TTS and MYSQL question

**URL:** <https://help.egroupware.org/t/tts-and-mysql-question/371>\
**Category:** eGW-users\
**Created:** [September 27, 2005, 9:41pm UTC](https://help.egroupware.org/t/tts-and-mysql-question/371 "2005-09-27T21:41:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paul\_Wiley](https://help.egroupware.org/letter_avatar_proxy/v4/letter/p/f19dbf/32.png) [@Paul\_Wiley](https://help.egroupware.org/u/Paul_Wiley)\
**Post date:** [September 27, 2005, 9:41pm UTC](https://help.egroupware.org/t/tts-and-mysql-question/371/1 "2005-09-27T21:41:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ralfbecker\_dr](https://help.egroupware.org/letter_avatar_proxy/v4/letter/r/f04885/32.png) [@ralfbecker\_dr](https://help.egroupware.org/u/ralfbecker_dr)\
**Post date:** [September 27, 2005, 10:10pm UTC](https://help.egroupware.org/t/tts-and-mysql-question/371/2 "2005-09-27T22:10:08Z")

</div>

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](http://SF.Net) email is sponsored by:  
Power Architecture Resource Center: Free content, downloads, discussions,  
and more. [http://solutions.newsforge.com/ibmarch.tmpl](http://solutions.newsforge.com/ibmarch.tmpl)

* * *

eGroupWare-users mailing list  
[eGroupWare-users@lists.sourceforge.net](mailto:eGroupWare-users@lists.sourceforge.net)  
[https://lists.sourceforge.net/lists/listinfo/egroupware-users](https://lists.sourceforge.net/lists/listinfo/egroupware-users)