Hey community - does anyone know of a way to use the CONCAT feature combine elements to form a hyperlink but only show a shortened view in the report? I would like to do this without using a custom field.
displayname=User Directory
link.isnewwindow=true
linkedname=direct
namekey=view.relatedcolumn
namekeyargkey.0=owner
namekeyargkey.1=emailAddr
querysort=owner:emailAddr
textmode=true
usewidths=true
valueexpression=CONCAT("https://userdirectory.company.com/users/",{owner}.{uniqueUser})
valueformat=HTML
at the moment it shows:
what I want to show:
- uniqueuser (but retain the link)