Products

Home › Forums › eaDocX queries › Search Results in Excel

Home › Forums › eaDocX queries › Search Results in Excel

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • 6 December 2017 at 11:44 am #9118
    Tom Tomasovic
    Participant

    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

    6 December 2017 at 11:47 am #9119
    Tom Tomasovic
    Participant

    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]

    6 December 2017 at 12:21 pm #9120
    Guillaume Finance
    Participant

    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.

    6 December 2017 at 12:26 pm #9121
    eadocX Support
    Participant

    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…

    6 December 2017 at 12:30 pm #9122
    Tom Tomasovic
    Participant

    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?

    6 December 2017 at 12:31 pm #9123
    Tom Tomasovic
    Participant

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

    Tom

    7 December 2017 at 12:48 pm #9124
    Guillaume Finance
    Participant

    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?

    7 December 2017 at 2:35 pm #9125
    eadocX Support
    Participant

    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
Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.

Compare licence prices

Choose the licence that’s right for you and your team

Prices

Download a free trial

Download eaTeamWorks today for several free for life features, plus no obligation, 30-day trials of all the products: eaDocX, ea Revision Manager, eaSheets, Model Expert and PortfolioManager. Discover for yourself why we sell the world’s best-selling Enterprise Architect extension.

Download