Sample query expressions for ProcessValues
- Last UpdatedFeb 09, 2024
- 1 minute read
CQProcessValues
{
"QueryName": "CQProcessValues",
"SelectColumn": ["FQN","DateTime","OpcQuality","Text","Value"],
"Tag": {
"Filter": "startswith(Location,'/Lake')",
"Select": ["FQN"]
},
"StartDateTime":"[RequestedStartTime]",
"EndDateTime":"[RequestedEndTime]",
"RetrievalMode":"Full"
}
CQProcessValuesSameDataSet
{
"QueryName":"CQProcessValuesSameDataSet",
"SelectColumn": ["FQN","DateTime","OpcQuality","Text","Value"],
"Source":"Weather"
}
CQProcessValuesTagTypes
{
"QueryName": "CQProcessValuesTagTypes",
"SelectColumn": ["FQN","DateTime","OpcQuality","Text","Value"],
"TagType":"Discrete,String"
}
ProcessValues
{
"QueryName":"ProcessValues",
"Select":"DateTime, FQN, Value",
"Tag": {
"Filter": "startswith(Location,'/Lake') AND endswith(FQNS,'.temperature')",
"Select": ["FQN"]
},
"RetrievalMode":"Average",
"StartDateTime":"[RequestedStartTime]",
"EndDateTime":"[RequestedEndTime]",
"Expression":"UOM(°C)"
}
ProcessValues for Time Defining Dimension
TimeDeadband
{
"QueryName":"TDDProcessValues",
"SelectColumn": ["FQN","TagName","Source","Location","Text", "DateTime AS StartTime","DateTime AS EndTime"],
"DistinctColumn": ["FQN","TagName","Source","Location","Text", "DateTime AS StartTime","DateTime AS EndTime"],
"Tag": {
"Filter":"startswith(FQN,'DataSource1')"
},
"StartDateTime":"[RequestedStartTime]",
"EndDateTime":"[RequestedEndTime]",
"TimeDeadband":5000,
"RetrievalMode":"Delta"
}
ValueDeadband
{
"QueryName":"TDDProcessValues",
"SelectColumn": ["FQN","TagName","Source","Location","Text", "DateTime AS StartTime","DateTime AS EndTime"],
"DistinctColumn": ["FQN","TagName","Source","Location","Text", "DateTime AS StartTime","DateTime AS EndTime"],
"Tag": {
"Filter":"startswith(FQN,'DataSource1')"
},
"StartDateTime":"[RequestedStartTime]",
"EndDateTime":"[RequestedEndTime]",
"ValueDeadband":"20",
"RetrievalMode":"Delta"
}
TimeDeadband and ValueDeadband
{
"QueryName":"TDDProcessValues",
"SelectColumn": ["FQN","TagName","Source","Location","Text", "DateTime AS StartTime","DateTime AS EndTime"],
"DistinctColumn": ["FQN","TagName","Source","Location","Text", "DateTime AS StartTime","DateTime AS EndTime"],
"Tag": {
"Filter":"startswith(FQN,'DataSource1')"
},
"StartDateTime":"[RequestedStartTime]",
"EndDateTime":"[RequestedEndTime]",
"TimeDeadband":5000,
"ValueDeadband":"20",
"RetrievalMode":"Delta"
}