Jump to content

Search the Community

Showing results for tags 'database direct'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Hornbill Platform and Applications
    • OpenForWork
    • Announcements
    • Blog Article Discussions
    • General Non-Product Discussions
    • Application Beta Program
    • Collaboration
    • Employee Portal
    • Service Manager
    • IT Operations Management
    • Project Manager
    • Supplier Manager
    • Customer Manager
    • Document Manager
    • Timesheet Manager
    • Live Chat
    • Board Manager
    • Mobile Apps
    • System Administration
    • Integration Connectors, API & Webhooks
    • Performance Analytics
    • Hornbill Switch On & Implementation Questions
    • GRC Manager
  • About the Forum
    • Announcements
    • Suggestions and Feedback
    • Problems and Questions
  • Gamers Club's Games
  • Gamers Club's LFT

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start








Website URL





Found 11 results

  1. Linked to our previous post (link at the bottom of this one), we want to implement a progressive capture process which one of the fields is a dynamic list of values which we want to create using a database direct SQL query on the Hornbill Instance, rather than having to duplicate data in simple lists which is not practical. We are wanting to query a subset of organisations which have a certain industry type, to be used as the source for the dynamic drop down selection. This is in support of our previous post (link at the bottom of this one), where we are trying to implement Internal Services Requests that would be raised by our Project Management Team to manage subscription of services through Hornbill itself automatically, rather than having this to be done manually which is both a overhead and can be prone to errors. I can see that the ability to create dynamic list from a database direct sql query would be useful for other users and organisations as well. It would need to support the returning of two columns, one as the Raw Value, i.e. organisation ID, and a display value, i.e. organisation name. Cheers Martyn
  2. We are attempting to do some date matching and need to export all our records from h_sys_contact as we provide external customer support. We are hitting the limit of 20,000 records as we have 28,890 current records which is growing daily. Is there a setting to control the record limit or is this hard coded? Cheers Martyn
  3. Before the Database Direct enforcement to allow only SELECT scripts, we used to use an INSERT script in Database Direct to make things a lot easier when adding SLA manage rules to a new Service as we have manage rules depending on a lot of site locations and the manual creation of manage rules is a time consuming process and it's easy to make mistakes in that creation. Is the duplication of existing SLA configuration/manage rules from an existing Service into a new Service something that can be included in a new enhancement? FYI: @Victor
  4. As suggested by @Victor, here is one situation where, from time to time, we needed to UPDATE a request. We have active the star rating and questions in customer feedback for requests but, from time to time, the customers make mistakes on providing feedback. The most usual situation is when the customer gives 5 star rating but they answer all the questions (we have 3 questions) as "very dissatisfied". Once the feedback is provided by the user, it can't be changed but, when we realize that this contradiction appears in a request (5 star rating with 3 very dissatisfied answers), we double check it with the customer and the customer always accepts that he/she made the mistake. In this situation we used to UPDATE the answers for what the customer wanted to answer. Now, with the limitation introduced by ESP Build 3237, we can't do this anymore.
  5. Can I request an enhancement to allow the restriction introduced in ESP Build 3237 - "Enforced checks for Database Direct to only allow SELECTs for production instances" to be configurable by a permission or system setting, as we often use additional SQL commands in the Admin Tool Database Direct to correct or update records especially when undertaking data migrations into our Hornbill Instance. Cheers Martyn
  6. To get around the issue with the Organisation Import tool I need to run an update script to update custom fields and industry on a selected number of organisation records. Can you please advise how I request this to be done? Cheers Martyn
  7. Following the change to restrict Database Direct to SQL SELECT only in ESP Build 3237, I am no longer able to do a bulk insert into h_itsm_servicesubscriptions against organisations loaded in using the Organisation Import Tool, as part of bring on board a new division to our existing instance. Can you please advise how I request this to be done? Cheers Martyn
  8. Hello All, I'm looking to implement the below query to run on a schedule to automatically move specific mail in our mailboxes to sent and deleted items; this is related to how we organize the mailboxes. -- Move Sent and Deleted emails UPDATE h_msg_messages, h_sys_organizations SET h_msg_messages.h_folder_id = h_sys_organizations.h_custom_11 WHERE LOCATE(CONCAT('- ', h_sys_organizations.h_organization_name, ' -'), h_msg_messages.h_msg_subject) > 0 -- Look for '- Name -'' only in subject AND (h_msg_messages.h_folder_id = 113 OR h_msg_messages.h_folder_id = 114) -- Support -> Sent & Deleted Folders AND h_sys_organizations.h_custom_11 IS NOT NULL -- Must have a valid folder AND h_sys_organizations.h_custom_11 <> 172 -- Ignore organisation Currently the script is ran manually however having a feature to run this automatically on a schedule would be ideal. Thanks! Josh M
  9. Morning all, Can someone tell me how easy it is to create a query to pull back all change requests in a select date range but also to show the date they have been scheduled for? I cannot easily do/find this? Thanks Alex
  10. Hi, When exporting a CSV from a SQL query in Database Direct there aren't any text qualifiers as there are when exporting a CSV from the requests list This causes problems when there are blank fields and where there a commas in the text fields as it puts the items in the wrong columns Would it be possible to change that or give the option to use text qualifiers? thanks, Pete
  11. At the moment we have a number of saved sql queries in Database Direct which is very useful for running common queries, however one issue at the moment is that in order to view the sql you have to run it, as it runs as soon as you select it. This is fine when only doing selects, but as we have a number of SQL update queries we run in relation to imported data, it would be good to have the option to open or edit the saved SQL without having to run it. Cheers Martyn
  • Create New...