Using LL_PATH, how to create hyperlink to the object/document in a report

Hello,I have a report that allows user to input # of days before expiry on a Date field (attribute). Users also need to know where that document is located - LL_PATH works fine. How do you add hyperlink into that Document Location so they can simple click on the link and bring them directly to that object/doc? Thanks in advance,Oracle SQL:select distinct V.FILENAME Filename, L.ValDate "Expiry Date", V.MimeType DocType, L.ValDate-trunc(sysdate) "Expire in # Days", LL_PATH(D.DATAID) "Document Location"from DTree D, LLAttrData L, DVersData Vwhere D.DataID=V.DocID and D.DataID=L.ID and D.VersionNum=L.VerNum and L.DefID=101991 and L.AttrID=7and D.SUBTYPE=144and L.ValDate-trunc(sysdate) between 0 and 30and d.ownerid = -2000

Find more posts tagged with

Comments

Appu_Nair

If you have webreports module creating hyperlinks is not a problem at all.In case you have only livereports then the main tables dtree and kuaf and probably its relations can actually show you the objects function menu.Look at the canned reports like "largest documents" for a sample.The format is "Live Report" from my memory.If that too fails this link will give you a solution that works since 2000.https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=17326803&objAction=view&show=2It consists of changing a core weblingo(html+oscript) file so may not sit well with some companies nevertheless does work and does the trick as well.

Sumartini_Krisman

we do have webreports module purchased... how do we make a field hyperlinked accordingly? Thanks in advance. We are new to Livelink and are trying to get some basic reports in for demo.

Darren_Hodder

Hi,With WebReports, you can develop a reportview using HTML code and then use WebReports tags within the HTML code - there are very many tags of different kinds, ranging from tags that provide data from a data source (such as a LiveReport) to sub-tags that let you manipulate or get additional information on data tags. When you run the WebReport, you get a WebReport browse page that is generated from the HTML code and the values of the tags inserted into that HTML code.In your case, you can create a WebReport that uses your LiveReport as a data source (which means that the data returned from your LiveReport is available for use in your WebReport) that has the following mix of HTML and WebReports tags to generate a hyperlink to the documents returned by the LiveReport:[LL_REPTAG=DATAID NODEINFO:NAME /]WebReports is packaged with several default reportviews that you can create quickly, choose a data source (such as your LiveReport), and run instantly that will display the results returned with hyperlinks generated automatically. You can start with one of these reportviews and then customize it to your needs.Please let us know if you require any more information about using WebReports.Cheers,Darren.

Jean-Philippe_Martin

maybe this could help you ?https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=17657360&objAction=view&show=2

Phani_Tripuraneni

Hai Darren,We used this code and it displayed hyperlink and it worked good when displayed on screen using web report.But when the output (Destination) is changed to send as email or save as file on desktop, hyperlink shows in the file but it doesn't work because path becomes relative..(starts with local desktop path like C:Documents/... How can this be solved?Please let me know if you need more information.thanks

Darren_Hodder

Hi,You can modify the WebReports tag to include the beginning part of the URL in the HREF - you need to create the entire URL for this to work properly when clicking the link from outside the server.If you start with the example in my previous post, [LL_REPTAG=DATAID NODEINFO:NAME /], you can modify this to create the entire URL such as this:[LL_REPTAG=DATAID NODEINFO:NAME /].In this example, I hard-coded the http:// part, but you can also make this dynamic if you have a secure server to use the [LL_REPTAG_&SERVER_PROTOCOL /], which will tell you if the request was using a secure protocol.Cheers,Darren.

Phani_Tripuraneni

Thanks a lot Darren. that really worked but it shows me login screen even though I am already logged in. Once I login it open the document though. It seems like its not taking the cookies..?!!

Phani_Tripuraneni

Any clues on this? Is this related to the type of authentication?

Tim_Hunter

once you save this as a file on your filesystem any reference back to livelink would need to be authenticated again, there is no cookie because there is no server

Darren_Hodder

Hi,This may be possible to do if the URL in the hyperlink (specifically the server name portion) looks identical to the URL you're using when you're logged in. Would you be able to copy and paste the URL that WebReports generates, and also copy and paste the URL as you see it when you are prompted to login to Livelink (make sure its the URL from the login screen, and not the URL after you log in).You could also try modifying the tag I mentioned in a previous post to use [LL_REPTAG=DATAID NODEINFO:NAME /].This has two changes, the first being that it will detect whether or not to use https instead of http, and second is that its using the HTTP_HOST parameter instead which may return a different value for the server name.Thanks,Darren.