Been using Spotfire a lot and wanted to share interesting bits.
I needed a table that allowed a user to change a value in a row and save this back to the database.
This required a DropDownListColumn, which currently doens't exist in Spotire - so I wrote one.
On a button click event, I used IronPython to generate dynamic JQuery and HTML elements to build the functionality/
The data table concerned is looped through in Python and the relevant HTML tags are concatenated into a large string.
The column concerned with the DropDownList just has one declared.
When the value in the dropdownlist is changed, a JQuery event is fired that saves it back to a hidden textbox, along with the primary key field, separated by a colon.
Once the save button is clicked a JQuery event is raised that loops through the textboxes and save the data into a comma separated array.
This array is converted to a String and placed inside a Spotfire Document Control property.
Using JQuery commands of Focus and Blur imitates the user going into the textbox, triggering Spotfire to change the Document Property to the value in the Property Control element.
We can then use a Python script event attached to the Document Property to decode the Array and save the data back to the database.
Pretty long winded, but it so far it seems to work really well.
The code below is the Python that generates the HTML and JQuery
#Variables:
#dataTable (Table containing rows to loop through - this is the source that I wish to add a dropdownlist column to)
#page - page which contains the TextArea
#visTA - text area we are going to drop the HTML into
dataTable.Refresh()
#get list of filtered rows
rows = Document.ActiveFilteringSelectionReference.GetSelection(dataTable).AsIndexSet()
#generate Javascript function
html = " \n"
#generate html table
#generate html head
html += "
\n"
#show results
from Spotfire.Dxp.Application.Visuals import TablePlot, HtmlTextArea
ta = visTA.As[HtmlTextArea]()
originalHtml = ta.HtmlContent
endOriginal = originalHtml.find("")
endOriginal = endOriginal + 10
ta.HtmlContent = originalHtml[0:endOriginal] + html
print html
Document.ActivePageReference = page
This is a snippet of the HTML generated above. Everything from the "/STYLE" tag up isn't generated dynamically, the dynamic HTML is appended after this, as you can see in the code above.
