Clarity

Expand all | Collapse all

Portlet Linking to Email - Possible?

Jump to Best Answer
  • 1.  Portlet Linking to Email - Possible?

    Posted 07-31-2017 02:01 PM

    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



  • 2.  Re: Portlet Linking to Email - Possible?

    Broadcom Employee
    Posted 07-31-2017 03:59 PM

    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



  • 3.  Re: Portlet Linking to Email - Possible?

    Posted 08-01-2017 06:07 AM

    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?



  • 4.  Re: Portlet Linking to Email - Possible?
    Best Answer

    Posted 08-01-2017 12:20 PM

    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



  • 5.  Re: Portlet Linking to Email - Possible?

    Posted 08-01-2017 02:24 PM

    This is perfect, thanks!