Dynamic query parameters in Live datamart custom datasource for Spotfire?

Hi All,



I'm using the Live Datamart custom data source to connect Spotifire and Live Datamart:

https://community.tibco.com/modules/custom-data-source-tibco-spotfirer-r...

I'm having problems to use document properties as dynamic query parameters in the On-demand mode, like in the example below:



select category, lastSoldPrice, transactionTime from ItemSales

when transactionTime between now() - minutes(<myDocumentPropery>) and now()

myDocumentPropery in this case is not showing as parameter in the Data function. So, how can a document property can be passed to this query in the example above? 

Any suggestion will be appreciated. 

Thanks.

 

(1) Answer

Login