AnsweredAssumed Answered

Trying to add a portlet to Actions using the Internal ID for the Resource

Question asked by e_martin on Jul 15, 2015
Latest reply on Jul 20, 2015 by Dave_3.0

I'm trying to provide an easy popup check for resource managers and other managers within CA PPM.

 

We're on 13.3 and I've constructed a query, portlet, page that returns the user's security groups that they belong in.

 

SELECT GRP.ID GRP_ID, ADMIN_RES.ID RES_ID, NAME.GROUP_NAME GROUP_NAME

 

FROM CMN_SEC_USER_GROUPS USERS

     INNER JOIN CMN_SEC_GROUPS GRP ON GRP.ID = USERS.GROUP_ID

     INNER JOIN CMN_SEC_USERS ADMIN_RES ON ADMIN_RES.ID = USERS.USER_ID

     INNER JOIN CMN_SEC_GROUPS_V NAME ON GRP.ID = NAME.ID

     INNER JOIN SRM_RESOURCES RES ON RES.USER_ID = ADMIN_RES.ID

 

WHERE GRP.IS_ACTIVE = 1

     AND LANGUAGE_CODE= 'en'

     AND RES.ID = ?

 

My issue is using the WHERE clause at the end to filter it automatically to populate with the results for the resource.

 

For my example the URL is: /niku/nu#action:projmgr.editResource&id=5133018&odf_return_to=projmgr.getResources%26reload%3Dtrue

 

So I should be able to use: @WHERE:PARAM:XML:STRING:/DATA/ID/@VALUE@ right?

 

I know I can pass the value in the linking when I add the action item, but I'm not certain how do it.

Outcomes