Jump to content

James Bartle

Hornbill Users
  • Content Count

    18
  • Joined

  • Last visited

Community Reputation

0 Neutral

About James Bartle

  • Rank
    Member

Profile Information

  • Gender
    Male
  • Location
    England

Recent Profile Visitors

388 profile views
  1. James Bartle

    Problem with custom SQL query

    Thank you very much @DeadMeatGF, That's worked quite well
  2. James Bartle

    Problem with custom SQL query

    Hi @DeadMeatGF, Where would I need to put that in the query exactly?
  3. James Bartle

    Problem with custom SQL query

    That's alright @Victor, Thanls for the explanation. As far as the other part of this goes, what would be the best way to set up the report? Much appreciated
  4. James Bartle

    Problem with custom SQL query

    @Victor - Is that a new change because it has worked fine up until now? Also, what would be the best way to display this info in a report? Thank you
  5. James Bartle

    Problem with custom SQL query

    Hi Victor, Thanks for getting back to me. What we would prefer is to be able to have the all of the data since we started using hornbill to be included this as the idea is that it displays the all time records for our administrators.
  6. Hello, We previously had a widget setup that would show each users record number of calls resolved within a working week ever. It simply showed their name and their record number of calls resolved. However, we have not used this for a while and when I went to look at it today it flagged up an error stating "The maximum number of rows allowed (100) has been exceeded, query aborted". The query is as follows: SELECT h_resolvedby_user_id, COUNT(h_pk_reference) as resolved_count, CONCAT(YEAR(h_datelogged), '/', WEEK(h_datelogged)) as year_week FROM h_itsm_requests WHERE h_resolvedby_user_id IS NOT NULL GROUP BY h_resolvedby_user_id, year_week ORDER BY resolved_count DESC Can anyone help? Is there a better way to do this now?
  7. James Bartle

    Viewing slideshows without logging in

    Thanks Martyn, This sorted the issue. Sorry, I would have said sooner but I've not been in since.
  8. James Bartle

    Viewing slideshows without logging in

    Hi @Martyn Houghton, What do you mean by the bypass option exactly
  9. Good day, In our current setup we have a PC connected to a tv screen which is set up to display our Hornbill slideshow. It currently has to be connected to the domain and using our domain accounts in order to simply play the slideshow. Is there a way to share the slideshow via a link that can be accessed without a hornbill account? Thanks for the assistance in advance.
  10. James Bartle

    New look for requests

    Hello, I was wondering why the look of the request list and requests themselves changed in the last update? There used to be boxes around diferent section which gave it a far cleaner and sharper look. There is nothing about this mentioned in the update log?
  11. James Bartle

    Can't select dates in form

    Thankyou very much. This has fixed the issue.
  12. James Bartle

    Can't select dates in form

    Well that is a better way to put it. It's too early to think grammatically.
  13. James Bartle

    Can't select dates in form

    Hello, We are currently having an issue with one of our forms. When a customer attempts to fill in the form to request a new starter they cannot select a date out of the calendar pop-up other than the date on which they are filling in the form. Every other date is greyed out and the cursor becomes a crossed out red circle. Please help!
  14. James Bartle

    Call resolution record widget

    Hi Chaz, Following that what specific things would I need to change in order to have the chart show up?
  15. James Bartle

    Call resolution record widget

    Hi Chaz, How exactly would that be set up sorry? I tried pasting it into the filter to no avail. The image attached is the way the options are set up. Would you be able to say how they should be in there at all? Thanks
×