Portlet Linking to Email - Possible?

[Legacy User]

Hi,

 

Is it possible to link the Manager_ID field from Clarity.INV_INVESTMENTS directly to email upon someone clicking on it within a portlet?

 

Thanks,

Greg

[Senthil Kumar Lakshmanan]

No. But you can create a customization to implement the functionality.

 

Try in the lower environment.

 

1. create a custom attribute on Project Object.

2. You need update project manager email address whenever project manager changed.

3. Create Link "Link to Email" on project object with action "Link to Email" and Email Address attribute as "Custom Attribute"

4. Configure Custom attribute in the project list layout and enable "Link to Email" Link.

 

Thanks

Senthil

[David Morton]

If you return a constructed "mailto" bit of hypertext in an NSQL portlet, wouldn't the browser just render than as a hyperlink and then clicking on that would open up your email client?

[Andrew M]

I'm not that clear on your actual business use case, but the below will work.

What Senthil suggests is only applicable for system providers, you don't actually need to do that just use NSQL.

 

Dave, sadly HTML is not rendered in list views (although there are hacks  to make it so)

 

 

Here's how to do it

 

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

[Legacy User]

This is perfect, thanks!