If your query appears blank and you have filters applied to any fields and wish to remove a filter applied to a field in your query, then follow the steps below:
Click Access Button
then click HR Admin.
Click Queries then select the relevant query.
Click Edit then go to the filters page.
Click the field with the filter applied then click X Remove Filter Option.
Click Save.
When creating queries, in order to avoid duplicates, inaccurate data or blank reports you will need to create separate queries for each main area and make sure you don't have ticked more than one main area within the same report. The main areas will be those from the left column.
For example, if you need a report to show you holiday and toil information, in order to achieve an accurate report you will need to do them separate.
πNote: For logbooks the fields within the logbook itself can have unsupported characters such as square brackets. These would need to be removed from the field name and the query should then show the data as normal when being ran.