Populating custom columns when creating objects via Oscript

Hi,

I have a Workflow event script I wrote for CS 10.0 U13 and Physical Objects 10.2.0. In it, I create a Physical Object container in the attachments folder of the workflow for review before the object is moved to the desired location (this is what the client wants).

To create the object, I'm using the standard LLNode.NodeCreate() method where I pass in a createInfo assoc populated as is done in the core interface.

Can anyone tell me where (in general) columns get populated after a LLNode.NodeCreate() or if they only get populated by WebNode.Action-Create2()?

In particular with Phys Objects, does anyone know where the HomeLocation metadata source gets populated?

-Hugh Ferguson

Find more posts tagged with

Comments

John W. Simon, Jr.

Hugh,

I think the column updates must come thru LLIAPI:ColumnUtil. I searched the system for that and see one of its scripts (StartBulkAdd) is called on NodeCreate, NodeUpdate, CBNodeCopy as well as a few other places. Just guessing that column changes are funneling thru there.

Also, in the PhysicalObjects oSpace I see a ColumnMetadataSource:HomeLocation. Perhaps looking there will answer your specific question.

Best Regards,

JWS

From: eLink Entry: Content Server IDE Development Forum [mailto:contentserver-ide@elinkkc.opentext.com]
Sent: Wednesday, January 21, 2015 1:08 PM
To: eLink Recipient
Subject: [EXTERNAL]Populating custom columns when creating objects via Oscript

Populating custom columns when creating objects via Oscript

Posted byhugh@hferguson.ca (Ferguson, Hugh) On 01/21/2015 02:06 PM

Hi,

To create the object, I'm using the standard LLNode.NodeCreate() method where I pass in a createInfo assoc populated as is done in the core interface.

Can anyone tell me where (in general) columns get populated after a LLNode.NodeCreate() or if they only get populated by WebNode.Action-Create2()?

In particular with Phys Objects, does anyone know where the HomeLocation metadata source gets populated?

-Hugh Ferguson

[To post a comment, use the normal reply function]
Forum:	Content Server IDE Development Forum
Content Server:	Knowledge Center

HFCDev

Thanks John,

Based on what I've traced through it should all just work so long as you put in a value for Home Location. Actually on my sandbox the event script does populate the column, it's just in the client's DEV environment that it doesn't. I will need to get them to let me run builder on their environment to trace it through.

-Hugh

John W. Simon, Jr.

I'm sure you know that columns/facets depend on distributed agents running. You might query the DA tables (or check the DA logs) to see that they are set up correctly. Here is a great doc (from the champions toolkit) about how to query the DA tables (https://knowledge.opentext.com/knowledge/llisapi.dll/Open/24826562)

HFCDev

I've solved my problem. For future generations, I will share what I've learned. First off, my problem was not related to custom code, but the user that was executing the NodeCreate() function, in this case Admin. My problem went away when I had the event script run as any user but Admin. Second, the problem was due to the .fSessionProperties feature on the Admin prgCtx being clobbered. Third, the process of populating the custom column table (WebNodesDisplay) does not require distributed agents to be running. The sequence of events for populating columns is something like this:

1) In NodeCreate - call $LLIAPI.COlumnUtils.StartBulkAdd()

2) In attrData.DbPut called within .NodeCreateAttributes(), call the same $LLIAPI.COlumnUtils.StartBulkAdd() (update the refCount)

3) In attrData.DbPut() update the object saved above and add the column values

4) In addData.DbPut call EndBulkAdd() (reduce ref count, save object back to cache)

5) In NodeCreate call EndBulkAdd() - write the data from step 3 operation to the WebNodesDisplay table.

What I observed happening is that the bulkUpdateRecord which was updated and saved to the cache would get clobberred right after either step 4 or 5 so the write to the database wasn't happening.

I don't know any rational explanation for this behaviour except that it appears that somewhere along the way, when running as Admin, I end up having a different prgCtx object in the NodeCreate() method and in the AttrData object that is called within .NodeCreateAttriibutes(). I would be curious to hear from any in OT DEV as to what might explain this behaviour. I was unable to run my experiment on the OOB GUI using the Admin user as this user is locked down here.

-Hugh

Mohammad_Shareef_Baba

Hi Hugh,

I appreciate the effort that you put in here to get rid of the column population Issue. Yes you are right, it doesn't have anything to do with the distributed agents stuff.

PrgCtx should not lose the property fSessionproperties. How it can lose this value? a substantial calls to EndBulkAdd? Nope.

Make sure that your custom module is not calling $WebProspector.Utils.GetPrgCtx() in the process without checking who the current user is, this will flush off the saved values and gets a new admin program context.

Let me know the results.

Later,

Shareef

HFCDev

For me now, it's a moot point since I've moved on from that engagement. However, to answer your question as to whether I'm getting prgCtx from $WebProspector, I don't think so, but I can't prove one way or another. The prgCtx is coming from workflow, when the event script is run on the Item Handler. In other words, if I am using the WebProspector GetPrgCtx(), it's coming to me from core product.

-Hugh