Create queries

Queries are mechanisms to search/filter or get to your specific data faster. Hence, in the application, the powerful search box combined with the entity filter tag buttons should take care of most of the below queries (if not all).

This is a list of the queries that JJ thinks would be helpful to have in the app

1. Records by Office
• Input: Office Code (officenum)
• Output: All records for the selected office code

⸻

2. Individual Asset
• Input: Asset Number
• Output:
• Assigned To field
• Office Code field
• Status field
• Hardware field

⸻

3. All Assets
• Input: Asset Number field is not null
• Output:
• Office Code field
• All Asset Numbers
• IDIR field
• Assigned To field
• Status field
• Hardware field
• (Future iterations: Model, Warranty Expiry, Under-utilized Status, Refresh Asset Number, Refresh Order Number — possible dynamic link to the Asset Fleet Management Tool?)

⸻

4. Redeploy Asset
• Input: Assigned To = REDEPLOY
• Output:
• Office Code field
• Asset Number field
• Status field
• Hardware field
• (Same future fields as “All Assets” query)

⸻

5. Redeploy Asset by Office Code
• Input: Assigned To = REDEPLOY, Office Code
• Output:
• Office Code (specified)
• Asset Number field
• Assigned To field
• Status field
• Hardware field

⸻

6. Employees
• Input: Last Name, First Name OR Employee IDIR
• Output:
• Office Code
• Asset Numbers (including mobile phone)
• IDIR
• Status field
• Workspace Assignment
• Stream
• Sub Stream
• Job Title
• Ergo Equipment
• (Future iterations: Position Number, Software, CISB Equipment Bundle, G-car Driver, Employee Status: e.g., on TA, Leave, EITR, Site Contact)

⸻

7. Employees by Stream
• Input:
• Stream (selection from lookup list)
• Optional Filters: Office Code, Sub Stream, Job Title (if possible)
• Output:
• Office Code
• Asset Number
• Assigned To (≠ Null, REDEPLOY, Free Address, Vacant, Public JobBank Kiosk, Meeting Room)
• Status field
• Workspace
• Sub Stream
• Job Title

⸻

8. Workspace
• Input: Office Code
• Output:
• Office Code
• IDIR
• Assigned To
• Status
• Primary Monitor Size
• 2nd Monitor Size
• Monitor Support
• Workspace Number
• Office Floor
• Stream
• SubStream
• Job Title
• Workspace Category
• Desk Type
• Equipment

Note: Consider adding a dedicated Protected boolean field instead of overloading the SubStream field.

⸻

9. Unassigned Workspace
• Input: Assigned To = Free Address or Vacant
• Output:
• Office Code
• Assigned To
• Status
• Primary Monitor Size
• 2nd Monitor Size
• Monitor Support
• Workspace Number
• Office Floor
• Workspace Category
• Desk Type
• Equipment

⸻

10. Unassigned Workspace by Office Code
• Input:
• Assigned To = Free Address or Vacant
• Office Code (user selection)
• Output:
• Office Code
• Assigned To
• Status
• Primary Monitor Size
• 2nd Monitor Size
• Monitor Support
• Workspace Number
• Office Floor
• Workspace Category
• Desk Type
• Equipment