Portlet: 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

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

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();