Custom Table Script context

[Uffe]

Hello,


Anyone had a go at these custom table scripts?

I can create one and get it to execute, but what is its context?
That is, does it have a special variable representing the table? If not, how am I supposed to get at it?
Is there a magic way to interact with the two tags containing the table's format and content?
Does it have access to the full Object Model API? Are there any limitations compared to other scripts?
Can it reference another script? One packaged into an MDG Technology?


/Uffe

[qwerty]

No. My time as guinea pig is over...

q.

[pianoman]

I'm interested in this as well. The Sparx Custom Table section found on
https://sparxsystems.com/enterprise_architect_user_guide/15.0/model_domains/custom_table_artifact.html
doesn't have anything meaningful written about scripts.

I don't know what scripts to write. Is it the same jscript ones I write in the Scripting window? Will it recognize commands like Repository.SQLQuery()? Am I supposed to shoot for the script to output data in .xml format? Array format?

The help page is entirely unclear about this and basically only mentions something to the effect of, "You can invoke a behavior script."

[timoc]

I'm interested in this as well. The Sparx Custom Table section found on
https://sparxsystems.com/enterprise_architect_user_guide/15.0/model_domains/custom_table_artifact.html
doesn't have anything meaningful written about scripts.

I don't know what scripts to write. Is it the same jscript ones I write in the Scripting window? Will it recognize commands like Repository.SQLQuery()? Am I supposed to shoot for the script to output data in .xml format? Array format?

The help page is entirely unclear about this and basically only mentions something to the effect of, "You can invoke a behavior script."

I looked at it when it came out, but was dissapointed - it is a kind of cludgy. Think of it as a way of embedding table based information into an artifact for documentation. You are kind of limited to using the table manipulation tooling to make the table. You cannot import to or export from (except clipboard paste), so it is not even good for an embedded CSV source.

The underlying implementation is like an XHTML <table/> stored in a single SQL record - being a not invented here, the XML is not the global HTML standard for table and table formating, but their own XML markup (defined in the doc link).

You might be able to use some kind of SQLXML extensions to query it's contents, but i am not sure what for, because matinainting it as a source for anything looks like hard work.

[pianoman]

Thanks timoc.

Was hoping I could muscle my way to making use of it like how MagicDraw allows the structure of tables that pull information from the model, and then update back to the model when you change the info on the table.

This seems far from it and simply stated seems like it will be limited to non-model data.

[Robert van Egmond]

Hello,

I found something in a Youtube video introducing EA15.  https://www.youtube.com/watch?v=uEPP6ec9hVE at 23:35 they show an example of how to do this. You can enter the code for the script with by selecting the custom table and then Develop-->Source Code-->Behaviour-->Edit internal Code.  Here is the code snipped they use:

var theElement = Repository.GetElementByID(#OBJECTID#);
var theGrid = theElement.GetElementGrid();
var d = new Date();
var sVal =  d.toString();
theGrid.SetCell(0,1, sVal);
theGrid.Update();

Hope this helps!

Regards, Robert