I have a dashboard with categories and a count of each item in each category. I would like to click the category and create a drill down link to a DB Connect query that shows each item within that category rather than the category name and count of each item.
(e.g. XML Source see attached image)
I get the error:
Invalid view name requested: "| dbquery mon02 "SELECT * from usertasks"". View names may only contain alphanumeric characters.
I cannot get the proper syntax down when querying with DB Connect.