How to collect MIN, MAX, AVG mode on more than 128 TAGs ?

[former_member330418]

Hello,

we are using a inSQL connector to connect to an Historian DB.

Thru this connector we define a TAG Query in order to retrieve the needed data regarding the requested TAGs.

This TAG query allow us to request the DB in different modes : Current, GroupList, History,
HistoryEvent, ModeList, Statisch, TagList on which we devine a method : MIN, MAX, AVG, TOT, MIN MAX AVG, MIN MAX TWA, AVG SDV, TWA
SDV .

This TAG query is limited to 128 TAGS while we need much more TAGs in our project.

The idea is to do it thru a PCo Query thru a inSQLPCo connector to connect to the same Historian DB.

Thru this connector we can define a PCo Query to collect all the needed data. But we only have the mode :GroupList, ModeList, TagList, TagRetrieveQuery et ViewList, which does not allow the MIN, MAX, AVG etc.. which are needed !!!!

Did you already face such issue ?  How did you cope with it ?

Thank you for your support.

[Former Member · Accepted solution]

Hi Marc,

You can use TagAggregate Mode of PCo Query.

In the Tag Aggregate Panel of the query you sill find all the aggregates likes Min, Max etc for the PCo Query.

Regards,

Rohit Negi.

[former_member330418 · Accepted solution]

Hi Rohit,

Indeed, this mode is well documented but is missing from our list.  We are using MII 14.0 SP5.  Could it be version related ?

Regards,

Marc.

[Former Member · Accepted solution]

Hi Marc,

You should contact SAP regarding this.

Looks like a bug.

Regards,

Rohit Negi.