Cats & Atts Question

[ggriffit]

Dear All,
got this via my Livelink site -

http://www.greggriffiths.org/livelink/

- from a user who could do with some suggestions :

"I am having the following issue with Categories and Attributes:

We have created catts & atts and associated with a folder and its sub-items. We filled up meta data whenever we add a new record.
That part is perfectly working. The problem I had when I try to create a "view" for a select query. Generally my view works fine with normal catts & atts. Since we had "Sets" in our catts & atts, we are unable to find out the way to get the data.

Question: How to create views (Select Query) when we have "Sets" in our Categories & Attributes?
Please let me know.

Thanks,
Ravi."

 

[appnair]

The html formatting appears weird is the qn about creating an sql view that will pull up infor on a category with 'SET' attribs

Always acknowledge a fault. This will throw those in authority off their guard and give you an opportunity to commit more.
Mark Twain

appnair

 

[appnair]

wouldnot this work.If I had a document id =5000 to which I ad a defid =10000 (category id).If I had sets on the category

select * from llattrdata where defid=10000 and id=5000

This should give all the rows of the categories including sets.A category starts aout as an assoc(-18),by introducing a set you will have more -18 in the results.You can then query the particular set you are querying by applying a filter in attrid.For eg pull up the original category definition and hover over youe set memebers.The number that shows up in the url as a javascript is your attrid.

select * from llattrdata where defid=10000 and id=5000
and attrid=5 (assuming I have a set item at 5)

run a describe on llattrdata and that should give you what you are looking for

Always acknowledge a fault. This will throw those in authority off their guard and give you an opportunity to commit more.
Mark Twain

appnair