Determine Who Created Picklist Associated With An Object

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Is there a query available to find out who created a picklist?

Environment

Release : All

Resolution

1. Find out information about the object.

The following example queries can be used:

--Roadmaps
select
a.id, a.name, a.code, a.author,
b.created_by, b.last_updated_date, b.last_updated_by,
b.id rdmpid, b.name itemname, b.code rdmpitemcode,
c.unique_name, c.first_name, c.last_name
from
RDM_ROADMAPS a,
RDM_ROADMAP_ITEMS b,
srm_resources c
where a.id = b.roadmap_id
and a.author = c.id
order by a.name

--CIT
select 
a.id, b.odf_object_code, b.name, b.code,
c.prprojectid, c.prname
from
[xxxxxxx] a,
Inv_investments b,
PRTASK c
where a.id = b.id
and c.prprojectid = b.id
order by a.created_date desc;

where [xxxxxxx] is the name of the custom investment table (which will start with ODF_CA_xxxxxx)

2. Then use the following query and substitute the [xxxxxxx] for the object code.

To find out who created the picklist, substitute the name

SELECT
a.name, a.created_date, a.created_by,
b.user_name, b.first_name, b.last_name
FROM
odf_picklist_defs a,
cmn_sec_users b
WHERE a.created_by = b.id
AND a.name like '%xxxxx%'