Jump to content

Kelvin

Hornbill Users
  • Content Count

    354
  • Joined

  • Last visited

  • Days Won

    2

Kelvin last won the day on January 25 2017

Kelvin had the most liked content!

Community Reputation

24 Excellent

2 Followers

About Kelvin

  • Rank
    Senior Member

Profile Information

  • Gender
    Male
  • Location
    West Suffolk NHS Foundation Trust

Recent Profile Visitors

1,445 profile views
  1. 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.
  2. @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
  3. @Steve Giller The Assets are appearing in calls as below
  4. @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
  5. Hi @Steve Giller I am using the Report Builder in the Admin Panel. I get the following.
  6. 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
  7. All sorted I have worked it out Join Request - Question with field Request ID - Reference
  8. 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
  9. @Steven Boardman great thank you for confirming
  10. 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?
  11. @Deen Thanks for the info. I will pass this onto the team.
  12. 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?
  13. @Dan Munns @samwoo Thanks for the info. I will work with Sophie on Monday to get this done. I knew we could count on the forum
  14. @Steven BoardmanGreat thankyou
×
×
  • Create New...