Messages

76

General Board / Re: Extract the list Actions for each Actor

« on: September 24, 2022, 02:06:36 am »

the problem is that you have twice the column Name in your query.

Give the package name a different alias, and you should be fine

Code: [Select]

select t_package.Name as PackageName, ...
Also, it's a good idea to use proper join syntax to keep your sanity.

Something like this:

Code: [Select]

select act.ea_guid AS CLASSGUID, act.Object_Type AS CLASSTYPE,
p.Name as PackageName, actor.Name as ActorName, act.Name as ActionName, d.Name as DiagramName, act.ea_guid
from t_object prt
left join t_object actor on actor.Object_ID = prt.Classifier
and actor.object_type = 'Actor'
inner join t_object act on act.ParentID = prt.Object_ID
and act.object_type = 'Action'
inner join t_package p on p.Package_ID = act.Package_ID
left join t_diagramobjects do on do.Object_ID = act.Object_ID
left join t_diagram d on d.Diagram_ID = do.Diagram_ID
where prt.object_type = 'ActivityPartition'
and p.Package_ID in (#Branch#)
PS. If you want this to work on a .eap file you'll need to add a bunch of parentheses to cater for weird the MS-Access syntax.

Geert

Thanks Geert Bellekens it works! Is it possible to centralise this search in the company? Or do we have to export/import on each PC?

77

General Board / Re: Extract the list Actions for each Actor

« on: September 24, 2022, 02:03:59 am »

Yes, maybe. I wanted to download the trial version but I got a "Server error"

I could not reproduce the issue, but I have sent the trial key to your email address. Please enjoy it!

Now it works

78

General Board / Re: Extract the list Actions for each Actor

« on: September 23, 2022, 07:41:11 pm »

In order to create a meaningful query you need to know the database structure. That's a bit of a PITA but worth the effort if you want to use EA "for real".

q.

I have tested and it meets our requirements. But I have this problem.
If I use my query in a EA-File-Project, the query extracts all the values.

If I use my query in a EA-MsSql-Repository the Query Builder doesn't extract all the values.
Column t_package.Name doesn't extract any value.

The same query on SQL Management Studio extracts all values for all columns


This is the query

Code: [Select]

select t_package.Name, t_diagram.Name from t_object partition, t_object actor, t_object action, t_package, t_diagram, t_diagramobjects
where partition.object_type = 'ActivityPartition'
and actor.object_type = 'Actor'
and action.object_type = 'Action'
and partition.classifier_guid = actor.ea_guid
and action.parentID = partition.Object_ID
and action.package_id = t_package.Package_ID
and t_diagram.Diagram_ID = t_diagramobjects.Diagram_ID
and action.object_id = t_diagramobjects.Object_ID


79

General Board / Re: Extract the list Actions for each Actor

« on: September 23, 2022, 07:32:06 pm »

Hello ea0921,

Maybe what you want to do is the first image in the following URL:
https://www.sparxsystems.jp/en/trace/

HTH,

Yes, maybe. I wanted to download the trial version but I got a "Server error"

80

General Board / Re: Extract the list Actions for each Actor

« on: September 23, 2022, 12:37:24 am »

I have never created custom queries. How do I do that?

81

General Board / Extract the list Actions for each Actor

« on: September 22, 2022, 08:33:51 pm »

Hi,

I created my Actors (Actor1, Actor2). Next I created an activity diagramm in which as swimmlines I used two partitions that have as instance classifier = Actor1 and Actor2. I therefore have two vertical partitions :Actor1 and :Actor2.
In each swimmline I then inserted and linked the Actions.
I then created n other activity diagrams with the same logic.
I would now like to create a list that extracts for each Actor which Actions it is associated with. I started with the idea that by making partitions-instances of Actors and inserting Actions into these partitions, I can extract which Actions are associated with which Actors.

Is it possible?

Thanks

82

General Board / Re: Report Elements From External Packages in generate documentation

« on: September 21, 2022, 03:23:55 pm »

My problem in reporting has not been solved yet. 

83

General Board / Re: Report Elements From External Packages in generate documentation

« on: September 20, 2022, 07:01:23 pm »

No, no filter has been added to it
When I drag an external element and add it to the package it works fine.

84

General Board / Re: Report Elements From External Packages in generate documentation

« on: September 20, 2022, 06:44:04 pm »

I have tried both methods

package >
Package Name: {Pkg(dot)Name}
diagram >
Diagram Name: {Diagram(dot)Name}
element >
{Element(dot)Name}
< element
< diagram
element >
Element Name: {Element(dot)Name}
diagram >
{Diagram(dot)Name}
< diagram
child elements >
Child: {Element(dot)Name}
< child elements
< element
< package

85

General Board / Report Elements From External Packages in generate documentation

« on: September 20, 2022, 05:44:39 pm »

Hello, I want to make a report of all elements of the diagram. I followed the site guide and activated the following checkboxes:

• In the 'Properties' dialog for selected diagrams, the 'Add each contained element in Documentation' checkbox, to identify all the elements in those diagrams in your report, or
• On the 'Generate Documentation' dialog, the 'Include all Diagram Elements in Report' checkbox to include all elements in each and every diagram checked by the report
  

But when generate the documentation, there are no External elements in the report.
external elements are Business rules, activities and data objects which are included in Business Process Diagram.

86

Bugs and Issues / Re: How to get hierarchy of different types of elements

« on: September 12, 2022, 10:17:11 pm »

No, wanted to know regarding the hierarchy between different element types. Like hierarchy of the different element types, i.e. SYSML, SPEM, Archimate, Class, Object, Composite and the hierarchy dependency between them. Like SYSML elements are sub type of Class element type.

https://www.omg.org/spec/UML/2.5.1/About-UML/

Do you mean the UML metamodel?
That is published by the OMG at https://uml.org

Geert

87

Bugs and Issues / How to get hierarchy of different types of elements

« on: September 06, 2022, 11:11:08 pm »

Many of the elements of EA, belong to "Class" element and many of them do not. How do we bifurcate this hierarchy.
Is there any specific hierarchy that which follows other element types, wherein the base types of elements derive another types of elements. Hierarchy of the element types, i.e. SYSML, SPEM, Archimate, Class, Object, Composite and the heirarchy dependency between them. Like SYSML is a sub type of Class element type.

88

General Board / Re: When I generate document, notes dispaly messy code. &#25163;&#26426;&#21495;

« on: April 25, 2022, 07:03:28 pm »

There are several built-in templates.
The default one (Model Report) is actually a very complex combination of many templates depending on the type of element.

Without knowing all the details it's hard to help.

Geert

All template display notes information in messy code.
My OS code is GBK.
The coding of notes seems to be utf8


It seems to be caused by this problem.

89

General Board / Re: When I generate document, notes dispaly messy code. &#25163;&#26426;&#21495;

« on: April 25, 2022, 06:37:16 pm »

Which template do you use to generate the document?

This is equally as important. If you are using a script or SQL fragment, without telling EA it's a formatted field, you'll get these type of things.

Geert

I use the built-in template of the system.

90

General Board / Re: When I generate document, notes dispaly messy code. &#25163;&#26426;&#21495;

« on: April 25, 2022, 05:59:42 pm »

You'll have to be a bit more specific?
Which template do you use to generate the document?

How does it look in the GUI? Do you see the real characters, or also the unicode codes.

Geert

yes,I can see the real characters in the notes window.