cancel
Showing results for 
Search instead for 
Did you mean: 

How to pass 100+ tags in a single sql/tag query

Former Member
0 Kudos

<b>In my current application I have to pass 180+ tags in a single query to retrieve data from iHistorian.

I want to know how to pass more thatn 100 tags in a single SQL or TAG Query using OLEDB or UDC connectors.

If anybody has done it in the past ,please share with me and also let me know how to do it</b>

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Currently you can only query a maximum of 128 tags, this is a hard limit and may be changed in future releases of xMII, but < 11.5 (im fairly sure 12 also) all have the limit of 128.

As for iHistorian with the OLEDB UDS, you can write a query that would return over 128 queries becasue this is an input limitation on the UDSs. (PLEASE DON"T ASK US HOW TO WRITE iHistorian QUERIES... we aren't experts in iHistorian).

Please note that though you can query over 128 tags, the performance may not be what you expect... This may take a very long time to return.

Martin

Former Member
0 Kudos

Out of curiosity, why do you need to do this? Seems excessive for a single query.

I suspect there's a better way.