Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: bouquen on January 15, 2020, 11:36:00 pm

Title: SQL request to get type of a BPMN Activity
Post by: bouquen on January 15, 2020, 11:36:00 pm

Hello,

We use SQL requests to generate reports and we did not find the answer about one point: is it possible to get the type of a BPMN activity (abstractTask, userTask, scriptTask, callProcessActivity...) using a SQL request? We did not find any table with taht information but we were maybe looking at the wrong place.

Thank you!

Title: Re: SQL request to get type of a BPMN Activity
Post by: Uffe on January 16, 2020, 12:07:42 am

Hello,

Those are tagged values, which are stored in t_objectproperties, which you can join with t_object on Object_ID.
The name of each tagged value (activityType, taskType, ...) is stored in the Property column, and the content in Value.

HTH,


/Uffe

Title: Re: SQL request to get type of a BPMN Activity
Post by: bouquen on January 16, 2020, 12:27:00 am

Hello,

Thank you for the answer. I had found that information but, for example, I cannot find values such as 'callGlobalTaskActivity'. Values are available for taskType ("Values: BusinessRule,Manual,Receive,Service,Send,Script,User,Abstract
Default: Abstract") but we did not find them for callActibity and Sub-process.

Thanks!

Title: Re: SQL request to get type of a BPMN Activity
Post by: Uffe on January 16, 2020, 12:54:29 am

Hi again,

If I understand correctly, you're after the set of possible values for a tag, rather than the specific value of a tag in one element.
If so, you probably can't get that through SQL.

Tagged value type definitions can be created in-project (Configure - Reference Data - UML Types), in which case they're stored in t_propertytypes. But they can also be located in MDG Technologies, which are XML files the client reads and keeps in memory. Definitions found there are not written to any table.

All Sparx-supplied technologies (such as BPMN) are located in the install directory, eg C:\Program Files (x86)\Sparx Systems\EA, under the sub-directory MDGTechnologies. You can look in there for the tagged value definitions, the format's reasonably readable.

Note also that not all tagged value types have enumerable values. They can be free-text, or references to model elements (known as "RefGUID" tags), or any one of a couple of dozen other types.

HTH,


/Uffe

Title: Re: SQL request to get type of a BPMN Activity
Post by: bouquen on January 16, 2020, 01:38:32 am

Hi again,

And thank you again. To make things more clear, a screenshot of the values I'd like to get is available here: https://imgur.com/6ki7sXD (https://imgur.com/6ki7sXD).
Those values are by default in EA BPMN 2.0 so I don't know if I have to handle them as custom?

Thanks!

Quentin

Title: Re: SQL request to get type of a BPMN Activity
Post by: Uffe on January 16, 2020, 02:22:25 am

Ahhh, I see.

I'm afraid that EA's BPMN implementation is not built using EA's standard extension mechanisms, as I've described them above.
You'll note that changing the Type in that dialog causes other things to happen, it isn't just a selection of one of a set of possible values for one tagged value. A humble MDG Technology smith such as myself couldn't customize a dialog like that.

So this is a custom implementation of a property dialog which behaves in a non-standard way. I think your best bet is to contact Sparx support.

/Uffe

Title: Re: SQL request to get type of a BPMN Activity
Post by: Eve on January 16, 2020, 09:07:38 am

Those values don't actually exist anywhere. They are the combination of properties.