Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - flavius

Pages: [1]
1
General Board / How to track changes to documents provided by BAs
« on: December 02, 2024, 07:40:00 am »
Dear community

I hope to find some help here.

The Business Analysist will provide a word document, let's say with requirements. I import it as internal and extract the requirements by selecting the text, then Create -> New -> Requirement.

This also creates links to the model elements newly created. That's great.

Then the BA will send me a new document, with things changed inside.

How can I track the changes, without losing the links from the document to the requirement nodes?

I've played around with: Tracking, Baselines, Clone Structure as new version (and re-importing the new .docx file) - and a few other features. However I could not get the desired outcome.

If someone can tell me step by step a way to do it, which preserves the links in the document, that would be great. Also what won't happen: BA who works in EA.

Thanks.

2
I actually found now https://sparxsystems.com/enterprise_architect_user_guide/16.1/model_publishing/custom_sql_fragments.html

I got it to work, but the table looks broken.

Puzzle pieces:

1. the template fragment, defined as custom sql:

Code: [Select]
SELECT
t_object.ea_guid AS CLASSGUID,
t_object.Object_Type AS CLASSTYPE,
t_object.Name,
t_object.Note AS [Note],
t_object.Stereotype,
op.Property,
op.Value
FROM
t_object
INNER JOIN (
t_diagram
INNER JOIN t_diagramobjects ON
t_diagram.Diagram_ID = t_diagramobjects.Diagram_ID) ON
t_object.Object_ID = t_diagramobjects.Object_ID
LEFT JOIN t_objectproperties op ON op.Object_ID = t_object.Object_ID
WHERE
t_diagram.Package_ID = #Package#
AND t_object.Object_Type = 'Actor'
AND t_object.Stereotype = 'Stakeholder'
ORDER BY
t_object.Object_Type,
t_object.Name

2. The template visually:




3. The output:

As you can see, it outputs multiple tables. I've resized them so that it's visible, but that is possible because they're different:


3
Got EA recently, Unified Edition, and I'm impressed.

However, I have a problem.

I got my ModelView nicely rendered as a table on a diagram, all good.

The problem is, how to add this element also in a new custom document I'm working on?

When I drag and drop, I select "dynamic content", but which template would work?

Ideally, it will be added as a regular msword-style table, but it doesn't have to be - it just has to be not horrible and include the headers.

There's also a slight problem, the column "Note" is not shown on the diagram, but the query works correctly if I query the DB with another sqlite3 client.

Code: [Select]
SELECT
t_object.ea_guid AS CLASSGUID,
t_object.Object_Type AS CLASSTYPE,
t_object.Name,
t_object.Note,
t_object.Stereotype,
op.Property,
op.Value
FROM
t_object
INNER JOIN (
t_diagram
INNER JOIN t_diagramobjects ON
t_diagram.Diagram_ID = t_diagramobjects.Diagram_ID) ON
t_object.Object_ID = t_diagramobjects.Object_ID
LEFT JOIN t_objectproperties op ON op.Object_ID = t_object.Object_ID
WHERE
t_diagram.ea_guid = '{06B8688C-1539-45d0-9270-218EDBED0B74}'
AND t_object.Object_Type = 'Actor'
AND t_object.Stereotype = 'Stakeholder'
ORDER BY
t_object.Object_Type,
t_object.Name

Thanks

4
General Board / Buy now 16, get 17 later for free?
« on: July 15, 2024, 11:43:06 pm »
If I buy the latest stable version now (16), will I be able to upgrade for free to version 17 for free, once it exits beta?

Pages: [1]