Messages

1

General Board / Re: How to create a simple extract of UML (Data) Class names and descriptions

« on: May 26, 2021, 06:43:13 pm »

Thanks guys for the fast responses.  That resolved it.  The one field that is hidden by default.  I get the rational why the field is treated differently, but Sparx don't make this stuff easy

2

General Board / Re: How to create a simple extract of UML (Data) Class names and descriptions

« on: May 26, 2021, 04:15:24 pm »

Thanks Paolo and Geert for the replies.  How did I miss that field? - seems obvious.

Went back to my query and run a simple:
select name, note from t_object
where object_type = 'Class'

No error, but no note field returned.  Same if I run select * from t_object.  Are the HTML descriptors preventing the column being returned?

I'm just running from the SQL Scratch pad option in Search Model feature

3

General Board / How to create a simple extract of UML (Data) Class names and descriptions

« on: May 26, 2021, 12:50:34 pm »

I'd like to create a data entity catalogue out the objects in EA.  Thought this would be a simple one table SQL query.  By description I mean the rich text box on the object / properties page.  t_object is the main table - name field found simple enough.  Can't find the description field.  Because rich text, maybe more complex.  Not even sure what the field is called?  No label on the front-end.  Tried to use the Query builder, but I can't seem to edit the fields returned beyond the base entity