Queries/Reporting

A query that checks which employees have a sick leave / other event without supporting documents, that were uploaded through the "attach file" option of the event. That way we can monitor who needs to upload their documents and who doesn't.

When certain numerical data is exported to Excel from Queries, it comes out as a text file e.g. length of service dates and dates/days of birth (e.g. when looking at age). This means that when you try to sort on Excel it does it alphabetical rathe...

We would like a report that combines the ATS applicant and employee information. This will enable us to track vacancies filled with the correct information, and remove the need to pull reports then manually consolidate them in Excel. For example a...

At the moment the only query reports we can run for how many sickness days have been taken, is a report that lists all the sickness occurrence. Therefore to get total numbers for each employee we have to calculate manually. Even though the total d...

Adding a filtering field for Admins and Managers on 'Date Last Opened' alongside the existing Name, Description and Category will allow for easy tidying up of unused Queries.

You cannot currently build a query that shows if an assignment is part of an approved timesheet. We currently have staff that do assignments but dont send them for approval. The timesheet and assignment can still be approved but when reporting the...

It would be really useful to be able to run a report showing all the changes that we have made on PHR within a specified time frame.

I often have queries that I need to write, especially for Ripples, where I don't have the flexibility I need in the query builder. I need an IS NOT option i.e. the date was not yesterday or today, and I need a weekend option i.e. the date was not ...

Access Workspace is built around their Access Data Engine (ADE) allowing you to build Analytics within workspace to combine data from multiple Access and 3rd Party applications and present this consolidated data to selected individuals. It seems t...

Please could there be an option created to only bring back the most recent record on a logbook query. This would make it so much easier to report on something like someones pension record in the logbook section, only bringing back the most recent ...