How to automatically set a property value to the last loading date

[Manuel NOVO-LOPES]

hi all,

 

I would like to have a label in a text area that display the last loading date of a particular table (the information I want is showed below).

Another way to put the question:How to automatically set a property value to the last loading date

Thanks for your help!

[Fredrik Rosell 3]

Hello,

 

There is (to my knowldge) currently no way to get that information directly through the Spotfire API (previously also discussed in thiscommunity thread: https://community.tibco.com/questions/get-last-reload-date-data-table-ap... - that thread is rather old now, but the information is still valid today).

A method I have seen used to achieve similar results is to include the datetime value in the data itself, so e.g. if you are retrieving data from an information link, create a column element that justreturns the sysdate (or whatever is available in your data source to get the current date/time) and include that in your information link. In your text area label, you could now reference that data.

 

Best Regards

Fredrik