Release July 2025 (before the summer break)

We are happy to deliver the brandnew July 2025 Release with the new New Dynamic List Queries and many other Features! Try it now!

Remember, the Frontend is the user friendly spreadsheet for your Collector Users to deliver their monthly/weekly/daily data. The Admin Center is the tool for the Power User to setup and control your organization’s collection workflows.

(1) Frontend: New Dynamic List Queries (Preview)

List Queries have become a powerful feature and are essential for many advanced applications in data1.io. Until now it was necessary to define a maximum number of rows or columns which could be filled by the list query and then fade out the rows / columns not used.

We are very happy to present the new dynamic List Queries which generate automatically the needed number of rows or columns. Have a look on this top level query – there are no additional (hidden) rows:

But have a look on this team level query – there are also no additional (hidden) rows:

For a dynamic List Query only one row (or column) is defined which will be duplicated as often as there are hits in the list query. You need two additional parameters for the list query to make it dynamic:

• data1_LISTQUERYxx_T_DIMxxx_CmdDynamic
  1 = dynamic list query
  The named range for the List Query is dynamically reduced or expanded by rows or columns. The first row or column is copied (copy/paste) to the new row(s)/column(s) so that the formulas and conditional formatting are retained and automatically adjusted to the new row/column (behaviour as in MS Excel).
  0 = static list query = default
  The name range is filled to the stop, rows/columns beyond this are not created.
  
• data1_LISTQUERYxx_T_DIMxxx_CmdExpansion
  row = new data is added row by row = default
  column = new data is added column by column

Dynamic List Queries are a complex feature with many interactions with other features:

• Clean removal of the existing rows from the last list query
• Clean format for the generated rows/columns and clean application of the changed cell format
• Sheet Protection
• Row Level Security (RLS)

This complexity is the reason why dynamic List Queries are currently in preview.

(2) Frontend: Writeback Optimiziation for List Queries

We have introduced the writeback functionality for List Queries in March 2025 Release. We`ve learned that the writeback in large lists was very slow since for every entry in the SysDelta parameter a separate SQL statement was sent in order to replace the already existing records for this batch.

With this release, the deletion of the existing records is executed with only one single SQL statement …

… which makes the writeback process performant:

(3) Frontend: Dimension Tree Sorting

The order of the sum level nodes in the dimension tree is determined …

… by the assigned elements with the lowest SORT information:

Until now, this algorithm used only the visible elements of a (filtered) dimension tree. Therefore the following constellation …

… led to a dimension tree with reversed order of the the two companies on Level 2. With this release we have changed this algorithm and the order of the sum level nodes results from all existing elements – visible or not:

This is a major change, since the dimension tree in an application has now always exactly the same order in all filtered variations of the tree.

(4) Admin Center: Dependent Filters in Tables

We have introduced the new column filter experience in November 2024 release. With this release we are happy to introduce dependent filters. That means that existing filters on one column …

… reduce the number of hits in all other column filters:

(5) Admin Center: RLS Improvements

We have learned that the RLS definition can be difficult due to the default column names in the RLS dialog. With this release we have added the individual column names to the dialog which will make it easier to see which attributes e.g. belong to the same hierarchy:

(6) Admin Center: Copy Data Improvements

We are happy that it is now possible to change the sort order of the filters in the “Filter condition(s)” block as well as in the “Target rule(s)” block:

Furthermore, we have also optimized the column order in the “Filter Condition(s)” block:

Last but not least, we have added the date to the timestamp in the execution bar.

(7) Further Improvements

We have solved an timing issue with the “Read Validation” (which was initially released in February 2025 release). In rare cases the validation message was shown altough there was no issue since the validation message was shown earlier than the READ process for the sheet was finished.

There was an issue in the Copy Data feature. The number of records shown which will be replaced (as preview before you start the copy data job) was not correct in some cases.

We have found a solution for the limitation for the execution of SQL statements with more than 2100 parameters – SQL statements are now executed piece by piece with 2000 parameters maximum.

We have also solved issues in the Admin Center in the Collector Users and in the RLS definition screens.

---

We hope you like the new features – we are very curious about your feedback!

Please let us know what you think about data1.io and what kind of planning and data collection processes you evaluate to automate.

We`ll be back after the summer break with the September Release!

we #StandWithUkraine