Adding a query/report page

As well as forms, queries/reports created via the query tool can be rendered/displayed on the HR Portal. The template JSON we can use to display a report on the HR Portal is as follows:

{
"title":"Authorised",
"action":"query",
"queryreference":"SS - Annual Leave Requests",
"role":"SS",
"message_no_data_content":"No authorised requests.",
"message_no_data_title":"Authorised"
}

Note: the “queryreference” determines the query that will be displayed on the page. This can either be the description of the query, or the queries unique reference code.

 

 

 

 

If using the query description, you must ensure this description is unique to all other queries created in the windows application, your own user or other users. You must also be wary of ‘typos’.

For the query to work in the HR Portal, it must also have a query type of ‘Self Service’ or ‘Authorised User’.