[HTML Report, AlaSQL] Select Archimate concepts in view.

Started by AlexL, February 25, 2020, 08:20:26 AM

Previous topic - Next topic

AlexL

Archi 4.6.
When HTML Report is generated issuing a query like:

SELECT * FROM ViewsContent INNER JOIN Views ON ViewsContent.viewid = Views.id WHERE Views.name LIKE '%ViewName%' AND ViewsContent.contenttype LIKE 'DiagramModelArchimateObject'


returns table containing field ViewsContent.contentid. Value contained in this field could not be found amongst model elements.
Though I could not find a proper documentation on database structure, I'd like to know how can I get concepts by ViewsContent.contentid if it's possible.

Jean-Baptiste Sarrodie

Hi,

That's a bug. Can you please open an issue on GitHub and I'll fix it for next release.

Regards,

JB
If you value and use Archi, please consider making a donation!
Ask your ArchiMate related questions to the ArchiMate Community's Discussion Board.