Clarity

I need to show a list of all of the active/inactive attributes on an object (both project & idea), what pages currently have that attribute on them (e.g. Project Detail), and if the attribute is currently being audited.  Trying to find a way to avoid hours of research work with a portlet.

Thanks!

You might find some (not all) of your answers here ; TIP : Documenting your Configuration (via SQL)

Close, my challenge is we are using a partition...  I was able to get my Object attribute list exported to excel, but now I need the research for the active attributes as to which pages (or sub pages) they are currently housed on, and if any data is associated with them...

(BTW - we have 242 active attributes on the Idea object alone...)

Where you are saying "pages (or sub pages)" I think is where the query I described as "VIEW configurations" would help.

Whether there is data in the tables, you would have to do on a case by case basis I think (derive your own SQL), not convinced that there would be a generic SQL statement to help you there without starting to do silly things like interrogating the database data-dictionary (which would just be more fiddly than writing your own SQL).

You don't mention portlets either (rather than just object views) - i.e. do you need to know where the attributes appear in NSQL portlets, thats another case too and this might help there ;  Search All NSQL And GEL Scripts