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.