Can I paste a list of values into a Filter's search box

[Georgi Koemdzhiev]

I am wondering if there is a way to paste a list of values (e.g. well ids) into the Spotfire Analyst's (and Web Player's) filter search box I am new to Spotfire so not sure if that can be achieved through a custom extension or script. Basically this is what I am trying to achieve:

 

I copy some values from Excel spreadsheet

I open Spotfire Analyst and look for the appropriate filter on the right

I pates the content of my clipboard into the filters search box

Custom logic (if thats possible) makes sure to find the appropriate results from the filters list and selects them automatically

All charts on our page are updated and we see the results from step 4

 

 

Please note that the solution needs to work on both the Spotfire Analyst and Web Player.

[Michael Kalada 2]

You can set filters programatically yes, but why would you want to do that/What are you trying to achieve

[Georgi Koemdzhiev]

Basically, the main reason for that it's because it's quicker. For example, I copy a few values from Excel spreadsheet and paste those as filters into the search box. It's just very convenient. 

[Michael Kalada 2]

OK, in that case yes you can do it, but you'd have to seperate them with an "or"

So in your example youd have to paste "42479418930000 or 4247941966000"

If you paste that into a list box filter it will limit whats in the list box, but you'll still have to select them. If you right click on your list box filter and switch it to filter type text filter, just pasting those values into the text box with the "or" will filter your visuals automatically

[Georgi Koemdzhiev]

Thank you for your suggestion, Michael. This is getting to closer to my desired behaviour. Do you know if there is a way how to avoid forcing the user to preformat the values in this fashion - "value1 or value2 or value3" For example, hooking to a "text change" event of the Filter's search field that will execute an IronPython script that will format the pasted values and split them in the above format so that the filter will understand them

 

Thanks

[Michael Kalada 2]

Only thing a filter "text change" can trigger is a terr script, but I'm not sure if a terr script can take the filter text as input, in any event that would be a clunky overkill solution prone to failure.  If i was doing the development and this was a requirement i'd either create an input field that populated a document property, then add a button that would parse the input and use it to filter

 

or

 

create an upload button that would suck the values from excel/text file/clipboard into spotfire and create a table join, then in the filter panel choose to only include filtered rows.

[Georgi Koemdzhiev]

Thank you for adding more detail to your original answer. I will accept your answer as it does help me with the course of my requirement. I can sum up my findings and offer those to my client. Thanks