Kanban board report

[Мария Харченко]

Hello there!

Could you please help me in creating the report form for my team? We started using Kanban not long ago and do not track time or execution period, but I need to be able to create the following report:

* it should contain the names of team members and the tasks on them and their statuses, like histogram I think.

* Hand-made variant would look like a table:

user name/tasks statuses

             to do     in progress   on hold   done

user 1     1              5                   0            1

user 2    4               2                   1            3

something like that. 

[Alexey_Rjeutski__Polontech_]

You can search for filters in table searchrequest.

As for the query, you can use something like

SELECT filtername FROM searchrequest WHERE reqcontent LIKE '%xyz%';

but that will give you a lot of false alarms. As jira uses jql query string to keep the filter query that can be interpreted in a big set of ways - creation of such universal query seems to be impossible.