Clarity

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

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

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?

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

This is perfect, thanks!