Skip to Main Content
PeopleHR Ideas Portal
ADD A NEW IDEA

Queries/Reporting

Showing 108

Improvement to Excel download from Queries

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...
Claire Harrison over 1 year ago in Queries/Reporting 0 Open for Voting

Better History Options on Queries - Ability to add custom date range for all queries

Need to do a report on FTE and have been told this isn't possible. Would be great to have custom date range as an option for any query
Leanne Barlow 6 months ago in Queries/Reporting 0 Open for Voting

change the wording of the automatic email about a logbook

Add more information to the automatic email about logbooks that need to be authorised (name, date, link to the logbook)
Guest 6 months ago in Queries/Reporting 0 Open for Voting

Have insights in the email for all other events

Add the other events according to leave / working other events to the impact insights in the email sent for approval, event if all the employees only on Other events and no-one is on holiday.
Guest 6 months ago in Queries/Reporting 1 Open for Voting

FTE reporting

We currently use PHR for reporting on headcount and this includes reporting of the FTE for part-time workers. At the moment we use the salary area, but use the deduction tab to show they work part time. We have come into problems as we are integra...
Joann Sprules 6 months ago in Queries/Reporting 0 Open for Voting

Check whether an event has supporting documents or not

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.
Keren Landsman 9 months ago in Queries/Reporting 0 Open for Voting

Adding 'Date last opened' on queries page.

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.
Deveena Dissanayake 10 months ago in Queries/Reporting 0 Open for Voting

Showing an assignment as approved if timesheet approved

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...
Guest 10 months ago in Queries/Reporting 0 Open for Voting

Query to have a most recent record option

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 ...
Hannah Dougherty 11 months ago in Queries/Reporting 0 Open for Voting

Need more options on queries such as IS NOT and the ability to filter on weekend dates

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 ...
Victoria Boyle 8 months ago in Queries/Reporting 0 Open for Voting