Inventory Management System - XPath Query List

This file identifies all XPath queries used across the system’s XSLT stylesheets to handle data calculation, filtering, and display.

Dashboard Summary Queries (status.xsl)

These queries are used to calculate the high-level metrics shown in the summary cards.

• Total Item Count count(//inventory:item) Calculates the total number of items in the database.

• Available Stock Count count(//inventory:item[inventory:status='Available']) Filters and counts only items marked as "Available".

• Low Stock Count count(//inventory:item[inventory:status='Low Stock']) Filters and counts items that are running low on inventory.

• Out of Stock Count count(//inventory:item[inventory:status='Out of Stock']) Filters and counts items with zero quantity remaining.

Category Aggregation Queries (status.xsl)

These queries work together to group items by their category and provide sub-totals.

• Unique Category Filter //inventory:item[not(@category = preceding::inventory:item/@category)] Identifies every unique category name by skipping duplicates.

• Category Name Retrieval @category Pulls the specific name of the category currently being processed.

• Items Per Category Count count(//inventory:item[@category = $currentCategory]) Counts how many items belong to the specific category stored in the variable.

Data Table Queries (table.xsl)

These queries are used to populate the main inventory list with specific item details.

• Main Table Iteration //inventory:item Targets all item nodes to create a repeating list of rows.

• Item Identity @id Retrieves the unique ID attribute for the item.

• Item Details inventory:name Retrieves the name of the equipment.

• Stock Level inventory:quantity Retrieves the numerical count of the item.

• Item Status inventory:status Retrieves the availability label for the item.

• Update Timestamp inventory:last_update Retrieves the date the record was last modified.