Unicode in ModelView SQL (XML-escape)

[Hurra]

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!

[Geert Bellekens]

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

[Hurra]

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!