David B
10/06/2020, 5:01 AM{item.internalid}
and {item}
were mistakenly encoded (to "%7C%7C")
Also the html attribute values need to be wrapped in quote marks (i.e. target="_blank"
).
That should be itDavid B
10/06/2020, 5:02 AM'<a target="_blank" href="<https://accountid-sb1.app.netsuite.com/app/common/search/searchresults.nl?searchtype=Transaction&Transaction_ITEMtype=ANYOF&Transaction_ITEM='%7C%7C{item.internalid}%7C%7C'&detail=Transaction_ITEM&detailname='%7C%7C{item}%7C%7C'>">'||TO_CHAR(COUNT({internalid},)'999')||'</a>'
Aria Ghahari
10/06/2020, 11:36 AM