Product: TIBCO Spotfire®
How to mark the intersection or union of values for various columns through a configuration block URL
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:
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')");
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