Report on attribute

Birger_Jacobsen_(danskadmin_-_(deleted))

can any body help me with creating a repor based only on an attributeExampleSelect name from ??? where (Attr.)=%1where %1 is the attr. valueThanks

Find more posts tagged with

Comments

eLink User

Message from Alex Kowalenko via eLinkAttribute data is stored in the LLAttrData table which is related to theDTree table where the items (such as documents and foldets) are kept. So youneed to relate these tables in your report. A basic query looks somethinglike this:select dtree.name from dtree, llattrdata a1 where a1.id = dtree.dataid and a1.vernum = dtree.versionnum and a1.defid = <# of category defn> /* which category */ and a1.attrid = <# of the attribute> /* which attribute */ and a1.valstr = %1 /* string value */-alex------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Monday, August 26, 2002 10:22To: eLink RecipientSubject: Report on attributeReport on attributePosted by DanskAdmin on 08/26/2002 10:15 AMcan any body help me with creating a repor based only on an attributeExampleSelect name from ??? where (Attr.)=%1where %1 is the attr. valueThanks[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Jamal_Saket_(offsup023_-_(deleted))

You have to analyse attrType as well to get valInt, valReal, valLong, or valDate fields. Run?func=attributes.dump first.Olga.

Cynthia_Philpott

What version of Livelink is the function call you mentioned available? We are still using 9.0 and this did not work when I tried it. It's a great idea, I spent hours researching my categories with spreadsheets and tables showing maps. Wish OT had introduced this when they changed all the category table around.?func=attributes.dump

eLink User

Message from Eidson Matthew W Contr AFFTC/ITASC <<A HREF="mailto:Matthew.Eidson@edwards.af.mil">Matthew.Eidson@edwards.af.mil> via eLink

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

I believe ?func=attributes.dump works in v9.0.0.1 or above.

Matt Eidson
AFFTC/ITASC
Livelink Integrator/Developer
Network Systems Analyst
Tybrin Corporation
Office: 661-275-3704
Mobile: 661-810-6091
Nextel Direct Connect: 122*11*6004
matthew.eidson@edwards.af.mil

All of us get lost in the darkness
Dreamers learn to steer by the stars
All of us do time in the gutter
Dreamers turn to look at the cars
Turn around and turn around and turn around
Turn around and walk the razor's edge
Don't turn your back
And slam the door on me

Rush -- Album: Presto -- Song: The Pass -- Year: 1989

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, August 26, 2002 9:47 AM
To: eLink Recipient
Subject: Wjat vers is func call available in?

Wjat vers is func call available in?		Posted by UCLLUser1 (Strote, JC) on 08/26/2002 12:35 PM
In reply to: You have to analyse attrType as well - to get valInt, valReal, valLong, or...		Posted by OFFSUP023 (Bakushchyk, Olga) on 08/26/2002 11:45 AM

Jamal_Saket_(offsup023_-_(deleted))

I'm working with 9.1, but I've read about it in https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3498953&objAction=ArticleView - so it should work in 9.0 SP1.

Birger_Jacobsen_(danskadmin_-_(deleted))

we are runing 9.0.0.1 and Attributes.dump do not work on itbut on our test env. (9.1) it´s working