Retrieve data using the counter retrieval mode

If you want to enable the Counter retrieval mode, you need to do it at the Measure Calculations level.

This retrieval mode is supported for the following queries:

• CQProcessValues

• CQProcessValuesSameDataSet

• CQProcessValuesTagTypes

• ProcessValues

Use the counter retrieval mode:

1. Select a measure object.

2. Click the Context tab.

3. Click Edit Calculations.

   The screen appears as follows.

   

4. In the Function drop-down list, select Counter. When you select the Counter retrieval mode from the this list, it is implicitly passed to the queries.

5. Save the measure object.

Custom Queries for counter retrieval mode

ProcessValues

{

"QueryName":"ProcessValues",

"SelectColumn": ["FQN","DateTime", "Value","OpcQuality","Text"],

"FQNS":["WonderBrew.Filler.Counter", "WonderBrew.Paletizer.Counter"],

"StartDateTime" : "[RequestedStartTime]",

"EndDateTime": "[RequestedEndTime]"

}

CQProcessValues

{

"QueryName": "CQProcessValues",

"SelectColumn": ["FQN","DateTime", "Value","OpcQuality","Text"],

"Tag": {

"Filter": "startswith(FQN, 'WonderBrew')"

},

"StartDateTime" : "[RequestedStartTime]",

"EndDateTime": "[RequestedEndTime]"

}

CQProcessValuesSameDataSet

{

"QueryName":"CQProcessValuesSameDataSet",

"SelectColumn": ["FQN","DateTime", "Value","OpcQuality","Text"],

"Source":"WonderBrew",

"StartDateTime" : "[RequestedStartTime]",

"EndDateTime": "[RequestedEndTime]"

}

CQProcessValuesTagTypes

{

"QueryName": "CQProcessValuesTagTypes",

"SelectColumn": ["FQN","DateTime","OpcQuality","Text","Value"],

"TagType":"Analog",

"StartDateTime" : "[RequestedStartTime]",

"EndDateTime": "[RequestedEndTime]"

}