Primavera Layout - Information fetch

Hello Folks,

Scenario - There are many UDFs used in different Layout. (Total Layout-2000+)

User has discountinue 2 UDF and now they want to know in which layout this UDF is getting used. Is there any way to find out from backend because checking one by one is not a acceptable choice.

Table - Viewprop I can see the layout name but further more how to check there colomn or through UDF name/ID if there is way let me know.

DB - Oracle

Primavera-  Version 15.2

It will be great if someone provide me possitive response

Oracle Primavera - PM6
S
Santosh Bhat 👤 Member for 21 years 1 month
· Permalink

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.

Z
Zoltan Palffy 👤 Member for 16 years 10 months
· Permalink

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

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts