Skip to Main Content
PeopleHR Ideas Portal
ADD A NEW IDEA

My ideas: Queries/Reporting

Showing 137 of 1393

Logbook Query - Field Order

When building a query to report on a logbook, the query shows the logbook fields in the order that they were originally created. If they have been moved around, it would still show in the order they have been set up in initially. This is not very ...
Michala Warren about 1 year ago in Queries/Reporting 0 Open for Voting

Queries: Please add 'yesterday' as a date filter and 'Not' as a conditional option

This would allow us to make better reports and ripples. One example is that I was trying to send out a ripple to anyone who didn't have a timesheet entry for yesterday but couldn't find a way to do this with the available filters.
Victoria Boyle about 1 year ago in Queries/Reporting 0 Open for Voting

Reporting - holidays - make the FTE figure (under planner settings)

It would be good to be able to report on this figure - as currently you can only do the available days, and sometimes these have been carried forward/ pro rated/ amended in some way.
Guest about 1 year ago in Queries/Reporting 0 Open for Voting

Holiday Authorisation Workflows & Reporting

The requirements / brief is as follows: 1. Creating a tool to be used to aid us in blocking holidays according to our new holiday policy. Our policy has created "Holiday Pools" and based on the number of employees in each pool, either 1 holiday sl...
Guest 8 months ago in Queries/Reporting 0 Open for Voting

Continuous Service/Length of Service being different for Joint Ventures.

We recently filled in the 'Continuous Service' section for all our employees on the system. As a result, we discovered that when we now view peoples length of service within the 'Employees' tab, it is pulling from the Continuous service data, rath...
Guest 8 months ago in Queries/Reporting 0

Query - Timesheets

We would like the possibility of creating a timesheet query considering when someone is on leave, sick leave or absent, including break time in order to be able to give us the missing times monthly.
Guest over 1 year ago in Queries/Reporting 0 Open for Voting

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 over 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