AnsweredAssumed Answered

Finding lookup ID for an attribute

Question asked by Plidian on May 13, 2014
Latest reply on Jun 11, 2014 by Dave

I was just wondering if anybody had a handy trick for finding out the lookup ID for a lookup based attribute?

For instance I go into the project object.  Then I go into attributes and I pick an attribute like manager, the properties of manager tell me that the lookup it uses is called "Browse Resource"

If I go to lookups and I look for a lookup named "Browse Resource" I find there are 2 results.  How do I know which of these is actually being used?

I was able to identify that in this case it's using BROWSE_PROJMGR by doing a SQLtrace but this is a rather cumbersome method.  I had hoped to identify how Clarity determines which one it is but sadly the only query in the sqltrace already knows that it's using BROWSE_PROJMGR and is simply retrieving additional information about that lookup.  But I can't figure out /HOW/ it knows that.

Anybody know what I'm missing?

Ideally I'm looking for a table in clarity that lists attributes and their lookups by ID or a query that genreates that data.