Release history
Latest version
| Service | Docker Image |
|---|---|
| Datagrok | datagrok/datagrok:1.27.3 |
| Grok Connect | datagrok/grok_connect:2.6.2 |
| Grok Spawner | datagrok/grok_spawner:1.15.0 |
| Jupyter Kernel Gateway | datagrok/jupyter_kernel_gateway:1.30.0 |
See also:
2026-04-27 Datagrok 1.27.3 release
Platform
- Auth:
- Added configurable SAML Entity ID for Azure AD integration
- Infrastructure:
- Helm: Introduced per-service Secret overrides with autogenerated credentials, plus a unified chart with IRSA support for S3 storage
- Datlas: Added the POST /docker/token endpoint for Docker OAuth2 refresh flow
- Datlas: Implemented RDS IAM passwordless authentication for PostgreSQL with SigV4 token generation and pool refresh
- Spawner: Improved support for huge Docker images
- Spawner: Now resolves the Docker registry via Kubernetes API
- Fixed:
- Groups: Properties dialog no longer resets deduplicated group names; saving group relations no longer raises a false 'duplicate name' error
- Projects:
- #3655 Introduced passing parameter values via URL
- Creation script editor: Added syntax verification
- Fixed:
- Query parameter edits now persist with the project on save
- Table view: Refreshing a left join with an in-place table no longer produces UI errors
- Multi-choice inputs: Cascading refresh, progress indicator, and styling now work correctly
Viewers
- Filter Panel: #3731 Added hierarchy search in hierarchical filter
- Correlation plot: #3400 Implemented row name pinning
- Fixed:
- Trellis plot: Inner viewer settings now persist on query re-run, and refresh errors are resolved
- #3692 MMP: Trellis plot Summary viewer now displays all values
2026-03-26 Datagrok 1.27.2 release
Improvements:
- Snowflake: Introduced JWT authentication support
- Scatterplot: Added a configurable tooltip delay setting for improved hover behavior
Fixed:
- Projects: Relations now load correctly after a plugin version upgrade
- Bar Chart: Relative values indicators now display correctly
- Trellis plot: Copying a project containing a trellis plot no longer causes errors
2026-03-20 Datagrok 1.27.1 release
Improvements:
- Implemented EKS Pod Identity support
- Filter Panel: Introduced radio mode for categorical filters
- JS API: Exposed ColorPicker.show() method for displaying a color picker without a DOM element
- Scatterplot: Improved WebGPU rendering performance
Fixed:
- Trellis plot now restores correctly when Data Source is set to
Selected - Grid tooltip no longer exposes blurred columns
- Summary columns now display correct names
2026-03-12 Datagrok 1.27.0 release
The Datagrok 1.27.0 release introduces AI-powered features, brings improvements to visualization, strengthens access control and analytics, and delivers a range of usability enhancements.
Breaking changes
This release introduces non-backward-compatible database changes. You can upgrade to version 1.27.0 automatically; however, once the database is migrated, older versions (including 1.26.8) will no longer be compatible. If you need to roll back to 1.26.N, you must manually revert the changes or restore a pre-upgrade backup.
JS API:
- Renamed:
TableView.refreshrenamed toTableView.reloadData- Viewer field
saveZoomrenamed tosaveWithData
- Changed:
- Canvas viewer viewport accessors moved from
CanvasViewerMixintoCanvasViewportMixin - Removed unnecessary fields from
IInputInitOptions
- Canvas viewer viewport accessors moved from
- Pie chart label properties restructured: added
showValueand renamed existing label-related properties - Deprecated
fetchProxy. Usefetchorgrok.dapi.fetchProxyinstead
Packages: Function tags (such as app, viewer, fileViewer, fileImporter, panel) are now migrated to the meta.role property. If your package uses //tags: to declare function types, switch to //meta.role: instead
Main updates
- AI-powered semantic search now lets you find connections, queries, scripts, projects, and other platform entities using natural language. Requires a configured AI provider endpoint
- AI-assisted query and script generation: ask questions in plain English and get SQL queries or scripts generated automatically, without writing code. Requires a configured AI provider endpoint
- Database metadata annotations let you add context to databases, schemas, tables, and columns — descriptions and hints that improve AI query generation accuracy and enrich query results for your team
- Dataframe metadata annotations preserve the link between query results and their source tables, so downstream analysis always knows where the data came from
- Data enrichment lets you pull in additional columns from related tables without writing SQL — Datagrok infers joins automatically so you can extend any dataset in one click. For details, see Data enrichment
- Roles give administrators a structured way to define access levels and assign permissions to groups of users at once, simplifying access management across the platform
- Projects are now more resilient to changes in their underlying dependencies (queries, scripts, etc.). A new Creation Script editor lets you fix and retry the script without reopening the project
- Script layouts let you save and restore viewer configurations, column coloring, and styles alongside your script, so your analytical setup is always ready to reuse
- Scheduled function impersonation lets you specify which user a scheduled function runs as, giving you finer control over permissions and audit trails
- Click tracking gives platform administrators usage analytics based on user interactions across the UI
Platform
- AI
- Introduced Anthropic AI provider
- Access control
- Improved role permissions management with a new permissions editor
- Improved global permissions with granular entity permissions, see Global permissions for details
- #3457 Introduced AzureAD cert-based authentication support
- Search
- Introduced entity fuzzy search in card views
- Enabled embeddings-based semantic search for entities in data source card views
- Scripting
- Introduced multi-selection choices for list
<string>in all scripting languages - Introduced files input with multiple file selection support
- Extended R environment support for custom conda environments
- Autogenerated OpenAPI, Python, and JS API clients
- Introduced multi-selection choices for list
- Data
- Enabled boolean to numeric column conversion
- Added support for a new datetime format:
Thu Jan 8 17:17:25 2015 +0000 - Introduced the
Rendererproperty for columns (editable in column context panel)
- Infrastructure
- Enabled Google IAP support
- Exposed
isPinnedgetter andpin()method for views - #3395 Enabled calling
DG.FuncCallfrom Pyodide scripts
- Fixed:
- #3550: Renaming the Query after it's been used in a Project now updates the script
- #2837: Column properties maintained when Project is reopened or Layout applied
- #3637: Projects can now be saved as ZIP in all cases
- #661: Tooltips now allow hovering over clickable links
- #3215: CSV parser: JSON fields with empty values no longer break parsing
- #3470: Error when using Pivot Table and Link Table together
Data Access
- Visual Query: Enabled joining tables from different schemas
- Introduced database catalogs support with enrichments
- Enabled Databricks federated token exchange and schema browsing
- Implemented data query post-processing progress indication
Browse
- Breadcrumb now shows full navigation path
- Introduced filter panel for data source card views
- Improved files view with paginated list and recursive search
- Fixed:
- #3668: Scrolling in plugin Credentials frame
JS API
-
Views and UI:
- Added
Shell.previewgetter/setter - Added
Shell.projectsandProject.addTableView - Added
ui.icons.spinner,ui.icons.loader, andui.iconSvg - Added
WidgetDescriptorandTreeNode.icon
- Added
-
Inputs:
- Added
DG.MultiChoiceInput
- Added
-
Data:
- Added
DataFrame.toArrowmethod - Added
BitSet.fromBase64andBitSet.toBase64methods - Extended
DG.Color.scaleColorwithbelowandaboveparameters
- Added
-
Other:
- Added
log.onLogto listen to logs - Added
usergetter forDG.Group - Added Spaces API, Filter base, and catalog parameters
- Added pinned columns API methods
- Added
DataSourceandDataQueryView - Extended
EventArgs - Exposed
LogEvent.eventTypeand other fields - Renamed
TableView.refreshtoTableView.reloadData
- Added
Viewers
- Introduced annotation regions for scatterplot and line chart viewers, enabling data markup with shapes, formulas, polygon areas, and visual indicators directly on plots
- In-viewer filter expressions can now be edited in the new Edit Formula dialog, see In-viewer Filter updates
- #3394: Enabled changing the font size of axis titles (column names)
- #3444: Introduced font property for viewers to change both font name and size
- #3356: Viewer parameters now persist data-specific state (e.g., zoom coordinates)
- #3530: Introduced option to export CSV with UTF-8 BOM
- Correlation plot: #3500: Enabled adjusting text size of column and row names
- 3D Scatterplot: #3594: Introduced support for categorical (string) values on axes
- Pie chart: Introduced the Show Value property and automatic external labels, see Pie chart updates
- Confusion matrix: visual improvements (text color, borders, layout)
- Viewers now save zoom state by default
- Column selectors: columns can now be selected by typing the name and pressing ENTER
- Fixed:
Grid
- Introduced new grid options, for details, see Grid updates:
- Color one column's values based on another column (Linked color coding)
- #3568 Blur rendering option for columns to enable safe screenshot sharing in external presentations
- #3607: Added the ability to change the type for multiple columns at once
- Completely rewrote pinned columns to address long-standing reliability issues
- Multiline header display now splits by word boundaries based on content
- Added the ability to display a friendly column name underneath the original column name
- Fixed:
Scatterplot
-
Introduced new scatterplot options — for details, see Visualization-related updates:
- #3613: Show Selected Rows property
- Axis histograms
- Interactable regression statistics
- Lines By property for independent line series grouping
-
Introduced font size customization for formula lines
-
#3179: Regression lines now show Root Mean Square Error and Spearman/Pearson correlations
-
#3489: Enabled regression line coloring customization
-
#3575: Enabled selecting specific markers for categories in legend
-
Fixed:
Line Chart
- #2967: Enabled hiding X axis points with no corresponding data on Y axis
- #3575: Enabled marker icon support
- Added whisker width option
- Added axes grid lines
- Added Y axes context menu
- Introduced common context marker menu with marker by color
- Marker opacity now adjusts based on whisker visibility
- Implemented SPC (Statistical Process Control) lines with rules and bounds
- Fixed:
Bar chart
- #3573: Introduced scroll bar and min/max settings for value axis
- Introduced value axis context menu
- Fixed:
Histogram
- Added distribution lines with spline support
- Added Show Values setting to display the value on top of each bin
- Added
minandmaxproperties to control the displayed range
Box plot
- #3455: Enhanced statistics panel
- #3450: Category column width now adjusts to font size for two X axis
- #3643: Added Zoom Values By Filter for the Y axis, see Box plot updates
- Fixed:
- #3469: Column selected for coloring no longer changes when axis column changes
Trellis plot
- #3502: Introduced inner x and y axes sliders with inactive axes
- #3652: Heatmap: enabled color-coding based on grid column coloring and added heatmap color scheme option, see Trellis plot updates
- Summary viewer now displays values when two or more columns are selected
- Sparklines: Introduced legend and tooltips
- Introduced properties to hide axis lines
Filter Panel
- Added Multi-value filter for columns with multi-value cells
- Added the ability to switch between numeric and categorical filter types
For details, see Filters updates.
Packages
Bio
- Antibodies: Introduced support for numbering schemes, highlighting, alignment, liabilities detection, and region extraction
- Monomer collections view with improved handling of R groups
- Introduced isotope support in monomers
- Enabled complex R-groups in monomer libraries
- Custom notation provider support with HELM workflow
- CHEMS and SMILES support in HELM
Chem
- MPO :
- Implemented profile management: added ability to create, clone, delete, import, and export profiles
- Added breadcrumbs for navigation
- Introduced aggregation as part of the profile definition
- Added highlighting of matching profiles in the profiles input
- Added radar plot checkbox for adding it to the grid
- Added pMPO-generated demo profile to the Chem folder
- #3658 Scaffold Tree: Added support for custom labels
- Added BitBIRCH clustering for O(N) incremental molecule clustering
- Implemented Synthon search
- Added explicit SMILES setting for sketchers
- Moved Generate Conformers to the Calculate menu
- Introduced Reaction Toolkit with initial UI and improved reactions editor
- MMP: Improved data rendering for molecule pairs in the context panel
Charts
- #3483: Radar in-cell renderer: Enabled multiple columns edit in column grid
- #3524: Radar viewer: Added options for axis scale
- Sankey: introduced support for color-coding nodes and links
- #3221: Tree viewer: configuration to hide overlapping labels
- Sunburst: added collaborative filtering
DiffStudio
- Implemented new ODE solvers: Bogacki-Shampine 3(2), Runge-Kutta-Fehlberg 4(5), Dormand-Prince 5(4)
- Added Adams-Bashforth multistep predictor-correctors of order 4 and 5
- Added LSODA, CVODE automatic stiffness detection solvers
EDA
Probabilistic multiparameter optimization (pMPO) enhancements:
- Added support for both numeric and categorical desirability columns
- Introduced automatic parameter tuning for streamlined configuration
- Added option to run pMPO without sigmoidal correction
- New ROC curve and confusion matrix visualizations for model evaluation
Grokky
- Introduced Anthropic AI provider support
- Added Azure-compatible AI client
- Added AI API providers abstraction layer
- Implemented entity embeddings for semantic search
- Introduced scripting AI capabilities
Power Grid
- Pinned columns functionality has been moved to the platform core and no longer requires Power Grid to be installed
- #3654: Introduced Confidence Interval cell renderer (see also Grid: Summary columns)
- #3653: Introduced Stars cell renderer
For details, see Grid updates
Power Pack
- Implemented the Activity Dashboard widget with tips of the day, demos, tutorials, and recent entities
- Add new column dialog: Added case-insensitive packages search for hints
- DBExplorer: Added semantic type handling
- Removed the Recent Projects widget
Usage Analysis
- #3213: Introduced Projects tab
- Implemented click tracking with elements inspect
Curves
- Curves: Added MSR script
- Data-to-Curves:
- Added well-level additional columns support
- Added joining options
- Fully covered script with history, datasync, and 2-tier support
- MultiCurveViewer: Added
legendColumnNameproperty - 4PL dose-response: Added 4PL dose-response curve fitting function
Peptides
- Introduced the sequence mutation cliffs viewer with support for current row tracking
- Enabled full filter reactivity for all panels, tooltips, aggregations, and viewers
- Reworked mutation cliffs and tooltips, showing information about sequence pairs and their statistics
- Added sum columns for the sequence variability map viewer
- Removed target column for peptides analysis
- Fixed:
- Corrected aggregate calculations, statistics, and mean difference comparisons
- Fixed premature shutdown of MCL viewer on loading
- Fixed distribution tooltips not showing on WebLogo hover
Dendrogram
- Hierarchical clustering:
- Added ability to assign clusters by number or threshold (see Cheminformatics updates for details)
- Enabled resizing of the dendrogram attached to the grid
- Introduced horizontal zooming of dendrogram with mouse wheel and pinch gesture
- Fixed: Grid interactivity issues, including disappearing grid slider
HitTriage
- Added global V-id system and molecule tracking across multiple campaigns
- Improved support for collaboration with automatic signaling of changes in campaigns between multiple users, see release post for visual
- Campaigns table enhancements:
- Added the ability to sort columns via double-click
- Added the ability to hide or show custom columns in the campaigns table
2025-11-13 Datagrok 1.26.8 release
- Fixed Ctrl-click selection for scatterplot
- Restored the ability to share with a new user via email
2025-11-03 Datagrok 1.26.7 release
- Fixed Databrics schema browser
2025-10-31 Datagrok 1.26.6 release
Improvements:
- Added support for IAP short token format.
- Added the ability to move and copy files in Google Cloud Storage.
Fixed:
- CSV parsing issue in Google Cloud Storage
- OpenID autologin behavior
- GPU machine selection priority for Docker containers
2025-10-22 Datagrok 1.26.5 release
Improvements and fixes:
- Added support for SAML authentication
- Introduced support for user account impersonation in Google Cloud Storage
- Projects: Added support for saving projects created via custom scripts with data synchronization
2025-07-25 Datagrok 1.26.0 release
The Datagrok 1.26.0 release focuses on improved data access and collaboration, enhanced visualization capabilities, and navigation UI/UX improvements.
Breaking changes
This release introduces non-backward-compatible database changes. You can upgrade to version 1.26.0 automatically; however, once you migrate the database, older versions (including 1.25) will no longer be compatible. In case you need to roll back to 1.25.N, you must manually revert the changes or restore a pre-upgrade backup
Main updates
- Introducing Spaces, a new section in Browse that helps you organize, access, and share projects, files, folders, connections, and other frequently used items, making collaboration easier
- Enhanced Power Search on the Home Page now lets you quickly find tables, queries, functions, projects, and help topics all from one place
- A new Home Page widget, Activity Dashboard, provides a unified view of recent activity, shared items, favorites, personal actions, and notifications, so you can easily track and access key updates
- Complex calculated columns: you can now use a single vector function to generate multiple columns in one step, so you no longer have to add each column manually
- Python Celery task wrapper enables seamless integration of Python Docker applications with Datagrok, running Python functions as Celery tasks in isolated containers while the platform handles orchestration, task queuing, and results. For details, see Creating Python Docker apps
Platform
-
#2835: Data-Link Tables: Enabled editing of data-link tables without needing to unlink them
-
#2919: Added support for capture groups in regular expressions
-
#3346: Added option to export selected dataframe as SDF with customization
-
Provided the possibility to send email notifications with membership requests
-
Added the ability to restrict sharing within user groups
-
Enabled custom function call editors that integrate into the Datagrok UI, allowing tailored parameter input forms. For details, see Custom function editors
-
Fixed:
- #3325: CSV Export: Pinned columns are not saved when "Visible Columns Only" is enabled
- #2654: Projects: Error when using joining table function
- #3127: Projects: Datasync joined tables error when reopened in project/dashboard
- #3269: XLSX files with multiple sheets: data sync is only provided for the first sheet
- #3300: Projects: Data sync save setting resets to OFF after reopening saved data sync project
- Find and Replace: Finding all empty values is not supported
- Float column formats: Some different formats look the same in examples
Browse
- Browse tree navigation improvements: the selected directory is now sticky, so it stays in view when you navigate between sections, making it easier to keep your context while browsing
- Redesigned Docker UX with added Resources, Logs, and Build logs sections for easier container management and monitoring
JS API
- Added the alias for 'memberships', addressing the previous limitation that required using group.parents in the JavaScript API. For details, see how to get a list of users
Viewers
- #3322: Split date-based viewer timeline by time periods (week, month, quarter, year)
- #3077: Coloring: Added the ability to define colors for linear coloring (min, max, inflection point)
- #3303: Legend now considers categories filtering
- #3394: Added an option to adjust the font size of axis titles (column names), currently available for box plot, scatterplot, pie chart, bar chart, histogram, and density plot viewers
- Box plot: #3373: Added the ability to select date/time column for X-axis and aggregation by month/year/quarter
- PC plot: Added box plot and violin plot visualization
- Line Chart: Added an option to choose column for markers
- Fixed:
- Tile Viewer:
- Trellis plot:
- Pivot table: #3414: Fixed duplicated tables on Pivot added via properties
- #3398: Legend coloring: Icon change and direct access for numerical color editing
- #3410: Designed Form: Fixed alignment of some column values
Grid
Fixed:
- #3327: Coloring: Fails to apply to text after project reopening
- #3406: Coloring: Resetting applied categorical coloring in some cases
- #3413: Issues with color coding saving in Grid
- #3376: Tooltip not shown after changing "Show" option in grid menu
- #3220: Context menu hidden on last columns with no content on the right
Scatterplot
- #3339: Improved scatterplot whiskers
- #3404: Harmonizes min/max and range selection for whiskers
- Fixed:
- #3338: Whiskers: Incorrect behavior if only one of Min/Max columns selected
- #1434: Colors not updating after turning off color coding
- #3204: Formula lines cannot be edited in some cases
- #3323: Labels: Drag option not working for All or Filtered
- #3392: Formula lines: Axis in dialog should match viewer
- #3290: Color and Marker legend incorrect structure rendering
Filter Panel:
- #3341: Expression filter: Added support for values separated by line breaks
- Histogram: Improved filters performance for large datasets
Packages
Bio
- MSA Header Enhancements:
- Added header tracks: Conservation and WebLogo
- Added tooltips for the WebLogo header
- Improved performance of Conservation and WebLogo calculations
- Sequence Scrolling and Positioning:
- Added optional scrolling header for short sequences
- Improved detection of the maximum sequence length
- Improved display of the current position
- Performance Improvements:
- Added faster methods for retrieving monomers at specified positions
Chem
- #3302: Multiple scaffold trees: Added the ability to apply scaffold tree colors to scatterplot
- #3365: Scaffold Tree: Added Description field to viewer
- Fixed:
Charts
- #3420: Tree viewer: Moved
Show mouse over lineto Style section on the Context Panel - #3298: Tree viewer: Ctrl+Click updates, coloring, dash line behavior
- Fixed:
Diff Studio
- Model Analysis: Improved fitting and sensitivity analysis
- Sensitivity Analysis: implemented parallel evaluation of Diff Studio models, which significantly speeds up calculations
- Parameters optimization: improved usability and consistent line chart colors
EDA
- Quadratic PLS: Implemented quadratic partial least squares (PLS) regression
2025-03-28 Datagrok 1.25.0 release
The Datagrok 1.25.0 release focuses on enhancing the UI/UX, visualizations, and overall workflow efficiency
Breaking changes
Browse UX: Site markup, UI API, and CSS styles have been updated. If your packages or integrations rely on specific UI elements or styling, it is recommended to check for compatibility and make the necessary adjustments.
Main updates
- New Browse UX: three new tabs—Toolbox, Dashboards, and Favorites—make navigation more intuitive and organized
- Content-specific file viewers: improved file viewer support now detects both format and content, allowing files like .xlsx to open in the most suitable viewer—e.g., plain data opens as tables, while plate-formatted files open in the plate reader
- Harmonized server settings: we removed unchanged settings (hosts, ports, credentials), eliminated empty entries, and standardized service configurations
Viewers
- Mini-legend: added an interactive tooltip
- #2303: Provided 3-point-color scheme for gradient colors
- Box plot: #3292: Implemented zoom persistence for visualizations in layouts
- Pivot table: #3199: Added the ability to open data in new workspace
- Trellis plot: Enabled filter on cell click
- PC plot: Now features legend and column coloring
- Pie chart: Added max pie circle size property
- Fixed for Line Chart:
Grid
- Image Url columns now support links to images using Datagrok paths
- #3077: Added the ability to define colors for the linear coloring (min, max, inflection point)
- #3285: Сalculated columns now show unique columns in the error message
- Fixed #3243: Columns coloring via Edit Column Properties
Scatterplot
- Improved the jittering function. For details, see Jittering function in scatterplot
- Fixed #3193: The color by expression dialog now retains the last entered formula
Packages
Chem:
- #3273: Scaffold tree: Added the ability to apply scaffold tree colors to scatterplot or other viewers
Charts:
Power Grid
- Fixed #3242: Pinned columns: Long column name is not visible when column is pinned
Usage analysis
- Implemented the ability to filter functions usage by function tag
- #3213: Added a new Projects tab (beta). For details, see Usage Analysis: Features
Diff studio
- Implemented in-webworker solving equations
- Refactored Diff Studio to leverage the Diff Grok library for improved performance and extensibility
2025-02-18 Datagrok 1.24.0 release
The Datagrok 1.24.0 release includes stability, visualization, and UX improvements
Main updates
- New plate cell renderer for visualizing experimental plates (96 wells, 384 wells, 1536 wells)
- Grid: columns groups, files in cells, dynamic column width, and mouse panning
- Calculated columns persisting with the layout
- Tab ordering: you can now reorder tables (tabs) within the project by dragging and dropping them
Platform
-
#3110: Added the ability to send informational emails to users or groups
-
Projects:
- Calculated columns now persist with the layout
- #2833: Added the ability to order tables (tabs) in project via drag-n-drop
- #2883: Added the ability to view the creation script when uploading the data-sync project
Data Access
-
Visual Query: Added the
Order byoption
Viewers
-
Improved legend positioning:
- Added the ability to customize the legend's position in the viewer's corners
- Implemented automatic positioning: the legend can appear on the right or top based on size, or float in a corner
-
#3203: Preserved legend position in the previously saved layouts
-
Improved handling of color schemes:
- Ability to select color schemes from the context menu
- Grid column and viewers linear color schemes now stay in sync — changing one updates the other
- Redesigned the linear and categorical color scheme selector icons for the Context Panel
-
#3162: Viewer properties: Added null state for property types: color properties, string input, numeric (with slider), column selector
-
#3224: Box plot: Added the option to define Y-axis minimum and maximum range
-
Bar chart: Bars are now colored when
StackandSplitare set to the same value -
- Added the ability to select a current cell using the keyboard
- Added the ability to add/remove categories using plus/minus icons
-
Fixed:
- #3212: Resetting filters unexpectedly resets selection if PC plot with transformation is present
Grid
- #3195: Implemented a new plate cell renderer for visualizing experimental plates in grid
- Added new cell types:
FileandUser - #3194: Added adaptive grid cells for Jira tickets
- Implemented convenient handling of hidden columns
- Row height resizing: Font size and column widths now automatically adjust when resizing
- Added mouse-panning via the right button
- Column properties: Added the ability to set color coding for multiple selected columns
- #3178: Add new column: Added the ability to remove qualifier
- Summary columns: Implemented normalization for sparklines. For details, see Grid updates
- Fixed:
Scatterplot
Fixed:
- #3201: Two formula lines with same formula but different min/max cannot be displayed
- #3181: Labels: Resizing has no effect if label does not contain a structure
Line Chart
- #3210: Set a reasonable limit on the number of categories to prevent users from crashing the page
- Improved the automatic initial selection of the X column
Packages
Charts:
Fixed:
PowerGrid:
Fixed:
- #3229: Pin columns: Wrong order in pin column after reordering by another column
- #3075: Pinned columns: Table header hamburger menu disappears after hovering pinned columns
2024-12-23 Datagrok 1.23.0 release
The Datagrok 1.23.0 release includes stability and data access improvements
Main updates
- Visual Query: with an enhanced UX, you can seamlessly join multiple tables, select specific columns for your report, and pivot and group data
- Improved function execution: parallel queries and scripts now run 10x faster
Platform
Browse
- Galleries: Enabled keyboard navigation and selection in brief and card mode
JS API
- Added indefinite parameter to
grok.shell.info - Ability to specify tooltip position relative to the element (left / right / top / bottom)
- Added support for different types of parameters for calls:
grok.functions.call('sin', 0.5);grok.functions.call('sin', {x: 0.5});grok.functions.call('sin', [0.5]);
Viewers
- Legend improvements and fixes:
- Automatic positioning for optimal layout
- Automatic hiding when the viewer size is too small
- Proper rendering when positioned on top
- Trellis plot: Added support for mouse-over row group for inner viewers
- Fixed:
Grid
- #2968: Added multi-column style editing
- Fixed:
Scatterplot
- #3124: Added support for resizing structure labels
- #3142: Added ability to define columns for scatterplot whiskers
- #2708: Preserve formula line configuration upon changing columns on the axis
- Fixed:
- #3091: Show a more detailed message for a missing column
- #3055: Page is freezing after applying layout with multiple scaffold trees with large number of structures (data-specific)
- #2965: Legend color cannot be edited (no color picker icon) if both color and markers use the same column
- #3145: Label can be dragged out of scatter plot area and completely hidden
- #3123: Not all formula lines are shown in some cases
- #3175: Scatterplot with conditionally colored column as color inconsistency: color editor icon is shown, but colors cannot be changed
- #3176: Some labels disappear unexpectedly on zoom in / out
- #3180: Labels: Context menu disappears when unclicking the mouse
Line Chart
- #3111: Added color pickers to the legend
- Fixed:
Other fixes
- #3122: Pinned columns: Opening the project with pinned columns hides the pinned columns
- #3119: Add new column: formula with multi-argument functions is parsed incorrectly if more than one argument contains a column
- #3211: Add new column: do not show error message when using ‘IsNotEmpty’ for numerics
- #3024: Parsing source maps is loading the platform
Packages
- Plugin management improvements: Added package install logs to UI
Hit Triage:
- Added ability to edit campaign stages once the campaign starts
2024-12-20 1.22.3
Improvements and fixes:
- Viewers:
- #3133: Grid: Right arrow on changing column position with drag-and-drop is working if there is not panel/viewer at the right side
- #3184: Tile viewer: Scroll reset and rendering issues after adding new viewer
- #3188: Bar chart: Some categories are missing in the legend when data is filtered
- Scatterplot:
- #2965: Legend color can not be edited if both color and markers use the same column
- #3176: Some labels disappear unexpectedly on zoom in / out
- #3189: Scatter plot labels are shown for filtered out points
- #3191: Some dots are not shown on scatter plot when labels are enabled
- #3175: Scatter plot with conditionally colored column as color inconsistency: color editor icon is shown, but colors cannot be changed
- #3174: Table header tooltip overlaps menus
- #3168: Horizontal scroll bar in table disappears on double-click
2024-11-25 1.22.2
Improvements and fixes:
- Viewers:
- Scatterplot:
- PC Plot: Transformation doesn't work
- #3150: Box plot: New multi-category Box plot is not compatible with older layouts that have only single category
2024-11-04 1.22.1
Improvements and fixes:
- Filters: Avoid cross firing of events in duplicate filters
- #3119: Add new column: formula with multi-argument functions is parsed incorrectly if more than one argument contains a column
- #3107: Grid: Incorrect selection on grid with filtering/sorting enabled
- #3132: Color picker: Fixed opening new color picker removes previously selected color
- #3101: Shift-click selects unexpected rows in some cases
2024-10-22 Datagrok 1.22.0 release
The Datagrok 1.22.0 release includes stability improvements, key optimizations, and new features for a more efficient and responsive platform
Main updates
- Automated data cleanup keeps the server lean by deleting old data and logs (could be configured)
- Pyodide: you can now run Python functions, including data transformation steps, directly in the browser
- Plugin databases: you can now ship a Postgres database (such as chemical registration system) with your plugin
Platform
Browse
- Improved structure in the Browse section for more intuitive access to plugins and apps
- Set a custom order for apps within the tree, making navigation faster and tailored to user needs
- Fixes:
- Adding new folders now automatically refreshes the tree, keeping the view up-to-date
- Refreshing now retains previews without resetting, making it easier to track content
Scripting
- Added the ability to get Func result view
- Refactor handlers, Script, ScriptParam classes
- Fixed browser tab crash for 1-million-columns script
JS API
- #3063: Added the capability to add color palettes to configs
- Addressed an issue preventing dapi.queries from being executable, restoring full query functionality
Data Access
- Database initialization update: moved legacy database migrations to init_db.sql, optimizing the setup process and reducing overhead from outdated migration files
- Schema-specific migrations: implemented support for schema-specific database migrations that can be configured directly from packages, allowing for easier version control and better alignment with package requirements
Viewers
- New Confusion matrix data viewer
- Density plot: Increase bins after certain zoom
- #3015: Trellis plot is re-rendered on changing settings when there is no data to display after settings change
- #3052: Reducing a few seconds delay on creating a screenshot of a viewer
- Fixes:
- #2776: Line Chart: Page is not frozen if too many categories are used in split
- Histogram: Slider with bins doesn't suddenly become visible
- Box plot: Legend color picker menu closes correctly
- Scaffold tree: Fixing loader freezing on 0%
- Tree map viewer: "Split By" option fixing
Grid
- Formula-based rendering integration
- Add method to invalidate a single grid cell
- Fixes:
Scatterplot
- Improved label positioning and size adjustments (including for structure labels #2688)
- Added lines to connect data series
- Added color coding via expressions to enhance data visualization capabilities
Packages
- Plugin management improvements: Streamlined plugin uninstall and delete processes
- Added functionality to reset the touchedOn flag when selecting a package's current version
- Ability to auto update deprecated packages
Charts
- #3090: Sunburst usability improvements
PowerPack
- Fixes for 'Add new column' functionality:
- Fixed validation error when using if(true, "yes", error("Error")) in formulas
- Resolved incorrect validation when using nested columns in a formula
- Fixed an error where VectorCall caused addNewColumn to run the script on each row individually, rather than utilizing Script.vectorize for efficient processing
- Fixed an issue where the filter reset unexpectedly when clicking on a column, even if a category was already selected
- #3006: Changing the return type now correctly triggers column reordering
- #3010: Resolved issue where Qnum was incompatible with if statements
- #2981: Fixed an issue where typing in calculated formulas caused input to be unexpectedly overwritten
- #3009: Addressed an issue with calculated column hints breaking when using round and curly brackets together
Diff Studio
- Value lookups: Implemented the use of lookup tables
EDA
- Fixes:
- ANOVA: Fix incorrect column type bug
- Missing values imputation: Fixing dialog
Other fixes
- #3027: Cannot copy text from any input in filters panel
- #3032: Page is freezing for a while when color by column is applied in some cases (large number of categories + "starts with")
- #2715: PadLeft and PadRight do not seem to work (WIP)
- #2959: DS: Projects: Data-sync project doesn't open if a column with operations on it was excluded from the data source
- Unexpected logout on refresh token error - needs handling for invalid session only
- Projects: Misaligned layout on toolbox in data-sync project
- Converting object to an encodable object failed
- Credentials wipe when package version changes
- Invisible columns cause exception waterfall
2024-11-04 Datagrok 1.21.4
Improvements and fixes:
- Bugfixes for model signatures synchronization
- Text Renderer: Fixed multi-line link rendering
2024-09-10 Datagrok 1.21.1 release
The Datagrok 1.21.1 release enhances platform stability and usability, streamlining workflows for a more intuitive user experience.
Database migrations are irreversible in this version. You cannot roll back to an older version of Datagrok after the first 1.21.0 run. If a rollback is necessary, please contact Datagrok support for assistance.
Input API breaking change:
- The methods of
DG.InputBase(such asonInputandonChanged) have been updated. They are now of theObservabletype (previously they wereStream). To subscribe to these events, you will need to update your code frominput.onChanged(() => change());toinput.onChanged.subscribe(() => change());(same foronInput). - Additionally, when creating an input via the
ui.input.xxxnamespace and passing theonValueChangedparameter in the options, the parameters foronValueChangedhave changed. Previously, they were(input: DG.InputBase<T>), but now they are(value: T, input: DG.InputBase<T>). If you don't need the entire input object, you can simply use thevalueparameter in the method.
Main:
- Lightweight modeling improvements: Interactive dashboard for training predictive models.
- Binary classification support: interactive prediction threshold, AUC-ROC.
- Model comparison tool.
- Automatic model choice.
- Browse improvements:
- The ability to move files between connections.
- Refreshing browse ‘remembers’ preview.
- Creating new folder refreshes browse tree.
- JS-API: Implemented support for Float64 columns.
- File caching is now enabled by default: it works automatically without the need for configuration.
Viewers
- Density plot: color palette is added to the viewer.
- #2982: Tooltip was removed from the legend.
- Fixes:
- #3004: Two tables with molecules: Scaffold tree viewer is based on correct table by default.
- #2964: 'Selection to filter' resets immediately for some data if Scaffold tree viewer is present in the view.
- #2771: Filter out legend with empty categories in the legend.
- #2945: Color picker HEX\RGB choice input in the dialog.
- #2927: Fixing a collapsed state of the Heatmap after applying saved layout if it was stacked with another viewer.
- Pivot table: Changing columns (pviot, group by or aggregate) through context panel.
- Trellis plot: Fixed the error on redo command after reopening plot via undo.
Line Chart
- Fixes:
- Segment coloring: all segments are displayed now.
- Multi axis mode works with splits.
- #2950: Line chart with multiple axes: legend updates when Y column is changed using in-plot selector.
- #2951: Number of Y columns updates immediately in properties panel when columns are removed from the plot.
- #2944: Colors of the line and the legend do not differ when multiple splits are selected.
Bar chart
- Fixes:
- Molecules are renderered correctly when bar chart is resizing.
- Property "Show selected rows" affects the view.
Box plot
- The ability to use two or more categories is added.
- Fix:
- 'Show custom tooltip' functionality is fixed.
Scatterplot
- #2688: Structure labels: improved positions and sizes adjustment.
- Fix:
- Formula Lines: View updates after deleting options.
Scripting
- New ability to download the script as a file.
- Default scripts creates without tags.
- Fix:
- Usage displays runs.
JS API
- Ability to get Func result view using API is added.
- Metadata set by .tags with column.meta.xxx is replaced.
Data Access
- Connections: the 'creating a connection' form is updated.
- Fix:
- Databases: New Run_query result creates with the name.
Enhancements in packages:
Curves
- Fix:
- #2978: Log-linear function: Fixing initial parameters calculation.
Charts
- Fixes:
PowerPack
- 'Add new column': Formula edit improvements.
- Fixes:
- #2981: Typing calculated formula: input is not overwritten unexpectedly.
- #3008: Qnum function is not missing from hints.
- #2949: Calculated columns dialog: no extra scroll bars.
- #2993: Fixing the unability to type in inputs after adding a calculated column.
- #2918: Fixing the behaviour when typing
$in the calculated column dialog. - #2988: Calculated columns dialog: warnings and error messages are made more clear and consistent.
- #2798: Calculated column renaming is cascaded to the dependent columns for a saved project.
EDA
- Added to predictive modeling kit:
- Softmax classifier
- XGBoost tools
- Partial least sqaures regression
Chem
- Fixes:
- Chemical space: Reseting marker type to circles.
- Activity cliffs: Sets activity default column of date type.
- R-Group analysis: error updates when none R-groups were found.
- #2983: Fixing tooltip styles for structure columns.
Other fixes
- Table view: Form styles with refresh button is fixed.
- #2942: Export to CSV with 'Molecules As Smiles' works if there is some filtering.
- #2943: Categorical filter in column header is not broken after removing the same column from filters panel.
- #2985: Combined boolean filter can be removed from the project.
2024-09-26 1.20.3
Improvement:
- #3032: Page is freezing for a while when colour by column is applied in some cases (large number of categories + "starts with")
2024-08-27 1.20.2
Improvements and fixes:
- GROK-13701: Column headers rendering updates.
- #2982: Viewers: tooltip was removed from the legend.
- #2948: Colour picker in legend issues.
- #2970: Molecule column is missing in exported CSV with options "molecules as smiles" + "selected columns only".
- #2976: Categorical colouring's properties ".color-coding-fallback-color" and ".color-coding-match-type" are not saved in the layout.
- #2791: Fix duplicated table` renaming.
2024-08-05 1.20.1
Fixes:
- #2927: Heatmap is in a collapsed state after applying saved layout if it was stacked with another viewer.
- #2942: Export to CSV with 'Molecules As Smiles' fails if there is some filtering.
- #2943: Categorical filter in column header is broken after removing the same column from filters panel.
- #2949: Calculated columns dialog: extra scroll bars.
- GROK-16337: Bar Chart: Property "Show selected rows" doesn't affect view.
- Color picker :
- Line Chart:
- #2944: Line chart: the color of the line and the legend differs when multiple splits are selected.
- #2950: Line chart with multiple axes: legend is not updated when Y column is changed using in-plot selector.
- #2951: Line chart: number of Y columns is not updated immediately in properties panel when columns are removed from the plot.
2024-07-23 Datagrok 1.20.0 release
The Datagrok 1.20.0 release focuses on improving stability, performance, and usability, introducing refined workflows to make the platform more intuitive and reliable. Some of the key improvements in this release include:
- Lightweight predictive modeling improvements. MlFlow registry integration.
- File caching feature reduces the time required to access frequently used files by storing them locally in browser cache. This feature is compatible with various file storages, including Amazon S3, Azure Blob Storage, and more (follow our guideline to configure cache for your connection).
- Inputs harmonization brought significant stability enhancements and API improvements, ensuring a smoother and more consistent experience across the platform.
Visualization and usability improvements:
- Macromolecules updates:
- long sequences visualization optimized.
- cell renderer per type for small molecules and column width changes.
- monomer tooltip polished.
- monomer placer optimization for column width changed.
- work with missed monomers in Helm.
- Improved form autosizing.
- Diff Studio: implementing the debugging mode.
- Layout editing harmonization for Data Query.
- Restyled the process of dragging an entity into a project
- Objects can be added to the favorites list.
- No auto running for functions in browse preview.
- #2847: Export CSV without rounding.
Viewers
-
Improvements:
- GROK-14382: Add full property panel menu to the context menu on right click.
- GROK-15008: Density plot: add functionality.
- GROK-14607: Network diagram: auto layout.
- #2658: Scatter Plot: ColorMin, ColorMax, SizeMin, SizeMax properties.
- #2926: Heatmap: save scrollbar position for layout.
- #2932: Hide the option “Is Grid” from the property panel.
-
Fixes:
- GROK-11678: Tile viewer: switching between tables doesn't work.
- GROK-15518: Pivot table, Pie chart: filtration issues.
- GROK-15811: Pie Chart legend: Fix click on the category black cross.
- GROK-16226: DG.Filters sets columnNames incorrectly.
- GROK-15626: Viewer settings do not reset after switching between different options.
- GROK-16330: Table view: Form style with refresh button is broken.
- #2925: Viewer title is not saved in layout if it was edited in viewer's header.
- #2771: Filter out legend with empty categories in the legend.
Grid
- Improvements:
- GROK-16205: Support markup links.
- GROK-15984: Formula-based rendering.
- #2789: Ability to display the table name/description on the Grid.
- Fixes:
- GROK-15188: Dataframe/grid: renaming column from '~name' -> 'name' doesn’t change visibility of column.
- #2934: Some hotkeys for selection/deselection are not working for columns (MacOS).
Scatterplot
- Improvements and fixes:
- GROK-14632: Marker legend isn't rendered in the trellis plot.
- GROK-14376: Scatterplot: unzooming with mouse scroll can go to infinity.
- #2913: Improve different context menu style / functionality between Scatterplot in Trellis vs native Scatterplot.
Line Chart
- Fixes:
- GROK-15466: Table > Add View: Formula Lines for Line Chart should be present in added view.
- GROK-15464: Receiving errors when setting the second split in some cases.
- GROK-15485: Bugs in RowSource = FilteredSelected, SelectedOrCurrent.
- #2875: Line chart, trellis plot: number of selected columns is not updated in the properties panel immediately.
- #2904: When multi axis option is used. together with split, line chart is empty.
Bar chart
- Improvement:
- #2881: Bar chart: add an option to rotate / invert axes.
- Fixes:
- GROK-15887: Viewer window can't be resized in height when it's too high on the screen.
- GROK-16234: Wrong label shortening.
- GROK-16331: Molecules are rendered incorrectly on resizing bar chart.
Box plot
- Improvements:
- #2905: Add ''Size by" or "Shape by" or "color by'' options.
- GROK-9748: Violin-state option.
JS API
- Improvements:
- Compatibility tool for JS API changes.
- GROK-15771: RFC: Public API.
- GROK-15827: Expose core viewer events to JS API.
- GROK-16215: Force DG.FileInfo to have
name.
- Fix:
- GROK-16228:
grok.functions.calls.listreturns incorrect Func's nqName functions.
- GROK-16228:
Data Access
- Improvements:
- GROK-15413: Sharepoint data provider.
- Fixes:
- GROK-15979: Swagger: blank screen after loading swagger file.
- GROK-16003: Queries: New Aggregation Query: PivotGridDbTable.
- GROK-15967: Context panel: When you share the connection - the information doesn`t update.
Enhancements in packages
- Improvements:
- Fixes:
- GROK-15324: Widgets: Recent projects: context menu fixing.
- #2924: Curves: connectDots doesn't work if fit is turned off.
Bio
- Helm:
- GROK-15994: Color missing monomers.
- GROK-15995: Colors for libraries monomers.
- GROK-15796: Helm cell renderer fixes for conversion to Helm.
- Fixes:
- GROK-15525: MSA: add checking unsuitable data to avoid running MSA with them.
- GROK-15996: Macromolecule cell renderer fails in long mode.
- GROK-15798: Atomic Level fixing for units FASTA, UN alphabet.
- GROK-15793: Calculate Identity, Similarity throw Index out of bounds.
Chem
- Fixes:
- GROK-15299: Functions can't be saved to a project with data sync.
- GROK-15790: Transform to smiles doesn't change units.
Scripting
- Improvements and fixes:
- GROK-15424: Cascade parametrized inputs in scripts.
- GROK-15876: Split logic for blobs and file parameters.
- GROK-15973: Behavior changes for clicking the 'Save' button.
- GROK-15968: Usage: rename 'Run count' into 'Successful Runs'.
- GROK-15829: Unable to add parameter to script: "+" button is missing.
Fixes:
- GROK-15834: Table Linking: wrong results when multiple duplicate keys are present in both master and details table.
- GROK-15871: Project creation date is shown instead of updated one in the dashboards.
- GROK-15570: Fixes for slider for filtered numerical column where all values are nulls.
- GROK-12320: "Add new row" button is not rendered properly when no row headers are used.
- GROK-16208: Tooltips: broken layout for a float column with only nulls.
- GROK-16269: History prints wrong timestamps.
- GROK-16320: Predictive modeling: interactive model saves without a name.
2024-06-21 1.19.1
Fixes:
- GROK-16000: HashId for package functions doesn't work.
2024-06-07 Datagrok 1.19.0 release
Visualization and usability improvements
- Updated project`s management.
- Power Search: updated support for entities.
- Usage analysis: user report system improvements.
- Speedup for platform’s startup.
- New hierarchical and expression filters.
- New recent activity view.
- Categorize function improvements.
- Improved experience with sticky meta.
- Browse updates: search, preview, tooltips.
- Viewers: hooks for custom JS initialization.
- OptiTool: compute inputs providing the specified output of RichFunctionView functions.
- GROK-15361: Updates for Custom formatting.
- GROK-14203: Calculated columns: Update values if the base column values changed.
- #2673: PowerGrid: MultiChoice cell renderer.
- #2681: PowerGrid: Tags cell renderer.
- #2765: PowerPack: integrate search with the semantic value extractors.
- #2668: Implement export selected/filtered rows as a CSV.
- #2710: Implement export selected dataframe/view as a CSV.
- #2772: Pivot table: add a property to hide sparklines.
- #2847: Export CSV without rounding.
Viewers
Improvements:
- #2733: Legend: provide diverse palette and markers' shape.
- #2755: Hide the zoom slider for making screenshots.
- #2742: Indicate the selected column in the column selector.
- #2770: Ability to toggle on / off multiple vs single regression line per category.
- #2664: Implement a cascade column renaming used by Formula lines.
- #2685: Histogram viewer: add stacked view option when split is set.
Fixes:
- #2642: Filtering done using viewers is unexpectedly reset on applying other filters.
- #2771: Filter out legend with empty categories in the legend.
Grid
Improvements:
- GROK-15475: Ability to customize cell styles (content/header, color, font, alignment etc.).
- GROK-15469: Text cells: highlight the search terms.
Fixes:
- GROK-15249: Error when pressing Column Properties on a programmatically created Grid.
- GROK-15457: Fix categorical color-coding styles in the property panel.
- #2682: Fix the tooltip for Allow Row Reordering.
- #2663: Enable easier composition of rows/columns range selections.
Forms
Improvements:
- GROK-14951: Clicking on a field should drive to the appropriate column in the table (like 3DX).
- GROK-14985: Ability to edit a form in the form designer.
- GROK-15416: Integration with sparklines.
- #2687: Add an option to adjust the size of the compound structure image.
Fixes:
- GROK-15209: Error after renaming a column name.
- GROK-15325: In case form viewer is added through layout, grid doesn't jump to corresponding cell when clicking on form viewer field.
- GROK-15677: Fixing "Build a form for selected columns" option.
- #2644: Next row button: incorrect behavior after sorting the grid.
Scatterplot
Improvements:
- GROK-15459: Ability to show horz axis labels at 45 degrees.
- #2704: Add min/max fields for X/Y axes on plot to improve viewer's usability.
Fixes:
- GROK-15069: Incorrect hadling of Color and Markers legend in some cases.
- GROK-15190: Scatterplot, line chart: updating formula lines does not work for those specified via a dataframe.
- GROK-13884: The legend is displayed differently depending on the order in which the options are assigned.
- #2671: Filtered out data is unexpectedly shown in some cases on filtering the plot further using markers legend.
Trellis plot
Improvements:
- GROK-15393: Ability to scroll via mouse wheel.
- #2636: Bar chart: improvements.
Fixes:
- GROK-15035: Sparklines: incorrect data display.
- GROK-15036: Histogram: error when Row source = MouseOverGroup.
- GROK-15038: Box plot: error when selecting rows in grid.
- GROK-15013: Bar chart: numbers (zeroes) on chart have different sizes.
- GROK-15033: Line chart: if you set the Split option, the legend remains visible on other inner viewers.
- GROK-15025: Some axes labels overlap the plot.
- GROK-15137: Sparklines: error when setting selected columns.
- GROK-15304: Selecting categories in the legend works incorrectly.
- #2749: Line chart and Trellis plot: '+' icon is missing.
Line Chart
Improvements:
- #2846: Add distinguishable color legend for line chart when there are multiple Y axes and split key.
- #2726: Implement consistent behavior for aggregated and non-aggregated axes.
Fixes:
- GROK-15078: Error on changing column name when column used in x- and y columns.
- GROK-14501: Aggregation Type and Show Split Selector do not work.
- GROK-15048: Incorrect legend display when Row Source = MouseOverGroup and Filter is set.
- #2782: Incorrect color-coding while setting filters.
- #2776: Page is frozen if too many categories are used in split.
- #2747: Formula lines: inconsistent behavior.
- #2677: Formula line position is incorrect after switching axis to log scale.
Data Access:
- GROK-14953: Azure blob: directory shown as a file.
- GROK-15397: Storage: add SharePoint provider.
- GROK-15434: Run polytool on molfile v3k libs.
JS API:
- GROK-14512: JS API for entity properties/types/schemas.
- GROK-15671:
formatoption does not go toDG.Property.format. - GROK-14674: DG.ViewBase does not trigger UI update on name change.
- GROK-14707: DG.Column.init contructs invalid DataFrame column.
Enhancements in packages
Bio
Improvements:
- GROK-15039: Expose function for PolyTool lib creation.
- GROK-15044: Add basic documentation for monomer lib file manager UI.
- GROK-15045: Monomer lib file manager UI improvements.
- #2707: Monomer type as a class.
Fixes:
- GROK-14913: Atomic Level for sequences of fasta MSA with gaps fixing.
- GROK-14916: Biosubstructure filter for sequences of Helm fixing.
- GROK-11982: Composition Analysis: duplicates a WebLogo viewer when applying a layout.
- GROK-15086: GetRegion, Notation: doesn't work.
- GROK-15150: hidden/showed inputs incorrect display in forms.
- GROK-15176: An Error after pressing the Molecule on molfile(msa(Sequence)) column.
- GROK-14914: Helm: Fix Properties panel of Context panel for sequences of MSA.
Chem
Improvements:
- GROK-15018: RGroup analysis improvements.
- GROK-15508: MMPA | Generated - show what cases are actually generated.
- GROK-15501: MMPA | UI/UX and other improvements.
- GROK-15502: MMPA | Ability to switch activity on/off.
- GROK-15454: Similarity, Diversity search viewers | Implement row source.
- GROK-14773: RdKit service as molecule cache.
- #2729: Similarity, Diversity searches: add the ability to perform the search for the filtered data.
- #2525: Scaffold tree highlighting improvements.
Fixes:
- GROK-14029: Substructure highlight: settings are not saved to the Layout.
- GROK-15063: 2D widget is not resizing.
- GROK-15144: Layout applies incorrectly when having several clones.
- GROK-15127: Python scripts Mutate, Curate, R groups sporadically fail.
- GROK-15171: Filter doesn't apply correctly after removing rows and disabling.
- GROK-15208: MMPA | 'Refreshing pairs...' progress bar is not closing.
- GROK-15240: Error in balloon after R-group analysis' start (malformed data).
- GROK-15507: MMPA | Control of fragments size (to options).
- GROK-12906: Context Pane: Fix alignment for the *more actions* icon.
Curves
Improvements:
- #2754: Implement capability just to connect the points (without fitting).
- #2103: Property panel changes.
- #2105: Outliers and curves colors changes.
- #2101: Improve curves properties and rendering.
- #1645: MultiCurveViewer.
Fixes:
- #2797: Custom fit function doesn't fit correctly.
- #2748: Whole table is broken if the cell with curves contains specific data.
Charts
Improvements:
- GROK-15447: Radar viewer: add a part of Viewers tutorial.
- GROK-15409: Radar: improvements (interactivity, color-code, etc.).
- GROK-15340: Radar: Spider Plotting - Multiple series.
- GROK-14610: Sunburst: animation and selection improvements.
- #2500: Sunburst improvements.
Fixes:
- GROK-13831: Tree viewer: error when trying to set Size or Color.
- GROK-13832: Tree viewer: doesn't respond on table switching.
- GROK-13390: Radar viewer: harmonization.
- GROK-15245: Radar: error when saving to project.
- GROK-15166: Sunburst: error when trying to switch the Table property.
- GROK-14899: Tree Visualization: Color Agg fails on null values.
DiffStudio
Improvements:
- GROK-14487: UI improvement.
- GROK-15713: Fitting.
- GROK-15112: Added Bioreactor to examples.
- GROK-15116: Added E-notation parsing.
- GROK-15294: New sidebar feature.
- GROK-15364: New app view feature.
Fixes:
- GROK-14994: Conditions with JS functions don’t work.
- GROK-14673: UiBuilder: validators strange behavior.
- GROK-15341: Semantic value extractors.
- GROK-13568: Help | Compute: Sensitivity Analysis.
- GROK-15192: Incorrect behavior of inputs in scripts and queries.
- GROK-15376: Column data disappearing while changing time format.
- GROK-15613: 'Ctrl + Wheel' behavior as 'Zoom In/Zoom Out'.
- GROK-14828: Downloaded files doubled after Extract Selected Rows.
- GROK-15834: Table Linking: wrong results when multiple duplicate keys are present in both master and details table.
- GROK-15051: Pie chart: error when selecting Segment angle and hovering the empty value.
- #2824: Creating Dataframe from csv loses qnum precision.
Box Plot:
- GROK-15752: Box Plot: can't select points outside of whiskers.
- GROK-15365: Box plot: error when switching Value axis to the log scale in some cases.
- #2764: Wrong area is selected with shift-drag when categories at the left are filtered out.
Bar chart:
- GROK-15156: Values are not shown for just negative numbers.
- #2696: Add highlighting for bar chart subsets.
Filter Panel:
- GROK-15650: Combined boolean filter.
- GROK-15122: Categorical filters: Tooltip and mouse over group is automatically cleared after 200ms on category hover.
- GROK-15206: Filters: categorical filter is broken for hidden ~name columns.
- #2647: File refresh breaks structure filter.
- #2684: Wrong filters are added if there are two views in some cases.
- #2185: Fuzzy filter enhancements.
Tutorials:
- GROK-15143: Multivariate Analysis and R-Groups Analysis tutorial: Top menu items don't open properly.
- GROK-15132: Timelines: error when using the legend.
2024-06-05 1.18.9
Addressed Issues:
- GROK-15834: Table Linking: wrong results when multiple duplicate keys are present in both master and details table
- #2839: Show Help in "Settings - Windows" remains checked always
2024-05-19 1.18.8
Improvements:
- GROK-15681: Projects Management
- #2831: Default open folders in the Browse Menu
Fixes:
- #2832: Tab Name changes when reopening Project
- #2840: "Global Search" button on bottom-right bar menu improvements
- #2834: Loading of DB tables appears to continue forever and never complete
2024-05-15 1.18.7
Improvements:
- #2845: Changing the colors of labels in the properties
Fixes:
- #2824: Creating Dataframe from csv loses qnum precision
2024-05-08 1.18.6
Fixes:
- FormViewer: fixed an issue with dragging column headers
- Scripting: Clear temporary token for input files
2024-05-01 1.18.5
Improvements:
- Error handling: "Report an error" dialog when you click on exclamation point.
- Sticky meta: improve visibility for users:
- Show preview for entity types
- Support multi-values edit
- Entity type settings with TabControl
- Better type selector for schema editor.
- JS API for entity properties/types/schemas.
- #2733: Viewers | Legend: provide diverse palette and markers' shape.
- #2742: Viewers: Indicate the selected column in the column selector.
- #2772: Pivot table: add a property to hide sparklines.
- GROK-14412: Trellis plot | Column selectors: ESC should close the popup.
Fixes:
- Azure blob: directory shown as a file.
- GROK-15190: Scatterplot, line chart: updating formula lines does not work for those specified via a dataframe.
- GROK-15249: Error when pressing Column Properties on a programmatically created Grid.
- #2642: Filtering done using viewers is unexpectedly reset on applying other filters in some cases.
- #2644: Forms | Next row button: incorrect behavior after sorting the grid.
- #2749: Line chart and Trellis plot: '+' icon is missing.
- #1092: Multiple issues with Conditional Color Dialog.
- #2764: Box plot: wrong area is selected with shift-drag when categories at the left are filtered out.
- #2509: Pinned columns in multiple views for the same table cause performance issues in some cases.
- #2782: Line chart: incorrect color-coding while setting filters.
- #2636: Trellis plot | Bar chart: contrast color for blue instead of black works when there is no Stack set to the bar chart inner viewer.
- #2793: Scatter plot with 'filter by zoom': filtering by scatter plot is shown in filter panel's '?' after resetting in some cases.
2024-04-05 1.18.4
Addressed Issues
- (Bug) GROK-15334: Large file open fails (WIP)
2024-03-28 1.18.3
Addressed Issues
- (Bug) GROK-15300: Table duplicates after changing ID
2024-03-19 1.18.2
Addressed Issues
- (Bug) GROK-15215: Async package functions don't work in Add new column
- (Bug) GROK-15216: Views migration didn't run
- (Bug) GROK-15166: Sunburst: error when trying to switch the Table property
2024-03-14 1.18.1
Addressed Issues
- (Improvement) GROK-14698: Color coding: improve traffic lights schemas
2024-03-08 1.18.0
Datagrok 1.18 release focuses on usability improvements and stability:
- Improved Browser for navigation, preview, and convenient interaction with all available functionality on the Datagrok platform.
- Ability to clone projects.
- New CVM queue employs multiple JKG nodes to ensure scalable and streamlined script execution.
- New MultiChoice cell renderer to show a number of checkboxes within a cell. For details, see Add multiple check box and dropdown list to cell of table.
- New Tags cell renderer for comma-separated rows.
- Automatic error handling report: A "Report an Error" dialog box appears when you click the exclamation point icon (Beta version).
- Sticky meta (Beta version).
Visualization and usability improvements
-
Calculated columns:
- Save calculated columns to the projects with data synchronization.
- Update values if the base column values changed.
-
#2634: Synchronization between Bar chart and Line chart.
-
#2455: Viewers: Add the ability to choose several categories with ctrl click.
-
#2548: Viewers | Legends: implement switching between categories using up and down arrows when one category is selected exclusively.
-
#2635: Customization of actions on the Context Panel.
-
#2664: Implement a cascade column renaming used by Formula lines.
-
#2467: Allow to set tab label for stacked viewers programmatically.
-
#2598: Context menus to hide selectors.
-
#2564: Column selectors should not overlap the viewer.
-
#2299: Make viewers aware of surroundings.
-
Rename viewer by hotkey F2.
-
Column selectors: ESC should close the popup.
-
Fixed:
-
Grid:
- #2645: Support single decimal place for rounding in calculated columns
- Rendering table cells with any viewer.
- Custom numeric format.
- Fixed:
- #2468: Cell values starting with the quote character are parsed incorrectly.
- #2483: Order and hide columns and Tooltip dialogs: cosmetic issues.
- #2503: Order and Hide: Tooltip with null category shouldn’t be that big.
- #2523: Columns added after performing structure search cannot be shown again if hidden.
-
- #2456: ignore negatives and zero values when switching to log scale.
- #2480:default range should take into account only the rows where both axes values are present.
- Fixed:
- #2330: Scatterplot has to show empty categories like Box plot and Bar chart do.
- #2487: datetime columns are not supported when adding formula lines.
- #2488: Color selector is missing for formula lines dialog.
- #2489: Color selector opened from the 'style' section in properties panel cannot be closed.
- #2505: If categories are filtered out they shouldn't be shown in the marker legend.
- #2527: error occurs when axes are set to log scale in some cases.
- #2530: Errors on hovering scatterplot with formula lines.
- #2665: Ctrl+Shift+Drag doesn't work for deselection.
- #2671: filtered out data is unexpectedly shown in some cases on filtering the plot further using markers legend.
- #671: 'Formula lines' dialog preview is not updated if scatterplot configuration is changed
-
- #2457: redesigning:
- Move X and Y selectors to the corresponding axes.
- Most relevant options of the inner viewer should be displayed at the top of the viewer
- Selectors instead of combo-boxes
- #2336: improve the display of outer and inner viewers properties.
- #2636: Trellis plot | Bar chart: improvements.Now they work with global axes, support multiple splits, and display their axis with category names and colors on the left.
- Better auto-selection of columns for pie chart and bar chart.
- Integrate sparklines (Beta version). For details, see Trellis: sparklines
- #2457: redesigning:
-
Box plot: #2484: no indication what dot is hovered, wrong dot is selected in some cases.
-
For pivot table fixed:
-
Tile viewer: ability to specify custom lane categories.
-
Correlation plot: #2653: tooltip issue.
-
Forms viewer: #2652: implemented an option to download a viewer as PNG.
Data Access
- Azure Blob integration. For details, see Azure Blob
Improvements for developers
- Core: Inputs: validation and harmonization
- New
UserInput. - Two-way binding for
DG.InputForm. bindFuncCallmethod forInputForm.- Computable "visible" and "enabled" properties
TableInput: Implement capability to get files from Shares.NumberInput: Add capability to set custom step.- Removed default rounding for float inputs.
- New
- Table, RowSource, and Filter properties in js viewers.
- Scripts logging system.
- Script saving via Ctrl+S.
- Scripting | Variables: added the scrollbar to the variables window.
- API to send an email from DG.
JS API
Column.getNumber()method.- Dynamical dependencies load for
Utils.loadJsCss(files). - Auto-generation of Dart interop interface.
- Exposed
FuncCallfields to JS. - Setter for
InputBasecaption. - Made
EventDataforDataFrametyped.
2024-02-08 1.17.13
Addressed Issues
- (Bug) #2647: #2647: File refresh breaks structure filter
- (Bug) #2639: Structure in filter is unexpectedly changed when there are two views in some cases
- (Bug) #2642: Filtering done using viewers is unexpectedly reset on applying other filters in some cases (WIP)
2024-01-26 1.17.12
Addressed Issues
- (Bug) Windows share mounts with wrong permissions
2024-01-22 1.17.11
Addressed Issues
- (Bug) #2628: Structure filter is not applied in some cases when there are two views opened
2023-12-21 1.17.10
Addressed Issues
- (Bug) #2535: Pivot table: non-default aggregations are not saved in layout
- (Bug) GROK-14381: Grid | Add Summary column: impossible to hide or add a column through the Order or Hide Columns dialog
- (Bug) #2577: Line chart: colours in the legend do not match colour in the plot in some cases
- (Bug) #2570: Viewers: legend does not show all categories after filtering in specific cases (WIP)
- (Bug) #2574: Multiple errors in console on hovering line chart with logarithmic axis and no data