Performing some database action at the end of workflow

Hello,

I am extremely new to Livelink development, and hope to get some directions.

In our problem, we need to save the office location of the performer of a certain workflow step, so that when we do reporting later on, we can refer to that particular office location. To make it more exciting, our extension application uses custom database tables outside of livelink, so I am curious whether we should save the information to an Attribute or DB Table. I personally like Tables better as it more accessible in reports.

To do this, do I need to learn Oscript? Or does Livelink or Workflow Editor provide a mean to accomplish this? Can you point me in the right direction please?

Thanks in advance.

Find more posts tagged with

Comments

Appu_Nair

Read my reply the starting ideas are to avoid programming.

In your workflow have a form tied to a table.There is nothing preventing you from calling a table outside of livelink.You have to follow the setup of webforms or pdf forms so that livelink can connect and write to that.

The form data can be indexed so you can find them later using livelink search or database query.

Attribute extensions(well wont fit because it is a read operation)

If you want to laern oscript,then workflows allow you to call your own logic at pertnent points in a workflow.the solution will need you to load your module in livelink.In oscript speak these are event scripts

If you have extension products for livelink workflow(some produsct I have seen XMLWFExtensions from OT,Powertools or WFextensions by global cents,webreports,wisteria IT the list is very long on workflow offerings) then really possiibilities are abound.

Maybe Ryan or somebody in WF can point you other ways as well.

haoest

Hi Appu,

Thank you for the reply.

As you guessed, we do have a table tied to the workflow, and in most cases, the table does reflect the correct outcome of the workflow. However, in some cases when a step is manually reassigned by an administrator to a different person as indicated in the initiation of the workflow, the table entry would need to be manually synchronized to what actually happened in Livelink, and this is the scenario I am trying to solve.

Do you think I can get away with not messing with code for this?

Thanks,

Appu_Nair

Ha nobody else to help,maybe you should post in WF discussion areaas I tend to think programmatically.

Unfortunately not , that is what I would use eventscripting forthen. It should not be too hard.

Also I think this is what you are trying to solve. A WF instancehas done a few steps. A WF manager

Now re-assigns it to a different performer. The row in yourtable holds what it started out with.

The WF manager has to consciously replicate this same stuff intothe table row, you would like this automated.

I would like to do it this way.

Rather than changing the perfomer in the WF thru the managementstep, let that manager update the row in that table(some training)

On entry of that step you would code a perfomer eventscript. Youwould read your performer from the custom table,there must be some logic

In your row saying which workid/subworkid you are on. You wouldset that perfomer. So Tom who was the orig perfomer

Would be replaced by Thumb who the manager changed it to.

Conversely,

If a event script is configured you would use a steppast this step(where the changes has happened and Thumb has performed it)

You would code a general event script and put a call to do thedb update change. You would probably use a different method other than CAPI

Like dbwizapi or webdbconnection(all from memory not accurate).thereason why I say is most CAPI methods are for tables in the livelink schema although

You very well can use capi to do that as well.

Note both these solutions use event scripting which needs you tocode your module and implement the logic.

The builder help has a very good guide on builder per-se with agood write up on how to do event scripting.

I have put an article on the KB for a jump start on eventscripts(assumes you know builder)

http://communities.opentext.com/communities/llisapi.dll/wiki/7967685/Introduction to EventScripts in livelink workflows

From: eLink Entry:Content Server Builder Forum [mailto:componentbuilder@elinkkc.opentext.com]
Sent: Wednesday, October 27, 2010 3:48 PM
To: eLink Recipient
Subject: Performing some database action at the end of workflow

Performing some database action at the end of workflow

Posted by hao.deng@nanavaticonsulting.com (Deng, Hao) On 2010/10/27 16:45

Hi Appu,

Thank you for the reply.

Do you think I can get away with not messing with code for this?

Thanks,

[To post a comment, use the normal reply function]
Topic:	Performing some database action at the end of workflow
Forum:	Content Server Builder Forum
Livelink Server:	knowledge-wlweb01

haoest

Thank you so much for the link to the eventscript resource site, it's an excellent place to start.