How to mark all rows in a table in a filtering scheme based on filtering

[B I]

Hi all,

I want to mark all of the rows in a table ("myTable") that match the filters within a filtering scheme ("filtScheme"),.

I can mark all rows in my table using:

from Spotfire.Dxp.Data import *

rowCount = myTable.RowCount

rowsToMark = IndexSet(rowCount, True)

for marking in Document.Data.Markings:

marking.SetSelection(RowSelection(rowsToMark), myTable)but I only want to mark the rows that match the filtering that is applied on that table in a given filtering scheme. How do I do this

Cheers,

Ben

[Khushboo Rabadia]

You can use below script:

from Spotfire.Dxp.Data import *

rowSelection = Document.ActiveFilteringSelectionReference.GetSelection(myTable) #myTable is the datatable script parameter

 

for marking in Document.Data.Markings:

marking.SetSelection(rowSelection, myTable)