Filter rows using IronPython

[Pei Hsuan Shen 2]

I am using spotfire version 10.0. I am trying to filter the rows using IronPython if the rows fit some conditions. However, I only find FilterRowsTransformation (version 10.1....). Is there any syntax to replace it Thank you.

[Shashank Gurnalkar]

Can you check the following Wiki article

https://community.spotfire.com/wiki/how-get-or-set-specific-filter-using-ironpython-script-tibco-spotfire

[Pei Hsuan Shen]

I just want to filter the values, like ['size'] = 'X' (code in SQL) in a table. How to execute the filter The method you suggest has to set Document.FilteringSchemes, but I don't know how to set the FilteringSchemes. (I need to filter the table I want by some rule in a loop, but I don't know how to write it.)

 

I have used [cursor = table.Select(" = 'L'")]. However, I don't know how to make the table return the selected rows I want.

[Shashank Gurnalkar]

By default, you always have one filtering scheme with name "Filtering scheme" on basis of which filtering happens when you update any filter. 

 

 

If you have not changed anything, you can use that part in the code as it is. Now you only need to change the column name in that code with the column you have, and also change the array value with the values you want to pass. Make sure to have the filter-type as List Box otherwise modify the code according to the filter type you are using.