Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Hurra on November 07, 2022, 09:21:43 pm

Title: Unicode in ModelView SQL (XML-escape)
Post by: Hurra on November 07, 2022, 09:21:43 pm
Hello!

I have a problem similar to:
https://www.sparxsystems.com/forums/smf/index.php/topic,43909.0.html

-> My text in Element.Note is XML-escaped and therefore replace characters with HTML-number (?) like å

But I have my query in a ModelView, and therefore no template to add custom field.

I find my element(s) with a query and want to print Element.Note.

I want the Element.Note column to show formatted text. I tried a lot of different stuff.

Code: [Select]
Element.Note AS [Note-Formatted]
Element.Note AS '[Note-Formatted]'
Element.Note AS [Note.Formatted]
Element.Note AS '[Note.Formatted]'
Element.Note-Formatted AS 'Notes'
Element.[Note-Formatted] AS 'Notes'
Element.[Note.Formatted] AS 'Notes'

I'm getting lost 😇

NOTE: this is a local QEAX-file.

I think I solved this one time somewhere, but can find how I solved it, or found the source to that solution. With this thread I'll know where to go!

Thank you for your time!
Title: Re: Unicode in ModelView SQL (XML-escape)
Post by: Geert Bellekens on November 07, 2022, 10:17:51 pm
I don't think there's a solution for this in EA currently.

I don't see any way to show the notes, except by tricking EA to hide the fact that a column actually contains a notes (formatted) text.
Therefore I assume that EA is not equiped to show formatted notes in modelviews.

The best thing to do is probably send in a feature request.

Geert
Title: Re: Unicode in ModelView SQL (XML-escape)
Post by: Hurra on November 09, 2022, 07:40:50 pm
I don't think there's a solution for this in EA currently.

I don't see any way to show the notes, except by tricking EA to hide the fact that a column actually contains a notes (formatted) text.
Therefore I assume that EA is not equiped to show formatted notes in modelviews.

The best thing to do is probably send in a feature request.

Geert

OK!

Thank you Geert!