Can I use RawData and IntData on the same query on citadel 5?

[bruno_costa]

Hi,

I'm trying to use the query below to maintain trend info in a citadel query.

SELECT IntData.LocalTime, IntData."BOIBUMBA/NUEX/C7981"
FROM IntData
WHERE (IntData.LocalTime BETWEEN (SELECT MAX(RawData.LocalTime) FROM RawData WHERE RawData.LocalTime <= {ts '2011-07-01 11:41:45'}) AND (SELECT MIN(RawData.LocalTime) FROM RawData WHERE RawData.LocalTime > {ts '2011-08-01 11:41:45'}))
AND (IntData.IntInterval = '0:1')

The driver returns "No trace was specified".

Can I use IntData and RawData in the same query? Can I use subqueries like this above? Where to find documentation about SQL queries in citadel? Are citadel driver SQL-92 compliant?

[Mauro Vera]

Good afternoon, Bruno,

Follow the links to help better understand the use of each function. Any questions please contact us.

Accessing Citadel 5 Data from Other Software

 https://knowledge.ni.com/KnowledgeArticleDetails?id=kA03q000000x5PYCAY&l=en-US

Accessing Citadel 5 Data with Microsoft Excel 2007

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA03q000000x20pCAA&l=en-US

Sincerely,

Mauro Vera.

[bruno_costa]

Hi Mauro

I read this articles and doesn't have what I want. I want make a query thats I will get start and stop time from RawData and then get interpolated data from IntData in this interval.

Many thanks for the help.

Bruno Costa