Messages

1

Automation Interface, Add-Ins and Tools / Re: Getting author of modification

« on: March 12, 2013, 07:37:11 pm »

I'll check that out. Once again, thank you for the pointers!

2

Automation Interface, Add-Ins and Tools / Re: Getting author of modification

« on: March 12, 2013, 02:49:35 am »

I do own Inside EA and it says the t_snapshot table contains that info; but this table is empty in my project  

3

Automation Interface, Add-Ins and Tools / Re: Getting author of modification

« on: March 12, 2013, 02:36:16 am »

Thank you for the tip, but could you please be more specif on what you mean by audit logs? I've been searching the tables without any success... or are they somewhere else?

4

Automation Interface, Add-Ins and Tools / Getting author of modification

« on: March 12, 2013, 12:32:15 am »

Hi all,

I'm trying to build a search where, besides the modification date (t_object.ModifedDate), the name of the user that performed the modification is displayed. Any pointers on where this information might be stored?

Regards,
Mateus

5

Automation Interface, Add-Ins and Tools / Re: Developing a Traceability SQL

« on: December 10, 2011, 01:28:58 am »

I appreciate your help a lot, Geert. It's the same for me here. I run out of ideas on what to do.

I payed attention for possible problems with the brackets but they seem fine. MS Access does accept left joins. I really am stuck now.

Of course, having EA run on top of MySQL is an option, but I don't want to assume all of the people using the add-in I am working on will have their EA set up like that. I'll keep on trying. I still wonder if the search I was looking for could be done with t_connector only, just for making it more compact.

Again, thank you very much! Hope we'll hear from someone who managed to get this right.

6

Automation Interface, Add-Ins and Tools / Re: Developing a Traceability SQL

« on: December 10, 2011, 12:08:19 am »

I am trying here as well and still couldn't figure it out. I think the left ones are not a problem, they worked for me. Anyone else out there has any clues?

7

Automation Interface, Add-Ins and Tools / Re: Developing a Traceability SQL

« on: December 09, 2011, 11:44:33 pm »

I figured I need to change the "JOIN" to "INNER JOIN", but still get an error in the FROM clause. Everything seem to be ok, the parenthesis match, so as for right now I'm still stuck...

8

Automation Interface, Add-Ins and Tools / Re: Developing a Traceability SQL

« on: December 09, 2011, 11:28:19 pm »

Thanks again Geert!
There's some error in the sintax but I'll try to figure it out...

9

Automation Interface, Add-Ins and Tools / Re: Developing a Traceability SQL

« on: December 09, 2011, 01:23:10 am »

Thanks for the help! The query works fine, except that it is not transitive - in the case of having A -> B -> C, and looking for what's connected to A, I'd get A and B, C is missing. Any thought on how I can achieve that?

10

Automation Interface, Add-Ins and Tools / Re: Developing a Traceability SQL

« on: December 09, 2011, 12:54:49 am »

Hi,

Sorry to bring up and old topic again but this is exacly what I am trying to do now.

I'm looking for an SQL query to find the transitive closure of an element - that is, all other elements a certain element relates to. In this case, the direction of an association does not matter, eg. A -> B -> C or A <- B <- C still would yield the same result, A is related to itself, B and C.

The query posted here does almost that, with the exception that when the element in question does not contain an association in which it is the source, nothing is returned.

I am trying to get a query that works in SQL because doing that using the EA repository object model is pretty slow - it's easy to write a method to do that, but the performance was not the best.

A last comment: can the query be written using only the t_connector table, or one of its views? Since the query posted here will return also the element's folders, diagrams and etc, which in my case do not matter.

Thanks!

11

Automation Interface, Add-Ins and Tools / Re: Add-in model search with C#

« on: November 09, 2011, 12:04:47 am »

Thank  you very much! I got it to work, with the method you suggested and just return "true" at the end. I guess it doesn't really matter what that value is since it is not read anywhere. The only thing that really has to be done is assigning the results to XMLResults.

Once again, thank you for the help!

One last question: is there any way of letting my method know what are the current results of a search? That is, if I wanted to run a search but only over results already obtained... The only solution I see is saving my XMLResults string in the add-in, but that would mean it would only work if the previous searches have been my custom one, and that I would have to parse the XML every time... am I missing something?

12

Automation Interface, Add-Ins and Tools / Add-in model search with C#

« on: November 08, 2011, 04:28:54 am »

Hello,

I've been trying to use the add-in searches without much success. I've already looked into all of the topics about this in the forum but couldn't exactly find the answer I'm looking for...

First of all, how should the signature for my search method look like? I got EA to call my method correctly, but the model search window does not display any results. I have tried these two:

Code: [Select]

public void testSearch(Repository repository, string searchText, string XMLResults)

Code: [Select]

public string testSearch(Repository repository, string searchText, string XMLResults)
Where on the second one I return XMLResults.

My sample XML result looks like this:

<ReportViewData>
<Fields>
<Field name="Object"/>
</Fields>
<Rows>
<Row>
<Field name="Object" value="Testability"/>
</Row>
</Rows>
</ReportViewData>

Any ideas on what I am doing wrong or missing? Any help would be very appreciated!