I'm looking to do two things.
1.) I'd like to modify the existing "Open" view so that it filters out any tickets with as specific status (in this case "On Hold") or if the ticket has a specific department (in this case "Projects").
2.) Because I have omitted those tickets, I'd like to add a view that shows tickets that are "On Hold" or "Projects".
So I need some help in regards to which pages hold which bits of code, that sort of thing. I'm thinking I need to modify the qselect to modify the query, and the qform to join the Status and Department tables (I could use some help with that). But I would like to know where do I modify to add a heading across the top (like with the existing lists of "Open" "My Tickets" "Overdue" "Closed Tickets" etc? Then I need I figure I have to modify code to show the count in that view. It looks like the views are somewhat dynamic based on a url encoding of status=????? I'd have to find where that is done as well. ??
Any help is greatly appreciated.
Thanks.
