Hello,
I have created a report that shows data from a custom table of new hires loaded from our HR system. In that report I want to create a column that is a link to another page in ServiceNow that uses the employee ID as a parameter. I can't figure out how to have the report show a label such that when you click on the label it opens up the other URL.
I am using the option "Configure function field" in the report editor and tried the options below.
If use the function field with return type of URL, I can build a URL but that raw URL appears in the report column. I cannot provide enough values to generate something similar to <a href="<path>">label</a>.
Return type: URL
Definition: glidefunction:concat("<path>?id=",emp_id)
Column output in report, which is clickable:
- <path>?id=1234
- <path>?id=2345
If I use the function field with return type HTML, then I can build an HTML string, but that raw HTML is displayed in the report column. I am not sure why it isn't interpreted. Otherwise, why offer an HTML type?
Return type: HTML
Definition: glidefunction:concat('https://<path>?id=',emp_id)
Column output in report which is displayed as text only.
- https://<path>?id=1234
- https://<path>?id=2345
Am I missing a step or does the report editor not allow me to create a labeled link in the report output? Why provide and HTML option if it is not interpreted on display?
Thanks, Bruce...
