Spotfire TERR filter table from multi-list property control?

162 Views Asked by At

I have a TERR data function that takes an input table and outputs a duplicate of that table (pretty standard stuff). What I'm trying to do is filter it from a multi-list property control. The table.column and the property control are both dates (specifically, data.column is datetime and the property control shows as Date List). I know how to filter a viz using data limiting:

$map("[TestID] = Date('${pcMultiListBox}')", " or ")

'TestID' is the column name that I want to filter in TERR function before outputting the duplicated input table. The property control iteslf is a Data List (1/9/2022, 1/1/2022, 1/5/2022 ) but when I input it via input parameters in the TERR function and then output it as a value then it displays as a long string. I'd like to do this via TERR and ideally do not want to strsplit and convert all dates to strings and then do the same for my column and use some sort of 'TestID' in as.Character(pcMultiListBox)' etc. Also thought about breaking the string on comma and inputting into a list then iterating through it if 'TestID' is = iteratedDateIDElement but don't want to use a for-loop if possible.

0

There are 0 best solutions below