Reference Lookup Table of Custom Field RRS feed

  • Question

  • Is there a way to lookup the lookup table that an enterprise custom field is attached to ? I have id of field, but not of the table ?


    Monday, July 25, 2011 4:58 PM


All replies

  • cmb9999,

    Are you trying to get the values from the value list? If so the following VBA code will get those values. Note: for illustrative purposes this code assumes the custom field is CustomTaskEnterpriseText1. The code is a little klugy (i.e. has to use the Err function) but I couldn't find a count property for custom value lists. The values are printed to the immediate window of the VB editor.

    Sub customfield()

    For i = 1 To 100

        On Error Resume Next

        Debug.Print CustomFieldValueListGetItem(pjCustomTaskEnterpriseText3, pjValueListValue, i)

        If Err <> 0 Then

            On Error GoTo 0

            Exit For

        End If

    Next i

    End Sub

    Hope this helps.


    Tuesday, July 26, 2011 3:16 AM
  • There is a Table called as  MSP_CUSTOM_FIELDS ,MSP_CUSTOM_FIELD_VALUES, MSP_PROJ_CUSTOM_FIELD_VALUES in the published database,

    you can write a join and find the corresponding data. 

    Thanks, Parth
    Tuesday, July 26, 2011 9:33 AM
  • Sorry for falling in but just to make sure, Direct querying the project server Draft, Published & archive database is NOT supported & recommanded. Please use the PSI method to find the get this information:

    Please check my reply on this thread:

    Thanks, Amit Khare |EPM Consultant| Blog:
    Tuesday, July 26, 2011 9:41 AM
  • Hi, I have the the custom field values (Guids), from ProjectCustomFields table for a project dataset, but i don't know what lookup table to look up those values in to find the LT_VALUE_TEXT.  Make sense ?
    Tuesday, July 26, 2011 7:06 PM
  • did you try MSP_LOOKUP_TABLE_VALUES again from the piublished database???
    Thanks, Parth
    Wednesday, July 27, 2011 4:54 AM
  • Hi i was looking to ue a Filter (by lookup table Name), to save resources.
    Wednesday, July 27, 2011 4:13 PM
  • Sorry , can you write the result here 1 or 2 records...then i can help you retrieve the records...
    Thanks, Parth
    Thursday, July 28, 2011 4:22 AM