Property control with search and mark

[Manoj Chaurasia]

I want to create a text are with the following:

 

an input field that will act as a search

a property control (list box multi) that lists the contents of a column

a button with a script to limit the contents of that property based on the search

a button to mark the selected values from that property in the data

 

I can create most of this, but I'm stuck on being able to link the search input field to the property to limit the data.

I found this code online:

from Spotfire.Dxp.Data import DataPropertyClass

import re

 

patternString = re.compile(pattern)

 

for tmpCol in Document.ActiveDataTableReference.Columns:

matchObj = patternString.search(tmpCol.Name)

if matchObj:

tmpCol.Properties.SetProperty("IsIncluded",True)

else:

tmpCol.Properties.SetProperty("IsIncluded",False)

 

for tmpCol in Document.ActiveDataTableReference.Columns:

print tmpCol.Properties.GetProperty("IsIncluded")

 

#records = Document.Data.Properties.GetProperty(DataPropertyClass.Column, "IsIncluded").ValueBut it is selecting columns of data, not values from a column, how would I adjust the script

Thanks for the help.

D

[luo jianping]

I WANT EITHER    AND HOW TO USE

[Manoj Chaurasia]

Hello Dore, I am trying to use this same code in one of my files. Did you ever find a way around it and if so can you share Best Regards,

Wajid

[Vivek Kumar 10]

Hello Dore,

You can achive it without script as well. Follow the steps in post below and you can achieve first three steps without any IronPython.

https://myspotfire.blogspot.com/2019/10/search-within-column-limiting-values-in.html

You simply need to write code for marking now :)