query_cached_result
Retrieve and manipulate cached query results by sorting, filtering, and paginating without re-running the original query.
Instructions
Re-query a cached tabular result with different sort/filter/pagination.
Use list_cached_results to find available cache keys. This tool lets you paginate, sort, and filter previously computed results without re-executing the original query.
Args: cache_key: The cache key from a previous query result. sort_by: Column name to sort by (e.g., "Image.CDR"). sort_desc: Sort descending if True. filter_col: Column name to filter on. filter_val: Value to filter for (substring match, case-insensitive). limit: Maximum rows to return (default: 100). offset: Number of rows to skip for pagination.
Returns: JSON with columns, rows, count, and total_count.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| offset | No | ||
| sort_by | No | ||
| cache_key | Yes | ||
| sort_desc | No | ||
| filter_col | No | ||
| filter_val | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |