Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

sql support

Showing 4

Add ability to parse arrays of scalar values to JSON_TABLE

Currently, JSON_TABLE supports parsing arrays of JSON objects into rows. That works well, several of the documented examples show how to do that. Unfortunately, this feature does not currently support parsing arrays of scalar values. Being able to...
18 days ago in Spotfire Data Virtualization / sql support 0 To be Reviewed

Recursive CTE Support

I need to be able to query TDV views recursively. CTEs are great for this, but currently I just get the error "invalid table" when referring to the CTE name within the CTE.
about 5 years ago in Spotfire Data Virtualization / sql support 0 To be Reviewed

Propagate changes in one layer to the following layers

If you use different layers and change the fieldname in one of the early layers, the subsequent layers need to be changed accordingly, by hand. Using the lineage information it should be possible to propagate such a change throughout the layers.
over 4 years ago in Spotfire Data Virtualization / sql support 0 To be Reviewed

add support to insert boolean data into TDV even though backend database does not support boolean data type

We are developing a Spotfire custom module which connects to TDV 8.7 and run DDL(create table & insert) against it. TDV then performs DDL against backend database so the actual data from Spotfire is stored in the backend database and published...
about 2 years ago in Spotfire Data Virtualization / sql support 0 To be Reviewed