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;