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.