Extended data field in DTREE Table

Karen_Poffenberger_(joipro01user10_-_(deleted))

Can you pull a specific piece of data out of the extended data field (part of the DTREE table) using a livereport?We have data stored in that table and I wanted to use it to compare information stored in the extendeddata field with a user input (such as a date)

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

Alex Kowalenko (formerly of Open Text) was the source of this information, taken from some archives I had dating back to the year 2002. This information is for writing an Oracle function that will retrieve a value from a key-value pair that is stored in extendeddata. Perhaps it will be useful to you.

The data in DTree.ExtendedData encapsulates the Assoc datatype used by Livelink. For example, here is what the DTree.ExtendedData column looks like for a LiveReport:

A<1,?,'conf_names'='WIDTHOPTION,WRAPOPTION,ROW1COLOR,ROW2COLOR','conf_values'=',NOWRAP,ffffff,ffcc99','displaytype'='report','fields'={'Discussion'},'headers'={'Discussion'},'inputs'={},'oldDataId'=45039,'params'={'#ReportFields','#FilterObject:130',?,?,?,?,?,?,?,?},'recordlimit'=100,'sql'='select %1, d.name "Discussion" from dtree dtree, dtree d, dtree r where %2 and dtree.dataid *= r.parentid and dtree.ownerid = d.dataid group by %1, d.name having count(r.dataid) < 1 order by count(r.dataid) desc','subreport_id'=?,'subreport_parms'={},'subreport_path'='','title'=''>

This Oracle-specific function definition extracts a specified Assoc value from DTree.ExtendedData. It searches for '<valuekey>'='<value>' and returns <value>.

create or replace function ed_value(selid in number, valuekey in varchar2)return varchar2is edc varchar2(32000);keytag varchar2(255);vstart number(10);vend number(10);retvalue varchar2(32000);beginselect extendeddata into edc from dtree where dataid = selid;keytag := '''' || valuekey || '''=';vstart := Instr(edc,keytag);If vstart = 0 Then retvalue := null;Elsevstart := vstart + Length(keytag) + 1;vend := Instr(edc,''',''',vstart);If vend = 0 Then vend := Instr(edc,'''>',vstart); End If;If vend >= vstart Then retvalue := replace(substr(edc,vstart,vend-vstart),'\''','''');Else retvalue := null; End If;End If;return(retvalue);end;

To use this function, you can call it from within a SELECT statement, passing the parameters it wants. This example call returns all of the SQL query definitions that are embedded inside a LiveReport definition in DTree.ExtendedData.

select name, ed_value( dataid, 'sql' ) "SQL Query"

from dtree

where dataid in

(select dataid

from dtree

start with dataid=26343

connect by prior dataid = parentid) and

%1 (Filter LiveReport)

order by name

- Bhupinder

------------------------------------------------------
Bhupinder Singh, B.Math., B.Ed.
Senior Product Specialist, Customer Support
Open Text Corporation, Waterloo, Ontario, Canada
Customer support e-mail: support@opentext.com
Customer Support Telephone: 800-540-7292
------------------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, March 17, 2006 2:08 PM
To: eLink Recipient
Subject: Extended data field in DTREE Table

Extended data field in DTREE Table

Posted by joipro01user10 (Poffenberger, Karen) on 03/17/2006 02:02 PM

Can you pull a specific piece of data out of the extended data field (part of the DTREE table) using a livereport?
We have data stored in that table and I wanted to use it to compare information stored in the extendeddata field with a user input (such as a date)

Karen_Poffenberger_(joipro01user10_-_(deleted))

I can't seem to follow this example, do you have any other details or information?

pastedImage_0.png

Bhupinder_Singh

Message from Bhupinder Singh via eLinkMessage from <> via eLink

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

I've been informed that the optional WebReports module (available from OpenText, datasheet attached) can make the process of parsing EXTENDEDDATA in DTREE much easier. The datasheet mentions:

• Easily extract, format and present data from complex Livelink table and data structures (e.g. Lists & Assocs) using powerful sub-tag features.

Attachment: livelink_webreports_data_sheet.pdf

- Bhupinder

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, March 17, 2006 2:47 PM
To: eLink Recipient
Subject: I can't seem to follow this example, do you have any other details or...

I can't seem to follow this example, do you have any other details or...		Posted by joipro01user10 (Poffenberger, Karen) on 03/17/2006 02:45 PM
In reply to: RE Extended data field in DTREE Table		Posted by bsingh (Singh, Bhupinder) on 03/17/2006 02:19 PM

I can't seem to follow this example, do you have any other details or information?