Hello,I created a custom list where I defined various "ticket status" values.I can email ticket status using %{ticket.ticketstatus} variable.Question:  Is there any way to generate a report that would show ticket number, ticket description and ticket status for all open messages?This will be very useful to analyze trends and provide management with summary reports It is not important if it done via direct SQL query against the database, or through the web page.Thanks

like:SELECT * FROM ost_ticket WHERE status='open';?

Very welcome. :)  I'll close this thread but please feel free to start a new one if you have another question.

Write a Reply...