Modifiing "What Happened Yesterday" live report

Dears,I'm trying to edit livelink Live report titled "What Happened Yesterday" to view the owner filed in live reports search results page, the filed"Owner" was displayed but there was no value on it come back with "unknown feature was specified" as shown on the attached snap, we are using livelink 9.7.0 and Live report 2.2.0thanks in advance

Find more posts tagged with

Comments

Appu_Nair

First run the query with autolivereport as the selection.This means that livelink will spit out information without you specifying the column.Once you know what column that you are showing put them next to 'created date' and modified date' and look at what OT is doing as an alias there and then change it back to livereport.I belive any query that has dtree ,kuaf and some other table will give you a function button in the Live Report mode.a useful feature to someAuto Live report is for report development mode.

Saad_al_Tamimi

Dear Appu, Good day, your reply was so helpful.the live report works and retrieve the user "Nickname" in digit format. is there a way to map the nickname to the user log in name.Thanks and kind regards

Appu_Nair

If you want to take my advice find a better interface than Livereports to generate your queries.If you are oracle use what others use,if you are sql use management studio.The LR typing real estate is very cumbersome and prone to CR/LF errors.If you have LR Extensions they give you a little more real estate.Once you perfect your query then port it into LR.As to how to get to it all you need is a join of dtree.userid to kuaf's ID.KUAF keeps user info dtree keeps object info.The raw query eg will look something likeselect dt.name,dt.dataid,k.id,k.name,k.firstname,k.lastname from dtree dt ,kuaf k where dt.userid= k.id and dt.dataid =66794dt and k are table aliases that I use so that I don't have to typedtree.name,kuaf.id usual parctice in querying.BTW get a copy of the schema by signing an NDA.It is one of the very few things that are free

Craig_Stanley

I second what Appu has said. We try to stay away from Live reports. We have tried Webreports which is an expensive but very good productWe use TOAD to write our queries and we personally find that Microsoft Reporting Services is a better solution. There is a free version available which can be used against Oracle or SQL Server. The reports unlike Livelink Report don't tie up any threads. Dundas Reports provides some additional Graphing Capabilities and some nice Gauges for Dashboard views.

Appu_Nair

If you could post an example of the "Filter Permissions" outside the realm of a LR . I know that Filter document is inserting a "subtype=144) into the query and I know that there is a way to get all the values that are in the pull down,but if there is something that you have already in stock pls share.

Evert_Kuiken_(ekuiken_-_(deleted))

The code generated by a Filter can be seen if you select View Query (or View SQL code, I forgot) from the function menu of a Live Report.

Appu_Nair

R U sure this is simple Livelink or with some other add on module.My functions menu has very little info like that.Perhaps a screen cap from your system could help.The query I found out would be doing something like this although I don't exactly know what that really means.'(exists (select DataID from DTreeACL b where b.DataID=NVL(DTree.PermID,DTree.DataID) and (RightID in (-1,68222,2991)) and See>1))'

Evert_Kuiken_(ekuiken_-_(deleted))

Message from <Evert.Kuiken@alliander.com> via eLink

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

Hi Appu,

This is our Function Menu. Using Livelink 9.5 SP1 with WebReports on Oracle. The last menu item (Permission Reports) is a specific module. Don't know which items in this menu are standard and which are module-specific.

Evert

Van: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Verzonden: donderdag 8 oktober 2009 17:42
Aan: eLink Recipient
Onderwerp: R U sure this is simple Livelink or with some other add on module.My functions...

R U sure this is simple Livelink or with some other add on module.My functions...		Posted by anair@alitek.com (Nair, Appu) on 2009/10/08 11:37
In reply to: The code generated by a Filter can be seen if you select View Query (or View...		Posted by ekuiken (Kuiken, Evert) on 2009/10/08 11:26

R U sure this is simple Livelink or with some other add on module.My functions menu has very little info like that.Perhaps a screen cap from your system could help.

The query I found out would be doing something like this although I don't exactly know what that really means.

'(exists (select DataID from DTreeACL b where b.DataID=NVL(DTree.PermID,DTree.DataID) and (RightID in (-1,68222,2991)) and See>1))'