]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

Contact ·  Index · Login · Register
 

Contents

Remote Training
Support
SaaS Service

2 registered users
 in last 24 hours

User Related Objects

This portlet shows relations a user has to other ]po[ Objects such as, Projects and Customers. This portlet is can be configured to show several important aspects of relationships. 

Sample Configuration

Example:Show all projects a user worked on so far

Screenshot Last Projects

To use this portlet in order to show all projects a user as worked on, it can configure it the following way:

Configuration

PL/pgSQL script to create portlet

CREATE OR REPLACE FUNCTION inline_1 ()
RETURNS INTEGER AS $BODY$
DECLARE
        v_plugin_id             INTEGER;
        v_employee_group_id     INTEGER;
BEGIN

        SELECT group_id INTO v_employee_group_id FROM groups WHERE group_name = 'Employees';

        SELECT  im_component_plugin__new (
        NULL,                           -- plugin_id
        'acs_object',                   -- object_type
        now(),                          -- creation_date
        NULL,                           -- creation_user
        NULL,                           -- creation_ip
        NULL,                           -- context_id
        'Last Projects',   -- plugin_name
        'intranet-core',                -- package_name
        'right',                        -- location
        '/intranet/users/view',      -- page_url
        NULL,                           -- view_name
        20,                             -- sort_order
        'im_biz_object_related_objects_component -show_projects_only 1 -include_membership_rels_p 1 -hide_rel_name_p 1 -hide_object_chk_p 1 -hide_direction_pretty_p 1 -hide_object_type_pretty_p 1 -object_id $user_id -sort_order ""'    -- component_tcl
        ) INTO v_plugin_id;

        -- Set title
        UPDATE im_component_plugins SET title_tcl = 'lang::message::lookup "" intranet-core.LastProjects "Last Projects"' WHERE plugin_id = v_plugin_id;

        -- Permissions
        PERFORM im_grant_permission(v_plugin_id, v_employee_group_id, 'read');

        RETURN 0;

END;$BODY$ LANGUAGE 'plpgsql';
SELECT inline_1 ();
DROP FUNCTION inline_1();






 


Please take a moment to complete this form to help us improve our service.

Note:
Please only provide feedback in regards to content this page shows. For support inquiries please refer either to the Community Support forum at Sourceforge or check out our 'Professional Support'

Did this page help you to achieve your goal?

 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?

 1  2  3  4  5
Not
useful
      Extremely
useful
 
  

Explore

Installers
Demo Server
Modules & Functionality
Packages
Business Processes supported
FAQ's

Help

Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support

News

News
Twitter
RSS Community / Sourceforge
Register for Newsletter

Get in touch

Contact
Register



Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.0 Generic License - Privacy Policy