How to delete marked rows based on certain condition using IronPython

[Andrew Hue]

Hello there,

I've been trying to find a way to delete a marked row(s) where one of the columns matches a specific value. In this case, I want to allow deleting rows only when a "username" attribute matches the current username.Here's what I have so far:

 

from Spotfire.Dxp.Data import *

from System.Threading import Thread

 

#assign marked rows into variable

selectedRows = Document.Data.Markings["Marking"].GetSelection(Document.Data.Tables["MyTable"])

 

#create data cursor on a the "Username" column

cursor = DataValueCursor.CreateFormatted(Document.Data.Tables["MyTable"].Columns["Username"])

 

#loop through the column rows, then retrieve the values and then check against current username.

for row in table.GetRows(cursor):

value = cursor.CurrentValue

if value == Thread.CurrentPrincipal.Identity.Name:

Document.Data.Tables["MyTable"].RemoveRows(selectedRows)Anyone know the right way to do this

Would appreciate any help!

Thanks.

[Nawaz Ali Mohammad]

My best would be is to use the conditions you want under "Hide/Show items" option or using "Limit data using expression".

[Andrew Hue]

Hi Nawaz,

 

Thanks for the reply. But I really need some type of interactive way for users to select and delete a marked row from a table visualization. Hopefully, someone reading this post would be able to share some way to do this...

[Matthew Stahl]

Hi Anthony,

Give this script a shot:

from Spotfire.Dxp.Data import *

from System.Threading import Thread

#assign marked rows into variable

table = Document.Data.Tables["MyTable"]

markedRows = Document.Data.Markings["Marking"].GetSelection(table)

userRows = table.Select("[username] = '%s'" % Thread.CurrentPrincipal.Identity.Name)

set1 = IndexSet(markedRows.AsIndexSet())

set2 = IndexSet(userRows.AsIndexSet())

rowSelection = RowSelection(set1.And(set2))

table.RemoveRows(rowSelection)