Skip to main content

Create queries

Everything you need on reporting in the system.

Use filters in queriesHow can I make the correct filters for my report.
Specific point in time headcount reportReporting on how many employees I have at a specific date.
Query on remaining allowance at a certain point in timeCreate a report on annual leave allowance and the leave remaining at a certain point in time.
Create a query on historical salary informationCheck salaries for a certain point in time.
Create a query on public holidays included in entitlementCreate a query on public holidays included in entitlement.
Create a queryHow to create my reports.
Any other queries you can create

More examples and ideas of queries you can create.

Create a query on tasksCreate a report on outstanding tasks.
Create a query for logbooksReport on logbook information and logbook approval data.
Create a query on performance reviewsHow to create a query on performance.
Query on documentsHow to create a query on documents.
Query on other event entitlementsHow to export a report focusing on Other Events within the planner.
Create an audit login queryWho has logged in on a specific day.
Query on job role historyHow can I see a list of job role changes.
Build a query on applicants and vacanciesBuild a query on ATS to generate a report.
Query on applicant's scorecards answersCreate a query or a report on scorecards.
Query on hired applicantsCreate a query to show all hired applicants.
Query on applicant questions and answersCreate a query to review applicants' answers.
Create a query on deleted holidayHow do I report on deleted holidays.
Create a query on assignmentsHow to report on project assignments.
Query on a logbook request informationHow do I know when a manager added a logbook.
Create a query on paid sick leave in the last 12 monthsHow to create reports which show us exactly how many paid sick leave each employees had in the last 12 months.
Query on salary entitlements and deductionsReport on salary entitlement and deductions.
Create a query on emergency contact detailsHow do I report on emergency contact information.
Create a query on length of serviceHow do I report on an employee's length of service.
Query on deleted documentsAn admin deleted a document but we can find no trace of it.
How to create a query on birthdaysHow to create a list where all user's birthdays can be seen.
Query on Full Time EntitlementsHow to extract Full Time Entitlement Holiday for all employees in queries.
Query on who has added leaves for an employeeHow can I see who has inputted some absence for an employee.
Query on deleted recordsRecords are not showing in the Leaver tab.
Create a query on user rolesHow do I create a Query on user roles.
Query on manager and additional managerCreate a query that shows all those who are managing employees.
How to create a query on declined holiday requestsSeeing employees' declined holiday requests.
Query on the worked daysHow to calculate the worked days.
Query on how timesheets were recordedHow to source whether a timesheet was added using virtual clock or manually.
Create a query to see all employeesIs there a way to export a list of all employees in Excel.
Create a query for trainingHow do I build a report on training records.
Create a query for employees addressesHow to create a query report to show all my employees addresses.
Create a query on probation end date or statusCreate a report on which employees' probation is ending soon and to check their probation status.
Create a query on Logbook signature IP addressesHow to create a query on Logbook signature IP addresses.
Create a query for out of date passportsHow I can set the query to pull all out of date passports.
Create a query on thanks badgesHow to report on thanks badges.
Query on users with Manager access levelHow to create a query that filters on all users who are managers.
Query on who created employee recordsHow can we see all the changes which were made to the system such as adding users.
How to create a query on declined other event requestsHow to create a query on declined other event requests.
Query on employee starting dateTrying to pull a report for employees who have been at the company for a specific year.
Data check queryHow to check for bad or missing data.
Create a query on length of service profilesSee which LOS profile the users are assigned to.
Build a report on leaversHow do I see all of my leaver documentation.
Create a query for goalsGenerate a report to show goals.
Create query on holiday request approval dateCreate a query on when was the holiday authorised.
Create a query on in use job rolesHow can I find out what Job roles are in use so I can delete them after.
Query on analysis codesReport on analysis codes.
Query on employees who didn't start performance reviewsHow to run a report to see who has not started their performance review.
Query on bank details changesHow to run a report on Bank information Changes, and exclude the new starters.
Query exporting by API error - 'Please try after some time...'When exporting the query it presents with 'Please try after some time, query execution is already in progress.'
Create a query on deleted sickness daysReport on deleted sickness days.
Create a query on bank detailsCreate a report for bank information.
Create a query for the average time the jobs are open for on the ATSHow would I find out the average time our jobs are open for on the ATS via a query.
Talent Pool queryHow do I pull a report with details of candidates who are part of our talent pool in the ATS.
Query on overtime requestsQuery on who has submitted overtime that has not been approved or rejected.
Query on users who don't have a document uploaded under a certain categoryHow to build a query on users who don't have a document uploaded under a certain category.
Create a Daily Absence Cost queryI'm sure there was an option to include the daily cost of absence on a custom report, I can't find the tick box as an option. Can you please advise.
Create a query for annual leave entitlementRun a report for the remaining holiday of this year.
Create query on sicknessCreate a query that shows the total number of days sick a staff member has had in one year.
Create a query on expensesHow do I make a report about expenses?
Create a query on work patternsCreate a report to show employees work patterns.
Create a query for holiday entitlement accrued to dateBuild a report on how many days or hours entitlement pro rata.
Create query on Pulse SurveysHow can I view the results for Pulse surveys.
Create a query on other eventsQuery on other events.
History of changes for additional managerIdentify when a change has been made to a profile by additional manager.
Report on the current and previous salaryHow to create a report to compare the current salary employees have and the last one before.
Create a Bradford Factor queryCan I create a query to see the most recent absences for Bradford Factor.
Common issues and questions about queries

guides to help combat issues with queries.

Duplicate results in a queryWhy is my report showing duplicated names.
Query not showing the correct resultsThe query is pulling a holiday record that was deleted before it was ran.
Fields within the Personal tab are not showing when creating a queryFields within the personal tab are not being shown when trying to create a query.
ATS query fields explainedThe difference between "Added by" "Moved by" and "Applicant updated by" in ATS queries.
Query showing leavers after unticking Include Leavers optionReport pulling through leavers incorrectly.
Contracted hours vs. working hours are not correct in the queryIf I pull a report showing working hours, for those who have a two-week rotating pattern it sums the hours.
Logbook Query is showing blankWhen running a query on a logbook, it's not showing any results.
Sickness not showing in querySickness not showing in hotsheet.
Can you edit the query for Moorepay?Can you add more fields to the Payroll : Moorepay Core Extract query.
Error: 'Ooops something went wrong' when trying to edit queryI cannot edit my query as 'Ooops something went wrong' pops up.
Can we report on multiple areas of the system in one query?Can I report on contracted hours, holidays taken, sick leave and other events in one query.
Field missing from logbook queryField missing from Vehicle Details logbook query.
Users can see queries they shouldn't be able toMy employees have the HR Admin tab on Access Button and they can see all queries.
How to stop queries remindersHow can I turn off queries reminders.
Bradford Factor is blank in queriesBradford Factor score shows zero or blank on queries
How to group by column name in queriesIndividually grouping columns on queries.
How can the reminders within queries be sent out via emailSent query reminders via email.
Incorrect goal updated date in queriesGoals not showing as updated within queries.
Job role history queries pick up different informationWhen reporting on changes in job titles and job role changes, I receive different information.
HTML code appears in exported queries in ExcelText comments entries from PHR to excel spreadsheet is showing html formatting when displayed in spreadsheet.
Assignment Locked Date and Time in queriesWhat do the Assignment Locked Date and Assignment Locked Time fields in queries mean.
Exclude employees with specific job role from queries resultsHow to exclude employees with specific job role from queries results.
Bank holidays are not showing in the queryWhen running a holiday report, it does not pull across the bank holidays for the entire year.
Change the format of the date field in the exported queriesChange the format of the date field in the exported queries.
How to exclude future starters in queriesSet up a query to exclude future starters.
Queries were not created by admin, who created them?We have noticed 2 queries that have not been created by admin.
Query being slow and not openingThe query keeps circling and takes too long to open.
Blank queryMy query is showing blank.
Holiday query showing incorrect informationHoliday balances report doesn't match the information within the employee's planner.
Why can't I edit a query?Query edit and settings are not there.
No results showing in a queryQuery not pulling any information.
Can I query on documents attached to logbooks?Is there ant filter for logbook on whether file is attached or not.
Performance query does not show users who have not started the reviewPerformance query does not show users who have not started the review.
Holidays showing on reports but not on the plannerReport showing an annual leave, however there is no annual leave entry for that date on Planner.
How can I report on the latest logbook only?Query on latest logbook without including historical information.
Opening Query Builder Files in ExcelExcel file shows incorrect data when exporting.