Skip to Main Content
PeopleHR Ideas Portal
ADD A NEW IDEA

Queries/Reporting

Showing 104

Query to extract in the order your sort it

Please can queries extract into excel/csv in the column order that you sort it on PeopleHR. It is really annoying when doing reports that you have to sort the columns in the order you need them outside the system. It would be so much easier to be ...
Hannah Dougherty 4 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 25 days ago in Queries/Reporting 0 Open for Voting

Query on Outstanding Tasks!

It is not currently possible to produce queries or reports on tasks that have been created in People HR. It is also not possible to explort the task data manually via Excel or any other method.
Stuart Millington 5 months ago in Queries/Reporting 0 Open for Voting

Sickness Queries to include Long Term Sick Cases without having to run a separate query

Currently, if you run a report on sickness in the previous month, it will not include the long term cases that have not commenced in the previous month but are still ongoing during that month. The only workaround is to complete separate queries fo...
Carina Pieries 10 months ago in Queries/Reporting 2 Open for Voting

Separate column for holidays in Timesheet Summary Report

Currently when running the timesheet report, the summary report will combine hours worked and holiday hours together to show Normal hours. It would be beneficial to have this split into time worked and holiday hours. This can be beneficial for man...
Matthew Temperton 30 days ago in Queries/Reporting 0 Open for Voting

include manager ID/employee number on reports as well as colleague's.

We would like reports run to include the line manager/direct report's ID/employee number as a field, as well as the colleagues ID/employee number. At the moment, for a number of reports that include the manager, we are adding this manually.
Rachel Atack 30 days ago in Queries/Reporting 0

Changes Report

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.
Guest 17 days ago in Queries/Reporting 0

Add in an hourly cost of absence for reporting.

Given that our calculations are based on hourly metrics, having the capability to generate a report displaying the hourly cost of absences would be highly advantageous.
Sarah Lynch 5 months ago in Queries/Reporting 0 Open for Voting

In Queries, stay on category when you come out of query

When you are in queries, you choose the category and click into a query. However, when you come out of the query it take you back to the 'all' list of queries. It would be better if it stayed on the category when you came out of the query you clic...
Rosie Hodson 4 months ago in Queries/Reporting 0 Open for Voting

Is it possible to have an audit field in logbook to identify when a record changed/deleted?

We know that the training logbook had an out of date "training event" for an employee and needed to be renewed - it was there when we ran a report. A few weeks letter when we ran the same report the out of date "training event" had been deleted bu...
Guest 6 months ago in Queries/Reporting 0 Open for Voting