Cinchy Platform Documentation
Cinchy v4.0
Cinchy v4.0
  • Dataware Overview
  • Release Notes
    • 4.1 Release Notes
    • 4.2 Release Notes
    • 4.4 Release Notes
    • 4.5 Release Notes
    • 4.6 Release Notes
    • 4.7 Release Notes
    • 4.8 Release Notes
    • 4.10 Release Notes
    • 4.11 Release Notes
    • 4.12 Release Notes
    • 4.13 Release Notes
    • 4.14 Release Notes
    • 4.15 Release Notes
    • 4.16 Release Notes
    • 4.17 Release Notes
    • 4.18 Release Notes
    • 4.19 Release Notes
    • 4.20 Release Notes
    • 4.21 Release Notes
  • Cinchy Guides
    • User
      • My Network
      • User Preferences
      • Table Features
      • Data Management
      • Commentary
      • Query
    • Builder
      • Best Practices
        • Multi-Lingual Support
      • Tables
        • Creating your first table
        • System Columns
        • Column Types
        • Linking Data
        • Indexing and Partitioning
        • Formatting Rules
        • Data Controls (formerly Design Controls)
          • Table Level Entitlements
          • Column Level Entitlements
          • Row Level Entitlements
          • Erasure
          • Compression
      • Building Forms
      • Saved Queries
        • Creating your first query
        • Displaying Query Results
      • Integration
        • BI Integrations
          • Excel
          • Power BI
          • Tableau
        • Other Integrations
          • SAS
      • Data Experience Deployment
    • Frequently Asked Questions
  • API Guide
    • APIs
      • Authentication
      • Saved Queries
      • ExecuteCQL
      • Webhook Ingestion
  • Deployment Guide
    • Planning
      • Deployment Planning Guide
      • Pre-Requisites
    • Installation
      • Maintenance
      • Migration from 1.x
      • Single Sign-On (SSO) Integration
        • Configuring ADFS
        • AD Group Integration
        • High Number of Groups in ADFS
      • Application Experiences
        • Setting Up Experiences
        • My Data Network
        • Custom Data Network Visualizer
      • Advanced Settings
        • Enable Data At Rest Encryption
        • System Properties
  • Other Resources
    • Cinchy Data Sync
    • Cinchy Meta-Forms
    • Cinchy Meta Reports
    • Cinchy Query Language
    • Angular SDK
    • JavaScript SDK
Powered by GitBook
On this page
  • New Features
  • ‌Custom Data Network Visualizer
  • Multi-Lingual Support
  • User Defined Functions in Calculated Columns
  • Docker Support
  • Improvements
  • New Options for Calculated Columns
  • Query Builder
  • Nested Display Columns
  • Keyboard Navigation for Manage Data & My Network

Was this helpful?

Export as PDF

Release Notes

PreviousDataware OverviewNext4.1 Release Notes

Last updated 5 years ago

Was this helpful?

Cinchy 4.0 comes with Custom Data Network Visualizer, Multi-Lingual Support, the ability to use User Defined Functions in Calculated Columns and Docker support.

New Features

‌Custom Data Network Visualizer

You can visualize your own custom data networks using Cinchy. See .

Multi-Lingual Support

Cinchy now has multi-lingual support. You can go to your user profile and change your language and region preferences. French translations are pre-populated, but you can also add other language translations.

The same system can also be used by Applets through our language API.

User Defined Functions in Calculated Columns

You can call a scalar-valued user defined function in a calculated column. This allows you to do a variety of operations:

  • Create more complex functions or aggregations from other tables

  • Trigger an API call to retrieve external data

  • Create a notification or create a record in another table

Docker Support

Cinchy is now available via Docker. For deployment instructions please see Docker Deployment.

Improvements

New Options for Calculated Columns

Cache

Current calculated columns are cached, meaning they are stored for fast retrieval for querying. In some cases, you may want to run the calculations in real time (for example, if the calculated column calls a User Defined Functions, which calls an external API for immediate real-time information). In these cases, you can uncheck the Cache option.

A calculated column that is not cached is not persisted, and calculated on the fly. It works essentially like a saved formula, and is executed when you read the record.

Calculate Existing Values

Another option now available on Calculated Columns is calculate existing values. This option is available when you change a formula for a persisted calculated column on an existing table. Previously we would always recalculate all the values in the column.

If you uncheck the box, the column will not be calculated on save and will be blank. Any updates to that record or newly inserted records will have the column calculated. You can use this to set up triggers (since the calculation will run whenever a change occurs on the record) or schedule the calculations separately in batches in case you have a lot of data and may hit external API rate limits during the calculation.

Query Builder

Result Type

We included the result type drop down in the query builder screen so it is easier to switch result types when running your query. This is also useful when running different sections of your query for debugging purposes.

Query Timeout

The timeout for a query is now configurable. The default is 30 seconds. However if you find that you need to run a query that is known to take longer and needs to be executed you can modify the timeout. This can be saved so the query will always allow for that longer timeout. This is generally only recommended after you have already ensured your query is correct on a smaller dataset, and you know the query will take longer than 30 seconds to execute.

Nested Display Columns

Additional display columns can now come from links further down, rather than only from the linked table.

Keyboard Navigation for Manage Data & My Network

At Cinchy, we are constantly looking to improve our accessibility and usability. The My Network screen as well as the Manage Data screen can now both be navigated entirely via the keyboard.

‌

See for details.

Multi-Lingual Support
Custom Data Network Visualizer
Network of Networks