How to mark the intersection or union of values for various columns through a configuration block URL

Created
October 08, 2021 23:21

Date Posted: 2019-01-15
Product: TIBCO Spotfire®

Problem:

Solution:

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