Author Topic: SQL fragment for element with linked document  (Read 1221 times)

m2i7c9k

  • EA User
  • **
  • Posts: 53
  • Karma: +0/-0
    • View Profile
SQL fragment for element with linked document
« on: January 31, 2022, 11:59:51 pm »
Hi Guys,

I have a BPMN diagram with activities that have a linked document.
So, I created a template with the fragment that sorts the diagram element (order by t_diagramobjects.RectLeft ASC, t_diagramobjects.RectTop DESC)
but I have no clue how "print" under the element it's a linked document?

Thanx for the advice,
Mick

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 12258
  • Karma: +484/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: SQL fragment for element with linked document
« Reply #1 on: February 01, 2022, 12:46:21 am »
That's not really that easy.

Linked Document is available in a regular template, but not really in an SQL fragment.

What I usually do in these circumstances is to use a virtual document.
Create one model document for each activity, in the order as they appear on the diagram.
This allows me to use a regular template for the Activity, while still reporting them in the order I want.

I use a script to create the complete virtual document.

Geert

m2i7c9k

  • EA User
  • **
  • Posts: 53
  • Karma: +0/-0
    • View Profile
Re: SQL fragment for element with linked document
« Reply #2 on: February 01, 2022, 12:58:43 am »
Thanks a lot, Geert!

I'm afraid that I'm that good at creating virtual documents. I found your page about virtual documents, but I don't understand that :/
Maybe one day :)

So long,
Mick

Jan Prochaska

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: SQL fragment for element with linked document
« Reply #3 on: March 21, 2022, 07:35:01 am »
Hello,
could you post a small "anonymized" sample of your model and what the expected document should look like?
We are developing a document generator for EA called RepoDoc (https://repodoc.archimetes.com)
I'd like to learn more about your case to know if we can handle it in RepoDoc.
Kind regards,
Jan