Spotfire - Can we retrieve only selected records in the cursor

[Velmurugan Natesan]

Hi All, 

I have around 5000 records in my tables, but i want to get only few rows in the cursor, for ex. age>50,  is that possible, your idea/inputs would be great. 

for row in activeTable.GetRows(rowsToInclude,cursor1):

Regards, 

Velmurugan

[Gaia Paolini]

You need to mark the rows you want and set rowsToInclude accordingly.
This link should help:
https://spotfired.blogspot.com/2014/02/mark-selected-row.html

[Velmurugan Natesan]

Thanks for the response Gaia Paolini. 

My actual requirement is, I want mark the rows the selected records from table 1 to table 2, I achieved through below script, but still expecting to limit records in the 'cursor'(highlighted line), because I dont want to loop all records let say 5000 records in the table 2, so is there any way to limit only particular records for ex. age >50

for row in DataTableSelection.GetRows(rowsToInclude,cursor):   table 2, let say we have 5000 records, I need limit records is, is there any way to limit?
        for row1 in DataTableSelection1.GetRows(rowMask1.AsIndexSet(),cursor1): # table 1, marked records rows, let say we only 10 marked rows.
              aTag = cursor.CurrentValue
              aTag1 =cursor1.CurrentValue
              t=aTag1.find(aTag)
              if t >= 0 : 
                  rowsToSelect[idx]=True
    idx=idx+1
 
marking.SetSelection(RowSelection(rowsToSelect), DataTableSelection)

Your idea/suggestions would be great. 

Thanks,

Velmurugan

[Gaia Paolini]

isn't the code you shared working to achieve your requirement? Please can you clarify what the issue is with it?