Skip to content
ProjectControls.com
Oracle Primavera - PM6

Primavera Layout - Information fetch

In the Open Standard
Pulkit VermaMember for 12 years 3 months
Created
2
6
0

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

Save Follow Follow forum Report
Reply New topic

2 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    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))
    Report
  2. 0
    Santosh Bhat ·
    #2

    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.

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?