Jeremy Posted March 31, 2023 Posted March 31, 2023 We have been asked to produce a report where answers to certain questions are a building, which we can do via the Questions table. However I am struggling to join the h_sys_tasks table to the report. Has anyone done this and can help with being able to join this? I have so far managed to join the request and questions tables together and I have added the sys tasks but there doesn't seem to be any data coming through on the report so I guess that I am doing something wrong. I will then need to find answered to specific questions that were asked in the task to report on them....I hope that this is something that can be done? This is how I am attempting to join the data: When you look at the sys tasks table there doesn't seem to be a link to the request number/bpm directly but it's alluded to in various columns but has other data around it so I am guess that I need to do this differently?
Steve Giller Posted March 31, 2023 Posted March 31, 2023 @Jim has joined these table on You should be able to adapt his configuration.
Jeremy Posted March 31, 2023 Author Posted March 31, 2023 @Steve Giller I have just seen this and managed to do it, however is there a 'nice' way to present the task questions and answers in a report? As currently it shows the xml questions and xml responses but how do you tie them together to get some that looks like question/answer?
Steve Giller Posted March 31, 2023 Posted March 31, 2023 Not my area of expertise, I'm afraid, but the nature of a report is that it can only report on what data is in the table, so the XML is what you have to work with, I'm afraid. Using the report to export the data for manipulation by something like PowerBI might be an option?
Jeremy Posted March 31, 2023 Author Posted March 31, 2023 ok thanks, I would suggest that there is lack of functionality within the software if you can't generate reports within Service Manager with the information displayed in a cohesive manner. Is this something that Hornbill are looking at improving?
Steve Giller Posted March 31, 2023 Posted March 31, 2023 I'm sure you can, you just have to have the right expertise in reporting, which I don't.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now