I am using Spotfire with PI. My question is there any ability that I can have like input boxes where I can select the dates and acquire the data every time. The issue popped up when we needed to pull several dates ranges for the same tags.
Are you requesting assistance with the implementation of the input boxes in Spotfire, or assistance with building the PI OLEDB queries that run behind the scenes.
If you're using PI OLEDB Provider, then the query would be easy to build with such as with the piinterp2 table:
and with multiple time ranges simulatenously as well:
If your request is for assistance with the Spotfire side of things, we can't be of too much assistance for you there, but the TIBCO support staff should be able to help.
Thanks Kalsey, actually I am interested in implementing an input box in Spotfire where I can pull up the data according to the input. I see what you suggested in using OLDEDB also worth looking at, now my question can I feed the query of OLEDB from input boxes? i.e. dates ranges, tags names
Ok, in that case I would encourage you to reach out to Tibco Support. Someone on this forum may be able to help you, but you're much better off contacting Tibco for assistance with Spotfire.
Retrieving data ...