Jump to content


Hornbill Users
  • Content Count

  • Joined

  • Last visited

  • Days Won


Kelvin last won the day on January 25 2017

Kelvin had the most liked content!

Community Reputation

24 Excellent


About Kelvin

  • Rank
    Senior Member

Profile Information

  • Gender
  • Location
    West Suffolk NHS Foundation Trust

Recent Profile Visitors

1,496 profile views
  1. I would be very interested in this too
  2. Is this still an issue as we are unable to search for any Change Requests using the search bar at the top of the page.
  3. @Steve Giller I thought I would come back to the forum as I can see from the support ticket this is a case of query is to large to complete within 30 seconds. What I am trying to achieve is a list of calls with the asset type == 15. Do you know if there is a more optimised approach. Thanks
  4. @Steve Giller The Assets are appearing in calls as below
  5. @Steve Giller I have just downloaded the file above add uploaded as a new report and this still comes up with "No Preview Data Returned" not added any filters
  6. Hi @Steve Giller I am using the Report Builder in the Admin Panel. I get the following.
  7. I am trying to create a report that will give me all assets and their calls for a certain asset type. At Insights I was given a starter definition file with the table joins but I have been unable to get this to return any data. Any help would be greatly appreciated. assets-with-calls.report.txt
  8. All sorted I have worked it out Join Request - Question with field Request ID - Reference
  9. I am sure this has been previously asked, what is the sql join for the Request Table and the Table that holds custom questions from PCF? Thanks
  10. @Steven Boardman great thank you for confirming
  11. I have been looking on the Demo environment and can see Requests Average Response Time Report does this take into account the Working Time Calendars?
  12. @Deen Thanks for the info. I will pass this onto the team.
  13. I think this may have been asked before, so feel free to link to another post. When applying emails to requests the html formatting is lost. Is there anyway to keep the formatting?
  • Create New...