Is it possible to link the Manager_ID field from Clarity.INV_INVESTMENTS directly to email upon someone clicking on it within a portlet?
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.
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 INVINNER JOIN SRM_RESOURCES R ON R.USER_ID = INV.MANAGER_IDWHEREINV.IS_ACTIVE = 1 AND @FILTER@
Add a link
Create a portlet from the query
Create a virtual attribute in layout
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!