Clarity

 View Only

TECH TIP: How to Create a mailto hyperlink (with subject) in a NSQL portlet

By Andrew M posted Aug 07, 2017 03:52 AM

  

How to create a mailto hyperlink in portlets

Time to read 1 minute

 

 

Create an NSQL query like below

SELECT
@SELECT:DIM:USER_DEF:IMPLIED:PROJECT:INV.ID:PK_ID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:INV.CODE:PROJECT_ID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:INV.NAME:PROJECT_NAME@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:R.FULL_NAME:MANAGER_NAME@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:R.EMAIL||'?Subject=Hello%20World':EMAIL@
FROM
INV_INVESTMENTS INV
INNER JOIN SRM_RESOURCES R ON R.USER_ID = INV.MANAGER_ID
WHERE
INV.IS_ACTIVE =1
AND@FILTER@

 

Add a link

 

Create a portlet from the query

 

Create a virtual attribute in layout

 

Click Next

Choose Send Email and the link you created and save

 

Add that virtual image to the portlet and when you click on the link....

 

email and subject populated as you want

0 comments
3 views

Permalink