Dynamic hyperlink to external sources in WEBI

[former_member334960]

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

[sameer_ahmed_bi]

I have similar requirement, do we have answer for this scenario

[former_member334960]

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.

[former_member334960]

Resolved it.

[nscheaffer]

How did you resolve it? Someone may come across this in the future and it would be helpful for them to know what your solution was.

Noel