Livelink - How to create a URL in a LiveReport

[LowlyChef]

I want to create a URL in the SQL of a Livelink LiveReport
that when clicked would go to a WorkFlow (work_workid).

Is this possible? If so, what does the SQL query look like.
Any information would be helpful.

 

[ggriffit]

Take a look at the 25 Biggest documents report which does something similar, this should be a good basis to start from.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[appnair]

The Live Report uses livelink's internal mechanism to
to provide the URL's.I did a similar report for some workflow group that would do a mail_to link to the performers.This was for 9.5Sp1 and I had to change a livereport weblingo html file to accomplish that .Is this kind of something that you are wanting to do,I can dig up my notes and post the clues here.The clue if I remember this correctly is to use a shell escape character in the sql query like #! or the other way around and getting livelink to recognize that.You can do a bunch of javascript/html if you have bought the webreports module

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[ggriffit]

You can certainly have the LiveReport build the link using string concatenation in the report itself, but unless you tweak the weblingo for the LiveReport it will always be passed as plain text rather than a hyperlink.

AppNair, if you find the WebLingo page I'd appreciate a copy for my site -

http://www.greggriffiths.org/livelink/

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[appnair]

Greg,

This is in essence what I used

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=3876530&objAction=view

I will send the amended file to your email


Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[appnair]

Actually I found the exact code that somebody developed,that is exactly what I did

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2420182&objAction=view

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937