Spotfire Ideas Portal
Data connections are a fast but pretty limited way to add data to analysis.
While it is nice to be able to use direct SQL, it is limiting that it is not easy to pass parameters that would allow logical WHERE Conditions.
Today we can only pass inputs to columns available on query results but are not able to pass a condition to a parameter element that is not in the result set.
e.g. Select columns ColumnA, ColumnB, ColumnC from table where (?Param A like (ColumnX) or ?Param B Like(ColumnY)
I do acknowledge that I can add parameters to the query and edit the query to accommodate conditions, but it would be good to be able to manipulate input attributes via an expression as the on-demand settings configuration point. Its certainly not intuative to use a range to set a >= and not possible I believe to set a != value as an input