Jump to content

Search for Tasks (Activities)

P. Nordqvist

Recommended Posts

Hello @P. Nordqvist,

In the Activities View you have a basic search and some filter buttons on the right hand side.

If you want to search for a more specific thing you can create a view and add different filters to it.

Here are the list of things you can filter on. ID is not available as it is a hidden field and description is also not available because of performance reasons.

Yo can also create sub-filters in the Board View for each lane.

Hope this helped,



Link to comment
Share on other sites

  • 1 month later...

@Daniel Dekel we create tasks to ask different teams information about requests or to fill in forms (via bespoke tasks) which we can view in the request, but we need a way of reporting on these so that we can get the information out of the system to report to other departments etc.

Is there a report that we can write or a database query that we can run to return the information that was entered in a task?

Link to comment
Share on other sites

Hi @Jeremy

for maximum visibility, reporting would be the best approach here. As Daniel has pointed out, the visibility model for tasks is very much focused around the task owner and task assignee.

Lets start by looking at a simple widget to show who has been completing tasks. This requires the Advanced Analytics module found in Hornbill Administration and we can utilise a chart style widget returning data via the "SQL Group By" data type. The data source would be something like below:


The configuration above is very general and would return tasks completed by all users, including an "N/A" column as we're looking at all tasks. We haven't yet filtered on status (Assigned, completed, etc.).

To ensure you're just focusing on completed tasks, add the filter: h_state = 4 and this will get rid of the "N/A" results.

Setting the date column to "h_completed_on" allows us to begin looking at the data over certain time periods, for this to take effect it's necessary to select the desired "Sample Period" in the field that immediately follows.

If you're interested only in the tasks completed by users that belong to a particular team (or other Hornbill group), it will be necessary to enhance the filter. The following will acheive this:

h_state = 4 AND h_completed_by IN (select h_sys_account_groups.h_user_id from h_sys_account_groups WHERE h_sys_account_groups.h_group_id = "MYCOMPANY/IT/SERDSK/")

Replace "MYCOMPANY/IT/SERDSK/" with the ID of the group that you're interested in. This can be obtained from your organisation structure.

If you're keen to understand the other task status values, these are as follows (taken from https://api.hornbill.com/docs/_types/taskStateType ):

    <xs:enumeration value="assigned" esp:mappedValue="1"/>
    <xs:enumeration value="accepted" esp:mappedValue="2"/>
    <xs:enumeration value="complete" esp:mappedValue="4"/>
    <xs:enumeration value="rejected" esp:mappedValue="5"/>
    <xs:enumeration value="cancelled" esp:mappedValue="10"/>
    <xs:enumeration value="expired" esp:mappedValue="16"/>

I hope that helps, let me know if you need some help with other task-related reporting requirements! The application entity viewer that may help with the identification of columns when building more metrics and reports: https://wiki.hornbill.com/index.php/Application_Entity_Viewer


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...