Book a Demo

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]