Jump to content

Search the Community

Showing results for tags 'joins'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • 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

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Organisation


Location


Interests


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype

Found 2 results

  1. Related to my earlier post below, it would be useful to be able to join multiple tables in the the Measure 'Data Source' definition, so that criteria held in related tables can be used in the measure source. Cheers Martyn
  2. Hello, I can create a report that will give me all of our calls that have been logged in Hornbill not a problem but when I look at this report it is missing key information about the person who logged the call or had the call logged for them either by auto responder or our helpdesk. This is partly a training issue as the helpdesk are not filling out the information properly but that doesn't help me for my reports. I figured because they fill out the name then I would be able to left join from the requests table to the system accounts table and use the name field as the common field between the two to get the company name for the user. In SQL I would write... Select * From h_itsm_requests Left Join h_sys_accounts on h_itsm_requests.Customer Name = h_sys_accounts.name At the moment I am having to put each table in to excel and doing a vlookup for the reports every month. If anybody can help me then please let me know. Thank you,
×
×
  • Create New...