Category Value

How do I query the specific value of an attribute is equal to something? For instance, I would like to find all documents where AttrName=CustomType, and CustomType=Value1. In the schema, I only see a way to query the AttrName, not the actual value of it though.I know we can do this through search, but I would like to write a report for it.Thank you in advance,Nicole

Find more posts tagged with

Comments

Appu_Nair

I like to flatten the category data by creating a view like in this articlehttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=3498953&objAction=ArticleView&viewType=1then it becomes easily queryable or did I miss the boat completelyattrname in llattrdata itslef is an "id" so I am not sure where you see the "attrName" in llattrdata unless you have figured that one alreadyNo need to create the view but it does show you how to query those tables correctly

Lindsay_Davies

Message from Lindsay Davies <ldavies@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Hi Nicole,

This is a little tricky but Livelink maintains a table for Administrators to use, called CatRegionMap.

It forms a handy lookup for attributes within your category.

Assuming you want to only write a one shot report for this specific attribute, you can look up the relevant attribute number here and then write your join query for DTree and LLAttrData.

SQL> select * from catregionmap;

     CATID CATNAME              SETNAME    ATTRNAME             REGIONNAME
---------- -------------------- ---------- -------------------- --------------------
    100762 Mand1                           String               Attr_100762_2
     53692 man cat                         details              Attr_53692_2
     45761 man cat                         details              Attr_45761_2

So for my category "man cat" and attribute "details" you can derive the AttrID from the end of the regionname - in this case it is 2.

This is because the category itself is ID1 and there is only one attribute.

You final select will be something like

select <...> from dtree, llattrdata where dtree.dataid= llattrdata.id and defid=45761 and attrid=2 and valstr='my chosen value'

You need to know the datatype of the attribute to know which column to compare (valstr, valint, valdate, etc).

Hope this gets you heading in the right direction.

Good luck.

Regards

Lindsay Davies

European Escalation Team

Open Text UK

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 26 June 2009 16:32
To: eLink Recipient
Subject: Category Value

Category Value

Posted by nbride (Bride, Nicole) on 2009/06/26 11:31

How do I query the specific value of an attribute is equal to something? For instance, I would like to find all documents where AttrName=CustomType, and CustomType=Value1. In the schema, I only see a way to query the AttrName, not the actual value of it though.

I know we can do this through search, but I would like to write a report for it.

Thank you in advance,
Nicole

Nicole_Bride

Message from Bride, Nicole <nbride@cvps.com> via eLink

eLink

Great! Thank you. That worked perfectly.

From: eLink Discussion:Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, June 26, 2009 12:23 PM
To: eLink Recipient
Subject: RE Category Value

RE Category Value		Posted by ldavies (Davies, Lindsay) on 2009/06/26 12:23
In reply to: Category Value		Posted by nbride (Bride, Nicole) on 2009/06/26 11:31

Message from Lindsay Davies <ldavies@opentext.com> via eLink