Create queries
Everything you need on reporting in the system.
By Joshua1 author120 articles
- 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.
- Filter by a specific time frameFilter a query by a specific time frame.
Timesheets and absence reporting
Reporting strictly on absences and timesheets.
- Create a query for employee holidaysCreate a report showing employee holidays.
- Create a query on outstanding sick return-to-work formsReport on who didn't complete the sick return to work form.
- Create a query on latenessReport on who has been late over a specific time period.
- Create a timesheet queryCreate a report about timesheets.
- Run Activity Report pluginOverview of all employees' working days.
- Run a report on public holiday templatesHow to run a query on the public holidays templates employees are assigned to.
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.
- Create a query on maternity and paternity leaveRun a query on maternity and paternity leave.
- Create a query on historical changesReport on historical changes within the system.
- Report on the areas granted via access rightsCheck which areas users have access to.
- Run a report on TOIL balanceCreate a query on used TOIL.
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.
- Assignment status showing blank in queryAssignment status is pulling through as blank for a user.