/
Queries 101 - Basics
Rough draft
Queries 101 - Basics
Table of Contents
- 1 Table of Contents
- 1.1 ⬜ Intro
- 1.1.1 🔵 What is a Query?
- 1.2 🟩 Anatomy of a Query Screen
- 1.3 🟩 Query Screens Overview
- 1.4 🟩 Personal Queries
- 1.5 🟩 Query Screen Options
- 1.5.1 🔵 Display Order
- 1.5.1.1 ⚫ Search Result Columns
- 1.5.1.2 ⚫ Ascending/Descending
- 1.5.2 🔵 Value & Operator
- 1.5.2.1 ⚫ Value
- 1.5.2.2 ⚫ Operators
- 1.5.2.2.1 ⚪ Intro
- 1.5.2.2.2 ⚪ Dates
- 1.5.2.2.3 ⚪ Null & Not Null
- 1.5.2.2.4 ⚪ Columns
- 1.5.2.2.5 ⚪ Users
- 1.5.2.2.6 ⚪ Other Examples of Operators
- 1.5.2.2.7 ⚪ Operators in Table Headers
- 1.5.2.2.8 ⚪ Comprehensive List of Operators
- 1.5.1 🔵 Display Order
- 1.6 🟩 Extra Credit
- 1.1 ⬜ Intro
⬜ Intro
Queries allow for users to search in AiM with a defined set of criteria. The search criteria fields contain operators that can be used to search records in different ways, such as “Starts with”, “Ends with”, or “Contains”.
Why will a Query help me? When using a database full of information you will want to retrieve very specific records. These records can be obtained by utilizing a query.
🔵 What is a Query?
🟩 Anatomy of a Query Screen
🔵 Basic Overview
🔵 Subordinate Tables (aka Supplemental Tables)
⚫ Query Screens with Multiple Tables
⚫ Display Order & Header Operations
🟩 Query Screens Overview
Below are detailed descriptions for navigating the screens found when creating a Query.
🔵 Starting a Search
🔵 Starting a New Query from a Record
⚫ Opening a Record
⚫ The Query Screen (for the Record Name Selected: E.g., Personal Query)
🔵 The New Query Screen
🔵 Query Results (aka Browse View)
🔵 How the Query Screen Looks After Saving 1+ Queries
🟩 Personal Queries
🟩 Query Screen Options
🔵 Display Order
⚫ Search Result Columns
⚫ Ascending/Descending
🔵 Value & Operator
⚫ Value
⚫ Operators
⚪ Intro
⚪ Dates
⚪ Null & Not Null
⚪ Columns
⚪ Users
⚪ Other Examples of Operators
⚪ Operators in Table Headers
⚪ Comprehensive List of Operators
🟩 Extra Credit
Now that you have studied all of the materials above, here is a video by AssetWorks to help you tie everything together.
Related content
Timecards (AiM)
Timecards (AiM)
Read with this
Asset Management: Replace or Dispose an Asset; Asset Status Changes; Attaching Component Assets
Asset Management: Replace or Dispose an Asset; Asset Status Changes; Attaching Component Assets
Read with this
Asset Reliability
Asset Reliability
Read with this
Personal Queries: Build, Save & Share
Personal Queries: Build, Save & Share
More like this
Asset Search, Work List Filters & Maps
Asset Search, Work List Filters & Maps
More like this
Team Scheduler - Supervisor (2023)
Team Scheduler - Supervisor (2023)
More like this