Primavera Layout - Information fetch

Member for

20 years 6 months

Member for 20 years 6 months

Submitted by Santosh Bhat on Thu, 2019-07-25 02:42

Permalink

Zoltan, I think the question

Zoltan, I think the question is about understanding which *layouts* use the UDFs rather than which UDF's are in use.

You'll need to determine the UDF ID first, and the easiest way to do this is to assign an activity with values against those UDF's and then export to XLS, the exported XLS will indicate the UDF ID in the frist hearder row of the data.

From there you'll have to match that ID against the layout table.

Member for

16 years 3 months

Member for 16 years 4 months

Submitted by Zoltan Palffy on Wed, 2019-07-24 14:25

Permalink

you will have to run this

you will have to run this query

Query to determine which User Defined Values (UDFs) are not assigned values and not in use:

select table_name as Subject_Area, udf_type_label as UDF_Name

from UDFTYPE u

where not EXISTS (select * from UDFVALUE uv where (uv.udf_type_id = u.udf_type_id))