SELECT name, value as ProductInfo_batchN...
# umh-support
d
SELECT name, value as ProductInfo_batchNumber, time_bucket('$__interval', timestamp) AS time FROM tag_string WHERE asset_id = get_asset_id_immutable( 'Mayker', 'Ghent', 'DigitalTwin', 'PickAndPlace', 'Portal' ) AND name = 'ProductInfo$batchNumber' AND $__timeFilter(timestamp) GROUP BY time, name, value ORDER BY time DESC;