People Apps

(Admin Only) An in-depth view of filters and options for creating queries

Queries - Filters and Options

Queries - How to Create a Query

(Admin Only) Video and description detailing how to create charts within the query builder

Queries - Creating Charts

(Admin Only) Build a query that tells you when each employee has logged in to the system

Queries - Login Audit Report

(Admin Only) Build a report on how many days/hours entitlement pro rata.

Queries - Holiday Entitlement Accrued To Date

(Admin Only) Build a report on employee holidays

Queries - Holidays

Queries - TOIL

(Admin Only) Build a report on your employee's clock in and out information

Queries - Timesheets

Build a report on employee's yearly, remaining entitlement and carryover

Queries - Annual Leave Entitlement

(Admin Only) Build a report on Project Assignments

Queries - Assignments

(Admin Only) Build a report on Maternity/Paternity leave

Queries - Maternity/Paternity

Creating an expense report, exporting and printing.

Queries - Build an Expense Report

(Admin Only) Report on logbook information and/or logbook approval data.

Queries - Logbook

Report on employee's length of service and LOS rules

Queries - Length of Service

(Admin Only) Build a report on thanks badges

Queries - Thanks

Queries - Deleted Holiday

(Admin Only) Load Query Data Into Excel via Power Bi

People® Queries and Excel Power Bi

Queries - Goals

(Admin Only) Build a report on who has been late over a specific time period

Queries - Late Report

Queries - Deleted documents

(Admin Only) Build a report on other events

Queries - Other Events

Discover the true level (and cost) of your company's staff turnover rate.

Reports - Staff Turnover

(Admin Only) Build a report on documents added, signed etc.

Queries - Documents

Build a report on who had edit access rights

Queries - Edit Access Rights

(Admin Only) Build a report on training records

Queries - Training

(Admin Only) Build a report on performance reviews

Queries - Performance

Queries - Sickness

Queries - Leavers

(Admin Only) Build a query on Applicant/Vacancy information

Queries - ATS Reports

(Admin Only) Build a query on all salary changes

Queries - Historical Salary Report

(Admin Only) Build a query on changes made to an employee's record

Queries - Historical Changes Report

Using the 'Greater than' and 'Less than' options to report on information within a chosen point in time.

Queries - Filter by a Specific Time Frame

Report on the employees in the company at a specific time

Queries - Point in Time Head Count Report

(Admin Only)  Guidance on query building files imported to Microsoft Excel

Opening Query Builder Files in Excel

Sarah Mills

Edward Dixon

Sheldon Walker

The Query Builder

Login

4 Min Demo

Free Trial

News

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

{assigneeName} needs more information from you