Jump to content

Search the Community

Showing results for tags 'database direct'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Hornbill Platform and Applications
    • Announcements
    • Blog Article Discussions
    • General Non-Product Discussions
    • Application Beta Program
    • Collaboration
    • Service Manager
    • Project Manager
    • Supplier Manager
    • Customer Manager
    • Document Manager
    • Configuration Manager
    • Timesheet Manager
    • Live Chat
    • Board Manager
    • Mobile Apps
    • System Administration
    • Integration Connectors, API & Webhooks
    • Performance Analytics
    • Hornbill Switch On & Implementation Questions
  • 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 5 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. 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
  3. 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
  4. 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
  5. 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...