Search Results in Excel

[Tom Tomasovic]

Hi!

I have created a SQL query which returns Class and Class Attributes, along with some selected properties of the Attribute.

I am trying to get the results exported as an Excel spreadsheet. I assumed that the appropriate way to do this would be to create a new Excel spreadsheet, select Searches and “Export Search Results.” However, that does not work. I get the results fine when I run the query as “Search in Model” (EA), but, when I export the search results in eaDocX/Excel, all I get is the Classes (Entity in the query below).

Query:
select distinct o.name [Entity], t.name [Attribute], t.Notes [Reference], t.Type, t.LowerBound [Mandatory], t.UpperBound [Multiplicity], t.Style [Mapping] from t_object o, t_attribute t, t_attributeconstraints c where o.Stereotype = ‘Data Entity’ and o.Object_ID = t.Object_ID and t.Notes like ‘SUC%’ order by o.Name,[Attribute]

Thanks!

Tom

[Tom Tomasovic]

Note: Query above is not quite right. Should be (although both versions work in EA):

select distinct o.name [Entity], t.name [Attribute], t.Notes [Reference], t.Type, t.LowerBound [Mandatory], t.UpperBound [Multiplicity], t.Style [Mapping] from t_object o, t_attribute t where o.Stereotype = ‘Data Entity’ and o.Object_ID = t.Object_ID and t.Notes like ‘SUC%’ order by o.Name,[Attribute]

[Guillaume Finance]

Hi,

This feature looks interesting however I can’t get it to work (eaXL > new worksbook > Searches).
First the query requires “t_object.ea_guid AS CLASSGUID” in the Select statement.

I tried your query but it doesn’t work?
I ran a test with the following and I only get the class name.

[code]select t_object.ea_guid AS CLASSGUID, t_object.name AS Entity, t_attribute.name AS Attribute from t_object, t_attribute where t_object.Stereotype = ‘test’ and t_object.Object_ID = t_attribute.Object_ID order by t_object.Name[/code]

I don’t know what I’m missing here.

[eadocX Support]

Good news – your timing is excellent – I’m just staring to look at this for eaDocX v4.
Not-so-good news – I won’t be doing any more fixes for V3…

[Tom Tomasovic]

Hi!

Your query returns pretty much what I expected from my model, but, again, the eaDocX extract is limited to the Elements (not the Attributes).

In terms of your query/model, I would suspect you don’t have an element with the appropriate stereotype which has attributes associated with it. That’s just a guess. As I said, it works fine for me.

Thanks!!

Tom

P.S. Looks like resolving this is on the “new features” development list, so, perhaps we are not doing anything wrong?

[Tom Tomasovic]

That’s OK. 2018 is coming along very soon! (;-}

Tom

[Guillaume Finance]

It would be interesting to support also connectors if that’s feasible, whilst adding the attributes support.
Is this feature purely intended to publish/export information from EA, or does it let us import things back based on the associated query?

[eadocX Support]

V4 eaXL won’t be provide general-purpose SQL access: so far, I can get it work reliably with EA Searches – no luck at all with pure SQL queries. So I think this is what we will ship with 4.0.

[Author]

Posts