Common issues and questions about queries
guides to help combat issues with queries.
By Robert1 author38 articles
- Duplicate results in a queryWhy is my report showing duplicated names.
- Query being slow and not openingThe query keeps circling and takes too long to open.
- Blank queryMy query is showing blank.
- Query not showing the correct resultsThe query is pulling a holiday record that was deleted before it was ran.
- Holiday query showing incorrect informationHoliday balances report doesn't match the information within the employee's planner.
- 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.
- Assignment status showing blank in queryAssignment status is pulling through as blank for a user.
- Change the format of the date field in the exported queriesChange the format of the date field in the exported queries.
- Why can't I edit a query?Query edit and settings are not there.
- 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.
- 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 can I report on the latest logbook only?Query on latest logbook without including historical information.
- No results showing in a queryQuery not pulling any information.
- 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.
- How to exclude future starters in queriesSet up a query to exclude future starters.
- Opening Query Builder Files in ExcelExcel file shows incorrect data when exporting.
- 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.
- 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.
- Can you edit the query for Moorepay?Can you add more fields to the Payroll : Moorepay Core Extract query.
- Bank holidays are not showing in the queryWhen running a holiday report, it does not pull across the bank holidays for the entire year.
- 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.
- 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.
- HTML code appears in exported queries in ExcelText comments entries from PHR to excel spreadsheet is showing html formatting when displayed in spreadsheet.
- Can I query on documents attached to logbooks?Is there ant filter for logbook on whether file is attached or not.
- 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.
- 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.
- Queries were not created by admin, who created them?We have noticed 2 queries that have not been created by admin.
- Field missing from logbook queryField missing from Vehicle Details logbook query.
- Performance query does not show users who have not started the reviewPerformance query does not show users who have not started the review.
- Find reviews that haven't startedSee which employees haven't opened their performance review yet.