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

26 Excellent


About Kelvin

  • Rank
    Senior Member

Profile Information

  • Gender
  • Location
    West Suffolk NHS Foundation Trust

Recent Profile Visitors

1,603 profile views
  1. @James Ainsworth Thanks for the suggestions
  2. Is there any plans to be able to search or set up views based on connections. example I want a list of call where a customer has been connected to requests. "Customer A" gets connected to all change requests that affect "System X" but is not the main customer of the request. "Customer A" phones for an update on the requests but does not have a request number.
  3. I would be very interested in this too
  4. 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.
  5. @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
  6. @Steve Giller The Assets are appearing in calls as below
  7. @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
  8. Hi @Steve Giller I am using the Report Builder in the Admin Panel. I get the following.
  9. 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
  10. All sorted I have worked it out Join Request - Question with field Request ID - Reference
  11. 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
  12. @Steven Boardman great thank you for confirming
  • Create New...