vspacer
 
vspacer
 

Kintana Script : Demand Request 'Make a Copy' Button

 

Purpose

A user may complain that he cannot copy a request.

The [Make a Copy] button only appears on a request if the user is in (any) one of the security groups listed on the request type's [User Access] tab that has the 'Create' rights checkbox ticked.

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.0.

Usage

Paste the script into Toad or SQL Runner

Script kintana_scripts_demand_request_copy_button
select unique crt.request_type_name,
       crts.can_create_code,
       nsg.security_group_name
from KNTA_ACCESS_SECURITY nas,
     KNTA_SECURITY_GROUPS nsg,
     KNTA_ACCESS_GRANTS nag,
     KCRT_REQUEST_TYPE_SECURITY crts,
     KCRT_REQUEST_TYPES crt
where nas.security_group_id = nsg.security_group_id
  and nag.access_grant_id = nas.access_grant_id
  and nag.category = 'Demand Mgmt'
  and crts.security_group_id = nas.security_group_id
  and crt.request_type_id = crts.request_type_id
  and crts.can_create_code = 'UNCHECKED'
order by crt.request_type_name
select nu.first_name || nu.last_name "User",
       nsg.security_group_name
from KNTA_USER_SECURITY nus
     KNTA_USERS nu,
     KNTA_SECURITY_GROUPS nsg
where nus.user_id = nu.user_id,
  and nus.security_group_id = nsg.security_group_id
order by nsg.security_group_name, 1

Download

KintanaScripts.zip (79 Kb)

Kintana™, 'Mercury IT Governance™', 'HP PPM (Project and Portfolio Management)™
are trademarks of ChainLink, Mercury Interactive Corporation, and Hewlett Packard Corporation respectively.


   


Back to top | ZDS Home | This article updated October 25, 2007.