How to mark the intersection or union of values for various columns through a configuration block URL
Article ID: KB0079652
Updated On:
| Products | Versions |
|---|---|
| Spotfire Web Player | All Versions |
Description
It may be a requirement that a user wants to mark a union or an intersection of values on various columns when an analysis is loaded from the Web Player. The same can be achieved through the usage of a configuration Block URL as is shown in the resolution section below:
Issue/Introduction
How to mark the intersection or union of values for various columns through a configuration block URL
Environment
All Supported OS
Resolution
Below are sample URLs to show how an intersection or union of values for two columns may be marked through the implementation of a configuration block URL:
&configurationBlock=SetMarking(tableName="Baseball", whereClause="[Player Name] IN ('Juan Castro', 'Tino Martinez') OR [Position] IN ('1B', '2B')");
&configurationBlock=SetMarking(tableName="Baseball", whereClause="[Player Name] IN ('Juan Castro', 'Tino Martinez') AND [Position] IN ('1B', '2B')");
&configurationBlock=SetMarking(tableName="Baseball", whereClause="[Player Name] IN ('Juan Castro', 'Tino Martinez') OR [Position] IN ('1B', '2B')");
&configurationBlock=SetMarking(tableName="Baseball", whereClause="[Player Name] IN ('Juan Castro', 'Tino Martinez') AND [Position] IN ('1B', '2B')");
Additional Information
Wiki: Create a Configuration Block in TIBCO Spotfire
https://community.tibco.com/wiki/create-configuration-block-tibco-spotfire
KB: 000021316 How to pass a configuration block to the Web Player analysis file
https://support.tibco.com/s/article/Tibco-KnowledgeArticle-Article-44854
Feedback
Yes
No
Powered by
