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:


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. 



(1) Answer