Skip to content

Instantly share code, notes, and snippets.

@abacijson

abacijson/.sql

Last active March 9, 2021 15:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save abacijson/dcc600813f3e2ec2976b4af24f06ef94 to your computer and use it in GitHub Desktop.
Save abacijson/dcc600813f3e2ec2976b4af24f06ef94 to your computer and use it in GitHub Desktop.
Download ZIP
ns case statement 1
Raw
.sql
CASE
WHEN {createdfrom.type} IN ('Quote') THEN
'<a href=https://tstdrv1030806.app.netsuite.com/app/accounting/transactions/estimate.nl?id='||{createdfrom.internalid}||'>View  '||{createdfrom}||'</a>'
WHEN {createdfrom.type} IN ('Opportunity') THEN
'<a href=https://tstdrv1030806.app.netsuite.com/app/accounting/transactions/opprtnty.nl?id='||{createdfrom.internalid}||'>View '||{createdfrom}||'</a>'
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment