cut/paste multiple values into a text filter

[david hicks 2]

Im new to spotfire... so maybe there is an obvious way to do this and I am missing it

so I have spotfire sitting on top of a a large db. We are trying to use spotfire as a descriptive tool to monitor changes etc.. in the db. But it would also be very useful to be able to query a primary key by dropping in a list of values of interest.

is it possible to create a text box that I could query this field by dropping a list of values .. say

12345678

59632456

25032456

and return all the relevant data associated with these primary key's in the source data

This sort of query always starts external to spotfire.. i.e we want to know something about the data associated with a handful of values (might be 10 values or a thousand values). Ideally this could accomodate a cut/paste from excel into a text box, but if it had to be comma delimitated that would work too.

Regards

[Russell Eskew]

I have been trying to accomplish exactly this for some time.  Has anyone figured a way to copy and paste to filter too yet

 

Thx

[DivyaJyoti Rajdev]

Create an InfoLink with your wuery as stored procedure, configure it as details on demand with property as input. (Source)

Now in Spotfire you can create multi line inputs for properties (edit text area > insert property control > multi line input) this will let you past values into it.

Depending on DB configuration etc you might have to add quotes or commas after each value but if it's just static formatting a simple IronPython script will resolve it.

[Kyle LaMotta 2]

I recently posted a blog on this:https://www.datafuel.co/filter-to-pasted-values/

[Steve Ennis 2]

Been trying to use you script but keep getting errors in the Data Function Properties:Data function UWIListFilter debug outputUnmarshalling 1 input parameters.

Input 'inputValues', sent by inline XML

chr ""

Done unmarshalling input parameters.And the following TERR error:TIBCO Enterprise Runtime for R returned an errorThe data function 'UWIListFilter' could not be executed.Error in .internal.sub(pattern, replacement, x, ignore.case = ignore. : object 'potential.header.fields' not found

    eval(expr, envir, enclos)

    eval(expr, envir, enclos)

    read.csv(connValues)

    read.table(file = file, header = header, sep = sep, quote = quote,

    gsub("^\s|\s$", "", unlist(potential.header.fields))

    .internal.sub(pattern, replacement, x, ignore.case = ignore.case,

 Any pointers to fix the script would be helpful.