Version: #3692
New
Cloud9QL: LEAD() Function Added
A new LEAD() function has been added to Cloud9QL, acting as the opposite of LAG(), to retrieve values from future rows within a group.
Syntax:
LEAD(<field>[, offset[, default[, <grouping field(s)>]]])
This allows users to reference future values in a dataset for comparisons, trend analysis, or time-series computations. Optional parameters let you define the offset, default value if none exists, and grouping fields.
AI Recommendations API Endpoints
New API endpoints are now available for retrieving AI-generated recommendations directly from dashboards or widgets:
- GET /api/1.0/widgets/<widgetId>/insights/aiRecommendations
- GET /api/1.0/dashboards/<dashboardId>/insights/aiRecommendations
These endpoints return recommendation text generated by the AI service based on the selected widget or dashboard. Key details:
- Requires the AI service to be enabled for both the customer account and the user associated with the provided API credentials.
- Uses the default AI model configured for the customer (e.g., knowi-ai, gpt-4o, gpt-5, etc.).
- Only one widget or one dashboard is supported per API call.
User must have permission to access the asset and the selected AI model. - When used on dashboards, recommendations are generated based on the top 3 widgets with datasets present on the dashboard.
These endpoints allow external systems to retrieve and display insights programmatically using the same AI logic as the Knowi platform.