Livereport vs Autolive report format

I want to get the functions pull down on report lines that contain data not from dtree. For instance I want to display ownewr name by linking with Kuaf table as well as the dtree id and title. When the users run the report I want them to be able to use the functions pull down to view the documents reported on. Is there a way to specify the functions pull down with non dtree fields?

Find more posts tagged with

Comments

eLink User

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

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

You must use the "LiveReport" report format if you want to see a Functions menu, and this requires that you select columns from the DTree table. I believe that as long as you include the required DTree table fields (which you can get from the ReportFields system parameter), you can join with any other tables that you like, using the "Display Columns" area of the LiveReports page to specify the nonstandard columns that you want to display in the report.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, July 05, 2002 6:05 PM
To: eLink Recipient
Subject: Livereport vs Autolive report format

Livereport vs Autolive report format Posted by UCLLUser1 (Strote, JC) on 07/05/2002 06:59 PM

I want to get the functions pull down on report lines that contain data not from dtree. For instance I want to display ownewr name by linking with Kuaf table as well as the dtree id and title. When the users run the report I want them to be able to use the functions pull down to view the documents reported on. Is there a way to specify the functions pull down with non dtree fields?

Cynthia_Philpott

There must be something I'm missing. When I add the fields from a table that I am selecting that are not from DTREE the screen displays 'an unknown feature is specified' in the columns identified from the non dtree table. I am trying to display fields from a specific category. Is there a special way I need to identify the non dtree fields? Here is my code.select h.dataid, h.name, a.valstr "Drawing No." , b.valstr "Rev", c.vallong "Title 1", d.vallong "Title 2", e.vallong "Title 3", u1.name "Originator", f.valstr "Status", g.valstr "Acct No", u2.name "Designer" from llattrdata a, llattrdata b, llattrdata c, llattrdata d, llattrdata e, llattrdata f, llattrdata g, llattrdata i, llattrdata j, llattrdata k, kuaf u1, kuaf u2, dtree h where (h.dataid = a.id) and (h.VERSIONNUM = a.VERNUM) and (a.DEFID = 4783562) and (a.attrid = 2) and (h.dataid = b.id) and (h.VERSIONNUM = b.VERNUM) and (b.DEFID = 4783562) and (b.attrid = 3) and (h.dataid = c.id) and (h.VERSIONNUM = c.VERNUM) and (c.DEFID = 4783562) and (c.attrid = 4) and (c.entrynum = 1) and (h.dataid = d.id) and (h.VERSIONNUM = d.VERNUM) and (d.DEFID = 4783562) and (d.attrid = 4) and (d.entrynum = 2) and (h.dataid = e.id) and (h.VERSIONNUM = e.VERNUM) and (e.DEFID = 4783562) and (e.attrid = 4) and (e.entrynum = 3) and (h.dataid = i.id) and (h.VERSIONNUM = i.VERNUM) and (i.DEFID = 4783562) and (i.attrid = 24) and (i.VALINT = u1.ID) and (h.dataid = f.id) and (h.VERSIONNUM = f.VERNUM) and (f.DEFID = 4783562) and (f.attrid = 27) and (h.dataid = g.id) and (h.VERSIONNUM = g.VERNUM) and (g.DEFID = 4783562) and (g.attrid = 28) and (h.dataid = j.id) and (h.VERSIONNUM = j.VERNUM) and (j.DEFID = 4783562) and (j.attrid = 26) and (j.VALINT = u2.ID) and (h.dataid = k.id) and (h.VERSIONNUM = k.VERNUM) and (k.DEFID = 4783562) and (k.attrid = 33) and (k.valstr = 'SEG - Superblock Electronic Group') and (f.valstr <> 'Released') order by k.valstr, f.valstr

eLink User

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

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

I think you're getting the "unknown feature" message because of other things, but it's hard to tell without trying... I recommend that you try selecting dtree.* instead of h.name and h.dataid, then see whether you have any "unknown feature" messages. Other questions that might lead to a solution:

Are you using the "LiveReport" report format?
Are you listing any of the columns in the "Display Columns" area? And assuming that you are, are you using the column names that you have in quotes (e.g., "Drawing No.") in the "Field" fields, then providing a display name in the "Column Title" fields?

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, July 08, 2002 10:55 AM
To: eLink Recipient
Subject: There must be something I'm missing. When I add the fields from a table that I...

There must be something I'm missing. When I add the fields from a table that I... Posted by UCLLUser1 (Strote, JC) on 07/08/2002 11:43 AM
In reply to: RE Livereport vs Autolive report format Posted by eLink on 07/07/2002 09:27 PM

There must be something I'm missing. When I add the fields from a table that I am selecting that are not from DTREE the screen displays 'an unknown feature is specified' in the columns identified from the non dtree table. I am trying to display fields from a specific category. Is there a special way I need to identify the non dtree fields? Here is my code.

select h.dataid, h.name, a.valstr "Drawing No." , b.valstr "Rev", c.vallong "Title 1", d.vallong "Title 2", e.vallong "Title 3", u1.name "Originator", f.valstr "Status", g.valstr "Acct No", u2.name "Designer" from llattrdata a, llattrdata b, llattrdata c, llattrdata d, llattrdata e, llattrdata f, llattrdata g, llattrdata i, llattrdata j, llattrdata k, kuaf u1, kuaf u2, dtree h where (h.dataid = a.id) and (h.VERSIONNUM = a.VERNUM) and (a.DEFID = 4783562) and (a.attrid = 2) and (h.dataid = b.id) and (h.VERSIONNUM = b.VERNUM) and (b.DEFID = 4783562) and (b.attrid = 3) and (h.dataid = c.id) and (h.VERSIONNUM = c.VERNUM) and (c.DEFID = 4783562) and (c.attrid = 4) and (c.entrynum = 1) and (h.dataid = d.id) and (h.VERSIONNUM = d.VERNUM) and (d.DEFID = 4783562) and (d.attrid = 4) and (d.entrynum = 2) and (h.dataid = e.id) and (h.VERSIONNUM = e.VERNUM) and (e.DEFID = 4783562) and (e.attrid = 4) an! d (e.entrynum = 3) and (h.dataid = i.id) and (h.VERSIONNUM = i.VERNUM) and (i.DEFID = 4783562) and (i.attrid = 24) and (i.VALINT = u1.ID) and (h.dataid = f.id) and (h.VERSIONNUM = f.VERNUM) and (f.DEFID = 4783562) and (f.attrid = 27) and (h.dataid = g.id) and (h.VERSIONNUM = g.VERNUM) and (g.DEFID = 4783562) and (g.attrid = 28) and (h.dataid = j.id) and (h.VERSIONNUM = j.VERNUM) and (j.DEFID = 4783562) and (j.attrid = 26) and (j.VALINT = u2.ID) and (h.dataid = k.id) and (h.VERSIONNUM = k.VERNUM) and (k.DEFID = 4783562) and (k.attrid = 33) and (k.valstr = 'SEG - Superblock Electronic Group') and (f.valstr <> 'Released') order by k.valstr, f.valstr

Cynthia_Philpott

Are you using the "LiveReport" report format? YestAre you listing any of the columns in the "Display Columns" area? ----Yes And assuming that you are, are you using the column names that you have in quotes (e.g., "Drawing No.") in the "Field" fields, then providing a display name in the "Column Title" fields? ---- I've tried bothI was looking through my training manual for something else yesterday and read where it said the Livereports option does not work if you are including columns for any fields from tables other than DTREE. It's an old manual but from my experimentation that appears to be true. I created a simple report that looks at dtree and tries to display the user name from Kuaf associated with the document. Still didn't work. If you have one example that lists data from both dtree and another table using "livereport" option that works I would be surprised.Which then leads me to ask another question. Is there a way to imbed the HTML tags and URL in your Auto Livereport so that user can click on an item and go to browse mode of the document. I don't want to take them to view because most of the documents in question are not viewable with Livelink viewers.

eLink User

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

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

Take a look at the "All Reserved Items" canned LiveReport for an example of a report that uses the LiveReport format but joins to tables in addition to DTree. Its SQL is:

select %2, ReservedDate, KUAF.Name "KuafName", dversdata.MIMETYPE from DTree, DVersData, KUAF where (KUAF.ID = ReservedBy) and (Reserved>0) and (dtree.dataid = dversdata.docid) and (dtree.versionnum = dversdata.version) and %1 order by ReservedDate

%2 is "ReportFields" and %1 is "Filter Permissions". The display columns are set up as: KuafName > Reserved By, ReservedDate > Reserved Date.

I probably wrote that part of whatever training manual you're reading, so I'll tell you that whatever you're reading is probably poorly phrased and is misleading you.

If you want to post an export of that simple LiveReport that you were trying out, I'd be interested in playing with it.

The answer to your last question (about embedding links) is "no, not without customization".

This is all very intriguing -- hope we can figure out what the trouble is.