Manipulate records and perform deeper analysis with Table Queries & Aggregations

Release 204 of the Tulip platform is here. This release contains routine bug fixes and small feature updates, as well as the new Table Queries and Aggregations feature. Let’s dive in.

Table Queries

With Table Queries, users can manipulate records, and perform deeper analysis on their data. Run multiple operations on top of different columns, and define queries that can be shared across apps.

As an example, this table of Orders has 10 rows:

We can use a filter to return only rows that have not been shipped:

In Table Queries, users have several different options for types of queries that can be performed:

• Filter

• Sort

• Limit

In addition to tables, Queries can be added to apps easily, allowing you to Query an interactive table in your app.

Aggregations

Aggregations can be created and applied across any number of queries. These features will allow you to build and display lists of data based on certain criteria in apps and pull up specific records when you need them.

In Aggregations, users have several different options for types of calculations that can be performed:

• Average

• Count

• Max

• Min

• Mode

• Sum

Just like Queries, Aggregations are easily added into apps. App logic can be built around an aggregations value also to perform actions and show messages.

Want more details on how to use Table Queries and Aggregations? Check out this support article to get started →

• Added networking custom NTP support

• Added Node-RED tulip-edge nodes for Tulip Machine Attributes API and Tables API*

• Added support for serial devices through Node-RED*

*Edge MC Only. For more information, read this support article →

• AppGroups now has an API endpoint

• Standard Deviation of an expression array has been added to the expression editor

• Machine Widgets functionality has been improved

• Changed wording on Tables from “Deleting” to “Archiving” to better reflect the action

• Improved performance for Table Queries with frequently updated records

• Interactive Table Widgets and Dynamic Analyses can be filtered by table records

• Printing step groups as PDFs show full information

• Writing to Tables with Audit Log enabled does not lock users out of a database

• Master Layout in Steps page is distinguished from other steps to prevent accidental edits

• App exports include Tulip Tables that are used in embedded analytics

These features and more are available to Tulip users in release 204 and above. To learn more about other additions and fixes with the most recent releases of Tulip, visit our community site for release notes, and our support site for resources. Want to learn more about a specific product feature? Reach out with questions.