change SQL of custom query through IronPython

[asier b]

Hi,

with Spotfire, does anyone know how to modify the SQL that defines a Custom Query from IronPython

Thanks

[Shandilya Peddi]

Currently we do not have any API available to access/modify the queries used by a data table.I would suggest you file an enhancement request for that feature in the Ideas portal linked above: http://ideas.tibco.com/

[asier b]

Thanks a lot for clarifying

[Ken Lawrence]

I've done something similar as follows:

from Spotfire.Dxp.Data import *

from Spotfire.Dxp.Data.Import import DatabaseDataSource

from Spotfire.Dxp.Data.Import import DatabaseDataSourceSettings

my_query = "select * from my_table"

my_settings = DatabaseDataSourceSettings("System.Data.Odbc", "DSN=myDSN", my_query)

my_source = DatabaseDataSource(my_settings)

Document.Data.Tables["myDataTable"].ReplaceData(my_source)