Historian tag names with $
# umh-supportt
trentc
10/14/2024, 9:53 PMNot sure if this is the appropriate place for this….
historian tags are being stored with a name containing a “$ “ instead of the “_”
trentc
10/14/2024, 9:56 PMAuto generated query for grafana returns no results
SELECT name, avg(value) as "weather_humidity", time_bucket('$__interval', timestamp) AS time
FROM tag
WHERE asset_id = get_asset_id_immutable(
'40Hero',
'del',
'lab',
'edge2'
)
AND name = 'weather_humidity'
AND $__timeFilter(timestamp)
GROUP BY time, name
ORDER BY time DESC;
trentc
10/14/2024, 9:57 PMj
jermuk
10/15/2024, 7:07 AMThank you! FYI @Athavan kanapuli @ricci2511
jermuk
10/16/2024, 2:33 PMshould be fixed now 🙂
t
trentc
10/17/2024, 9:49 AMThanks for this, but how do we upgrade for the fix?
j
jermuk
10/17/2024, 9:58 AMFrontend upgrade go online directly
jermuk
10/17/2024, 9:58 AMSo it should be applied already
jermuk
10/17/2024, 9:58 AMDo you still have the issue?
t
trentc
10/17/2024, 11:30 AMStill have issue
trentc
10/17/2024, 11:32 AMwait...i'm verifying...that is old from yesterday...
trentc
10/17/2024, 12:33 PMwhat was the resolution here? We are keeping the $ as the delimiter? and just updating the queries?
trentc
10/17/2024, 12:34 PMbecause yes my queries are now using the $ as well as the name separater
j
jermuk
10/17/2024, 1:00 PMThe resolution was to correctly update the sql eyries to include again the dollar sign separator
t
trentc
10/17/2024, 1:01 PMok, yes things are good....it stores in the DB with the $ and the front end queries also have $....so we're good!