How do I display custom userdata in the assignment list

[stevepowelluk]

I've managed to find the HTML file that shows the personal assignment list. I've even manged to track down what is in nodeRec. But I can't find any way of accessing the data held in the USERDATA column in either WWORK or WSUBWORK. I just want to get at the data so I can traffic light the contents of the assignment list.

The status column is pretty obvious but not much use as it only has two possible ststuses as far as I can tell OK and STEP LATE. We need an escalation before that.

Just some pointers on how to access the workflow in OScript would do. The docs I have are terrible.

This is all 9.2.

many thanks

Steve

 

[appnair]

To do this please undertake an NDA with OpenText and get a copy of the schema.Then workflow related tables will give you a clue as to how to process them.There are specifically two views provided by opentext which makes workflow reporting very easier.
To access workflow in oscript you will need a wapisession just like a document session,which you get any ways if you have a program context.Typically one would just create a result set of the workflows one is interested in(filter conditions are usually workflow manager etc).The result set will have workid and subworkid.Then you execute a for each on these and do methods in the WAPI package WorkList seems to be the most commonly used method.

If you want samples peruse the development discussion for event scripting of workflows whaich kind of gives you a feel for workflow programming.


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

 

[stevepowelluk]

We have copies of the DB schema, finding the data using a SQL query is a no brainer.

Have been searching the development discussion for examples of how to script workflows and not found anything even remotely useful.

How do I access the WAPISESSION inside the program context?

I see bits like

;now = CAPI.Now( .fPrgCtx.fDBConnect.fConnection )

Which is obviously getting a CAPI session using .fPrgCtx (the program context I assume) but where do i find the docs that explain what .fPrgCtx is and what its sub properties are?

How do I know that .fPrgCtx is available to me in the first place. It doesn't show up in builder when I put a break on the page.

 

[appnair]

Declare it as a dynamic

dynamic uSession = .fPrgCtx.Usession().fSession
dynamic wSession = .fPrgCtx.WSession().fSession

If you are on weblingo you may have to look at yourn `this` object and see if you have a PrgCtx.Otherwise just do a login to the database and getting a program context should be a breeze there
Once you have that wsession this is form my code

dynamic allMyWork= WAPI.WorkList( wSession, \
viewName, \
whereClause, \
flags )


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