Difference between revisions of "Widget Filters"
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | {{DISPLAYTITLE:Hornbill How To: | + | {{DISPLAYTITLE:Hornbill How To: Reporting}}__NOTOC__ |
<div style="border:1px solid #90C0FF; background:#D0E0FF; width:99%; padding:4px; margin-bottom:10px;"> | <div style="border:1px solid #90C0FF; background:#D0E0FF; width:99%; padding:4px; margin-bottom:10px;"> | ||
__NOTOC__[[Main Page|Home]] > [[How To]] > [[:Category:How_To_-_Reporting|Reporting]] > Widget Filters | __NOTOC__[[Main Page|Home]] > [[How To]] > [[:Category:How_To_-_Reporting|Reporting]] > Widget Filters | ||
Line 6: | Line 6: | ||
|- valign="top" | |- valign="top" | ||
|style="width:73%"| | |style="width:73%"| | ||
− | The following is a complete list of the | + | The following is a complete list of the Reporting "How To" guides, hints, tips and videos that have been created to aid in the configuration and usage of the system. |
|style="width:5%"| | |style="width:5%"| | ||
| | | | ||
Line 15: | Line 15: | ||
:* [[Reports|Reports in Hornbill]] | :* [[Reports|Reports in Hornbill]] | ||
:* [[Widget Filters|Widget Filters]] | :* [[Widget Filters|Widget Filters]] | ||
+ | :* [[Table/Column Alias|Table/Column Alias]] | ||
|} | |} | ||
Latest revision as of 12:38, 20 June 2018
The following is a complete list of the Reporting "How To" guides, hints, tips and videos that have been created to aid in the configuration and usage of the system. |
Related Articles |
Widget Filters
Hornbill has quite a detailed reporting tool that allows users to gather information on requests logged for specific periods and according to Service Level Agreements. The wiki page https://wiki.hornbill.com/index.php/Report_Types has some useful information on the different types of reports and how to create them.
One request we had was a user who wanted to created a widget with count, and another with list of tickets which are about to breach in the next 2 days and are for specific tier tickets, owned by a specific team . The customer had written the query below and was getting no results even though there were some tickets which are due to breach in the next 2 days:
The answer was to add one more condition to the WHERE clause which specified the request type and date range of two days as shown below: