Displaying "seq" in Livelink web form

[madhuusa]

Hello folks,

If anybody can help with this, it will be great. I am having a small web form in which I need to display the seq (the seq field in the table that was created by Livelink along with default columns such as VolumeId, Dataid, rowseqnum, versionnum).

My sql query is select max(seq+1) from tbl_issuerisk;

And the objective is to list the value in the top of the form as Sequence number.

Can you please let me know the steps involved in doing this. Is there a way I can do this without webform lookup.

Thanks.

 

[appnair]

First off I did not try this so don't get too pent up on this.Since you said you did not want webform.datalookup,do you not like the vanishing javascript window I am just throwing out there an idea. Livelink has a freebie(I think it is free) called attribute extensions(it is also called extended attributes,table key lookup,cascading lookup etc).Once that is installed in categories,forms and workflow attributes there appears a new pull down called "table key lookup".This attribute will take any valid sql statement in it form any database within the livelink schema.Even if you got it to work with your statement I don't know how you will get it "fired" on your form.Typically one clicks on the hyperlink to run the sql statement.

Other than this if you have builder you could probably throw a capi.exec call to do that thru your own RH.That is another idea I think that will work.

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

Certified OT Developer and probably certfiable,Livelink ECM Champion 2008

 

[ggriffit]

alternatively you could create a button that uses any of the other web based ways of populating a HTML based form field such as ASP, AJAX, .Net, JSP etc.

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

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

 

[madhuusa]

Thanks Appnair and Greg. The form requirements became significant (it started as a small form though). We are looking for a .aspx (.net) page with LAPI calls.

If only Livelink had a decent webforms module it will be of great help

 

[ggriffit]

I've found the webforms module to be sufficient for most of my enterprise workflow implementations if designed properly with the support of AJAX, .Net etc.

Have you looked at the other options such as EForms and BPM ?

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

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

 

[madhuusa]

True Greg. Webforms can do lot of things. But it seems like a arranging a mountain to move a stone!!!

We probed EForms and that also seems to involve lot of hardware stuff first (seperate server/licenses/sync with LL server, etc) and also seems not quite as easy as say InfoPath or Sharepoint designer kind of tool which integrates so easily with the ecm server (SP in this case).

For now we are going with .net with lapi calls and looks like lapi in .net (in 9.5) also seems very rudimentary.

When software as service, webservices, service oriented architecture, etc are buzzwords for extending your core software platforms, Livelink seems to be blissfully disconnected on these angles.