With runtime filters, you can filter an answer or pinboard through URL query parameters. Use this approach with the Data API, and with embedded answers and pinboards.
Use runtime filters to filter data at the time of retrieval; see Data REST API.
In this example, the Pinboard URL uses the runtime filter on the column
Color, and returns values that are equal (EQ) to "red".
In this example, the URL for a Data REST API call uses a runtime filter on the column
Category, and returns values that are equal to
http://<thoughtspot_server>:<port>/callosum/v1/tspublic/v1/pinboarddata? id=e36ee65e-64be-436b-a29a-22d8998c4fae&col1=Category &op1=EQ&val1=mfgr%2324
ThoughtSpot attempts to find a matching column in the pinboard or visualization using the
col field as
You can add any number of filter sets by adding additional parameters for columns, operations, and values to the URL. For operators that support more than one value, pass
val1=foo&val1=bar, and so on.
If the pinboard or answer already has one or more filters, ThoughtSpot combines runtime filter(s) in an
This means that the returned data must meet the conditions of all filters, those supplied in the runtime filter, and those included in the pinboard or visualization itself.
Supported Data Types
You can use runtime filters with the Data REST API to create dynamic controls in your application. For example, you could use the Data REST API to get a list of possible filters for a visualization. Then use that data to populate a select list in your Web application. When a user selects an option, the application passes that option as a runtime filter. The resulting answer or pinboard satisfies the conditions of the filter.
Limitations of runtime filters
Runtime filters do not work directly on top of tables. You must create a worksheet if you want to use runtime filters. This means that the pinboard or visualization on which you apply a runtime filter must be created from a worksheet.
When creating an aggregated worksheet from an answer, you can only use runtime filters if the answer was formed using a single worksheet. If the answer from which you create the worksheet includes raw tables or joins multiple worksheets, you cannot use runtime filters on it. This is to prevent join path ambiguity.
Runtime filters do not allow you to apply
You cannot apply a runtime filter on a pinboard or visualization built on tables whose schema includes a chasm trap. See the information on handling Chasm traps and Formula support for chasm trap schemas.