Using Query in HRIS

Table of Contents

• Introduction to Query    
  • Query Terminology
      Training Guide: Introduction to Query   
  • Navigate to Query Manager
      Training Guide: Introduction to Query   
  • Using Query Viewer
      
  • Add a Query to My Favorites Folder
      Training Guide: Add a Query to My Favorites List   
  • Rename a Query
      Training Guide: Renaming Queries   
  • Delete a Query
      Training Guide: Delete a Query   
  • Copy a Query to another User ID
      Training Guide: Copy a Query to Another HRIS User   
• Working with Existing Queries    
  • Search for an Existing Query
      Training Guide: Search for an Existing Query   
  • Run an Existing Query
      Training Guide: Run an Existing Query   
  • Modifying an Existing Query
      Training Guide: Modifying an Existing Query   
• Create a New Query    
  • Adding a Record
      Training Guide: Adding a Record   
  • Selecting Fields
      Training Guide: Selecting Fields   
  • Establishing Criteria
      Training Guide: Establishing Criteria   
  • Select Distinct, Save and Run the Query
      Training Guide: Select Distinct, Save and Run the Query   
• Building Complex Queries    
  • Working with Multiple Tables
      Training Guide: Working with Multiple Tables   
  • Using the Criteria Condition Types
      Training Guide: Using the Criteria Condition Types   
  • Using Logical Operators and Grouping Criteria
      Training Guide: Using Logical Operators and Grouping Criteria   
• Other Query Topics    
  • Creating Run-time Prompts
      Training Guide: Creating Run-Time Prompts   
  • Create and Add a Query to a Customized Folders
      Training Guide: Create and Add a Query to Customized Folder   
  • Chunking Criteria
      Training Guide: Chunking Criteria