Allow write access to k1000 database
As most people know you can access the k1000 database using a 3rd party reporting tool, but its only read only access.
If the default user (R1), could be given write access or if another user could be created with write permissions to the database that would be very helpful.
Example: Make a report showing number of created tickets per day by category, then create a view of that report to be referenced in a summary report
**normal sql query
select C.NAME As Category, count()
FROM HDTICKET T
INNER JOIN HDCATEGORY C on (C.ID = T.HDCATEGORYID)
where (DATE(T.CREATED) = DATE( NOW() ) )
group by Category with ROLLUP;
Result below:
Column1: Category | Column2: count (*)
CategoryA 13
CategoryB 3
CategoryC 1
CategoryD 1
CategoryE 1
CategoryF 1
CategoryG 2
CategoryH 1
CategoryI 1
24
***Now when trying to create a view
CREATE VIEW testview1 AS Select T.CUSTOMFIELDVALUE1 as Location,count(*)
FROM HDTICKET T
where (DATE(T.CREATED) = DATE( NOW() ) )
group by T.CUSTOMFIELD_VALUE1 with ROLLUP;
David
shared this idea
-
tom ferna commented
Thanks