How to Write a SQL Query for a Report?
Hello,
I am trying to set up a monthly report in K1000. The report right now runs and generates the amount of tickets opened, closed and pending. I need it to do this but only for select tickets. We have a few tickets that we receive that take too long and are out of our control due to training. I am just wanting to know how to write the query to show all tickets minus the ones we call EACR's.
Thanks.
2 Comments
[ + ] Show comments
-
in which field is "EACR" located? - JasonEgg 7 years ago
-
Also, please post your current query. - chucksteel 7 years ago
Answers (0)
Please log in to answer
Be the first to answer this question