Overview
The Data Transformation tool allows you to:- Query backend data using natural language
- Display results in interactive tables
- Filter and sort data dynamically
- Visualize trends and patterns
Natural Language Queries
Just ask in plain language:- Assets
- Inventory
- Maintenance
- “Show me all HVAC units”
- “List equipment in sector 3”
- “Find assets needing maintenance”
- “Display generators by status”
Generative UI Tables
Query results are displayed in rich, interactive tables:Features
Interactive
Click to expand, sort, and filter
Responsive
Adapts to screen size
Status Badges
Color-coded status indicators
Pagination
Handle large datasets
Column Types
- Text: Equipment names, descriptions
- Status Badges: Operational status with colors
- Priority Badges: High/Medium/Low indicators
- Stock Indicators: Red/yellow/green for inventory levels
- Dates: Formatted maintenance dates
- Links: Clickable references
How It Works
AI Processing
The AI:
- Parses your query
- Identifies the data type (assets/inventory/maintenance)
- Determines filters and sort order
- Calls the appropriate backend API
Data Retrieval
Backend API returns:
- Paginated results
- Metadata (total count, page info)
- Structured data objects
Backend Integration
Data transformation queries use the Backend API Service:Chat Tools Integration
The transformation is powered by chat tools:- consultar_activos - Query asset catalog
- consultar_inventario - Search spare parts
- consultar_mantenimientos - List work orders
- consultar_calendario - View scheduled maintenance
- consultar_reportes - Access maintenance reports
- consultar_proveedores - List suppliers
Advanced Features
Filters
Apply filters with natural language:- “Show only high-priority work orders”
- “Filter by location: Sector 3”
- “Display equipment manufactured after 2020”
Sorting
Specify sort order:- “Sort by date, newest first”
- “Order by priority, high to low”
- “Sort alphabetically by name”
Pagination
Handle large datasets:- Results shown in pages of 15 items
- Click “Load More” for additional pages
- Total count displayed
Example Queries
Asset Queries
Asset Queries
Inventory Queries
Inventory Queries
Maintenance Queries
Maintenance Queries
Related Documentation
Generative Tables
Table component documentation
Chat Tools
Backend query tools reference
Backend API
API service documentation