Version #4196
New
- Query Category Management (3673): Query categories can now be created, renamed, deleted and reorganized from a slide-in panel with drag-and-drop filing, nested categories and search, and a single query can be filed into multiple categories.
- CASE Statement - Aggregations (4540): SUM, AVG, COUNT, MIN and MAX can now be used in the WHEN, THEN and ELSE clauses of a CASE expression, respecting existing GROUP BY behavior.
- RAND() Function (4051): A new RAND() function in Cloud9QL generates random numbers for building sample and demo datasets.
- Facebook & Instagram - Post Insights (4545): Post Insights collections are now available on the Facebook and Instagram connectors, with the Facebook Page access token resolved server-side from a Page picker on the datasource.
- Support for the Latest OpenAI Models (4557): GPT-5.6 (Sol, Terra, and Luna) and GPT-5.5 are now available with a reasoning effort selector, and deprecated models including o3 and GPT-5 Chat have been retired across all AI features.
- Management API - Report Pause & Unpause (4542): Management API now supports pausing and unpausing reports.
- Dashboard Setting - Filter Icons (4547): The dashboard setting is now named 'Filter Icons' and hides only the dashboard and widget filter icons, leaving the dashboard filters visible. The 'filter' JS API parameter matches the same behavior.
- Copy Visual Builder C9QL (3690): For C9QL created via the drag and drop visual builder, you can now copy the C9QL code to your clipboard.
- Redirect to Link After Sign-In (4538): Opening a Knowi link while signed out now returns you to that link after sign-in instead of your default dashboard.
Fixes
- Repeating Recommendations (4551): When the data fits within the model's context window, chunking is skipped so the Recommendations widget no longer repeats the same recommendation on a loop.
- Widget Agent & AgenticBI Improvements (4555): Documentation answers are now scoped to Knowi, widget chart-property and axis formatting requests route to real settings updates, and clarification answers are no longer dropped.
- Field Data Format Reverting (4536): Editing a previously formatted field in widget settings no longer resets the data format on other fields.