Smart URL Link to Navigate to Specific Data Tag and Time Range

[Juan Espiga]

Hi - I am looking for support/guidance on how to develop a smart URL that can take me to a specific tag ID/name and fixed time range (i.e. last 7 days). The application in my case is the following: I have a PowerBI dashboard that has summarized data for multitude of tags and want user to be able to click on a link within that dashboard to take them the detailed SEEQ data or a specific tag without having to go into SEEQ, search that tag and manually set a specific time range.

Thanks!

[John Cox]

Hello Juan, 

Seeq has built-in functionality to do what you have asked. Please see the documentation here: Building a Worksheet from a URL

There are example URLs in the documentation that you can copy/edit to take the Power BI user to a specific tag and time range in Seeq Workbench. 

John

[Juan Espiga]

John - thanks for the response; I was able to make some progress using the documentation you provided. One question on the smart URL. Is there a function in the smart link to only pull up a tag name that matches exactly what I input, not tags that contain that input as a string. Example described below:

Need to pull data using trendItems=TAGNAME. When I go to the link it pulls up TAGNAME (what I want), and also adds (if available) TAGNAME1, TAGNAME2, TEST_TAGNAME, because it contains the string "TAGNAME".

Thanks!

[John Cox]

Hello Juan,

Glad you are making progress. Please try this.

In the URL, use a regular expression search for an exact match on TAGNAME. Without the regular expression search syntax, the search looks for anything containing TAGNAME, as you observed in your results.

Therefore, when you specify the trendItems in the URL, put a /^ in front of TAGNAME and a $/ after TAGNAME. This is the way to do an exact match using regular expressions. For example: 

&trendItems=/^TAGNAME$/

Also, if interested there is more at this link for regular expression searches. Also note that you can search for tags by description and datasource (examples included in the URL builder documentation).

Hope this helps!

John

[Juan Espiga]

Thanks for the help, John. For some reason the solution doesn't seem to be working with majority of my tags. Most of my tags have "ANA." on the front end of them; not sure if that has anything to do with it. Tried removing the "ANA." and that did not work either.

Here an example link that doesn't work (I am removing the real tag name for privacy reasons). Mainly want to make sure that the format of the link below is correct.

https://hoewap274.na.xom.com/workbook/builder?workbookName=ana.TAGNAME&trendItems=/^ana.TAGNAME$/&displayStartTime=2024-10-08T00%3A00%3A00Z&displayEndTime=2024-11-07T00%3A00%3A00Z

Edited November 7 by Juan Espiga

[Thorsten Vogt]

Hi Juan,

the regular expressions you are using is case sensitive. So if your Tags start with "ANA." you need to change the Regex to

/^ANA.TAGNAME$/

or append an "i" at it

/^ana.TAGNAME$/i

to avoid case sensitivity.

Regards,

Thorsten

Edited November 7 by Thorsten Vogt