Hello everybody, I hope to find some help here with custom ticket queries in sql for trac that will make my life easier ;)
First of all, we are using a hosted trac on hosted-projects.com. So my possibilities may be limited or some functionality may be missing but custom ticket queries in sql seem to work, although not fully as I would expect e.g. CURDATE() function is not working. I would like to have two queries: 1) All my new tickets When I try a custom query without sql with owner=michael and status=new, it just gives all the tickets that are assigned to me. But what I consider new tickets are - tickets that have me as the owner and there was no change in the ownership, so basically all tickets that are created with me as the owner and are not touched again or - tickets that I own that have been assigned to me for the first time (which means that I have not been owner of the ticket before) 2) All tickets reassigned to me This query should show me tickets that I own and have been assigned back to me, which means that I have been owner of the ticket before. I think that for these queries I have to join the ticket and ticket_change table somehow, but that is exactly where I am stuck... Can someone help me with these sql queries? Regards, Michael -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To view this discussion on the web visit https://groups.google.com/d/msg/trac-users/-/6_ykxdkm8jQJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
