Clarity

Hi,

I'm trying to get list of attributes across objects that use an user defined lookup. Is there a way to get list of attributes that use a particular lookup at the DB level rather than to look into the object attributes? If yes, can you please provide me the table name?

Thanks in advance.

Monica

Some answers here ;

TIP : Documenting your Configuration (via SQL) 

Lookup association with objects 

Dave_3.0 Hi, that was helpful. But what I expect is that I want to generate list of lookup attributes A,B,C , all using the same lookup X. Is there a way to extract it?

Monica 

the code in the "Where is a lookup used?" part of that TIP I linked is what you should be looking at, specifically the 'Object' bit if you are only interested in objects/attributes

Hi Monica,

Try this SQL Query:

select distinct object, attribute from odf_multi_valued_lookups
group by object, attribute
order by object, attribute;

This should give us a list of all attributes for each object, where multi valued lookups are present.

Suhail.

Dave_3.0 suhail-sayed Great, thank you for the input guys! Kudos

Hi Monica,

Also, check odf_multi_valued_lookups to see if you get the information that you need.

Suhail.

For custom attributes, have a look at table odf_custom_attributes. It has a column called LOOKUP_TYPE which will give the lookup used by any custom attribute.

paish01  there a way to identify the same with OOB attributes and objects too?

@Monica - I have given you the answer TWICE now not sure if I am going to continue answering the same question again and again.

lets have one last try then... if you look at the thread I pointed you at (TWICE now), at the SQL that I pointed you  at ( here I'll make it easy for you here is a direct link https://communities.ca.com/thread/28007106#comment-241821671 ) that contains the answer for objects, stock attributes, custom attributes (i.e. the partial answers given by Paul.2 (odf_custom_attributes) and Suhail (odf_multi_valued_lookups - but Suhail's only tells you where there is some data in the column rather than the column definition) above), NSQL queries and Report/Job definitions.

(apologies for the somewhat passive/aggressive response)

Dave_3.0, the thread that you gave was indeed of great help, which I've bookmarked for recursive use and it's that I was expecting odf_custom_attribute table. It's my bad that I missed it in the thread you stated.