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

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

book

Article ID: KB0079652

calendar_today

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:

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')");

Issue/Introduction

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

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