Skip to Content

Dynamic hyperlink to external sources in WEBI

Hi All,

I have a requirement to have a hyperlink from webi to external source i.e., ServiceNow page.

The object to be used for linking is the number([Dv Number]) field in webi.

webi-report.png

On clicking the DV Number column, a new window should open dynamically.

The URL for ServiceNow is as below:

https://********.service-now.com/tablename.do?sysparm_query=number=PRJ0034058

(Here the project number (PRJ0034058) should be dynamically changing.)

Column name > Linking > Add Hyperlink and gave the below details:

linking.png

By using this, the number is not getting parsed, when I click on the hyperlink, all the project numbers are showing up in ServiceNow but not the selected project number,

Can someone please suggest and help on resolving this?

Thanks,

Poojitha

webi-report.png (9.8 kB)
linking.png (29.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 19 at 02:48 PM

    Hi All,

    I was able to achieve the dynamic hyperlink by using the below and making the content as "hyperlink"

    But with this, the the page doesnt open up in a new tab but it shows as below.

    untitled.png

    ="<a href='https://******.service-now.com/******888.do?sysparm_query=number%3D"+[Roadmaps].[Dv Number]+"'>"+[Roadmaps].[Dv Number]+"</a>"

    Can someone pls let me know the syntax to open the page in a new tab.

    Thanks.

    
                                                
    Add comment
    10|10000 characters needed characters exceeded