Skip to Main Content
PeopleHR Ideas Portal
ADD A NEW IDEA

Queries/Reporting

Showing 131

Audit report of queries created

Produce a report of all queries to show: name of the query who created the query date query created who last used the query date query last used We have a number of admins in the company and they can all create reports. This would be useful to tra...
Annette Attwell about 1 year ago in Admin / Queries/Reporting 0 Open for Voting

OtherEvents "Updated DateTime" & "Updated By"

Within the Querries the section "Holiday" offers "Holiday Updated DateTime" and "Updated By". We need the same thing for "OtherEvents". Here sadly both these data points are missing. As Otherevents are beeing approved and handled the same way as H...
Guest over 1 year ago in Queries/Reporting 0 Open for Voting

Add Query user Performance record to Performance Query reports

Bizarrely when you run a Performance related query as an Admin user, the preview and exported report will exclude any and all Performance records of the Admin user running the Query. Any other Query will include the Admin user records in the repor...
Dominique Saxelby over 1 year ago in Queries/Reporting 2

Most recent log book entry

Currently we get staff to complete a log book entry every 6 months. I wouled like to be able to run a report that shows the most recent log book only. I can filter by date but as some staff may not have completed a log book for a couple of years a...
Louise Sheen over 1 year ago in Queries/Reporting 0 Open for Voting

Option to set effective date to be in the future or the past

If there was an effective date field, it would mean that whenever you were looking at anything it could either be from the perspective of today which should be the default position, or you could put a different date in to show what the organisatio...
Claire Harrison over 1 year ago in Admin / Queries/Reporting 0 Open for Voting

Add a changed since date on report filtering

When building a report would be useful to add a filter for "change made since" or similar. Looking to get regular reports for changes to personal details added by employees which can then be provided to other departments for their updates.
Rachel Boyce over 1 year ago in Queries/Reporting 1 Open for Voting

Merging queries created for planner all into one spreadsheet on one tab

Creating a report that fulls all data for every employee per day onto one spreadsheet in one tab. If you have an employee in one month off sick, in work, unpaid time off, on holiday you have to create 4/5 queries then merge together but they still...
Amanda Riley over 1 year ago in Queries/Reporting 0 Open for Voting

Be able to view Line Manager's ID numbers in queries

Ideally we would like to be able to run queries giving us: An employee & their ID number. Their line manager & their ID number. This would be useful when exporting this information to use in other applications. For example, when creating a...
Ross Chaplin 9 months ago in Queries/Reporting 0 Open for Voting

Annual Leave Comments

It would be really useful, that when running reports or queries you can see the reasons added instead of having to go into each individual and click on the clock to see changes
Kirsty Patrick over 1 year ago in Queries/Reporting 0 Open for Voting

Show percentages on reports

Can you add the percentage for less than 2 years service on the top facts report
Guest over 1 year ago in Queries/Reporting 0 Open for Voting