Dan Munns Posted November 5, 2020 Share Posted November 5, 2020 Hi, I need to create a report which shows the outcome of a task as one of the columns but I cant work out the table joins required to show the tasks. Can anyone help me out? Link to comment Share on other sites More sharing options...
Bob Dickinson Posted November 9, 2020 Share Posted November 9, 2020 Hi@Dan Munns Attached is an example report showing active Service Requests that have tasks associated. I have added the Task Outcome column to the output as well. Does this give you the information you need to create your desired report? tasks-linked-to-active-service-requests.report (2).txt Thanks Bob Link to comment Share on other sites More sharing options...
Dan Munns Posted November 9, 2020 Author Share Posted November 9, 2020 Hi @Bob Dickinson Almost what I need, thanks! I just need the column h_sys_tasks->Outcome Answers to only show the display data of the answer selected. At the moment is shows like this: Any way to only show the display value? Thanks, Dan Link to comment Share on other sites More sharing options...
Bob Dickinson Posted November 9, 2020 Share Posted November 9, 2020 Hi@Dan Munns Unfortunately the display name of the Outcome isn't a value that is explicitly stored in a column - the UI deals with it when showing it on a request, but only the outcome value is actually stored. Sorry about this Kind Regards Bob Link to comment Share on other sites More sharing options...
Dan Munns Posted November 9, 2020 Author Share Posted November 9, 2020 OK thanks @Bob Dickinson Thanks for the report anyway Link to comment Share on other sites More sharing options...
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