Reports
This section is used for reporting purposes. You can build or manage various reports in this section. Having a little SQL knowledge will be helpful for the usage of this section. Such as, by creating a report that has all the users who completed a specific module will help you to see all of completed users or groups for that specific assignment. You can also create more filters to help you categorize users or group in more specific ways depending on your needs, such as you list all of the users who has 'doe' in their last name and also whose job title is 'Supervisor' and etc. Only users with 'report' privilege or owner privilege can run or see reports
Editing description of a report will help the user of that report to understand the role/ job or capabilities of that report. Adding more details in the description of the report will help the user this report. You can also update the name or the owner of this report if you have required administrator privileges. Additionally, you can assign users to the report to provide them "Execute Report" privilege by searching their names in User field and selecting the user in the list, which will let them to run report that they are assigned to. Once a user is assigned to report, the user can only access to their assigned reports. You can assign up to 50 people to a report by using + button located below the User field
By configuring the query for your reports, you are making your SQL Query to run in a way you want to list the users or groups. You can add more filtering as you need by simply selecting a column name with a proper 'and'/'or' statement.
The list in this query builder is used as selecting the columns/ fields you would like to include to your report.For example, if you choose to use user_id,date_due, you will have user_id and date_due fields as your report columns.
You can think of this whole section as your pre populated SQL Query builder.
Detailed Explanation with Field Names
Additional Columns : The columns those will be included to your report
Global AND/ OR: Basically used for FROM statement for you to choose your
Columns: A column you are selecting from. If the list element is users.first_name, then it means that you are selecting first_name column in users table and etc.
Conditional: Enables you to apply your conditional value you entered in Value field that is next to it.
For example: If you select '=' in the list and enter 'John' the value field, your filter set to if the name is 'John' then find it. Please note that the search is case sensitive.
To sum up, using all of the information we mentioned above, the query result will provide you
User_id of all records from users table that is 'John' in first name column
Report Run Result Example:
