Messages

1

General Board / Re: SQL search for conveyed items and source/target names

« on: July 20, 2017, 12:14:46 am »

Thank you that's done the trick. 

2

General Board / Re: SQL search for conveyed items and source/target names

« on: July 19, 2017, 07:17:09 pm »

Thanks both.  I hadn't realised that the search syntax was slightly different depending on whether you were in an eap file or a shared server.

The wildcards now work but I've run into another issue.   To confirm the search query I'm using is:

Code: [Select]

select Connector_ID, Direction, Connector_Type, t_object.Name, so.name, eo.name
from t_connector, t_xref, t_object, t_object so, t_object eo
where t_xref.Client = t_connector.ea_guid and t_xref.description LIKE '#WC#'+t_object.ea_guid+'#WC#' and so.object_id = Start_Object_ID and eo.object_id = End_Object_ID and t_object.name LIKE '<Search Term>'
In the eap file the search returns the following columns:

Connector_ID | Direction | Connector_Type | t_object.name | so.name | eo.name

and the search results come up fine, listing the information conveyed, the start element and end element.  On the server, the same query comes back as:

Connector_ID | Direction | Connector_Type | Name | name | name

The first and third name columns are populated with the end element; the start element and the name of the information conveyed doesn't show up at all.  Maybe there's another syntax issue I need to correct in the query?

3

General Board / Re: SQL search for conveyed items and source/target names

« on: July 19, 2017, 02:05:53 am »

OK, an update on this topic - I've been busy building up some models using conveyed items, but storing this all in a local eap file.  I've then transferred this into my main SQL Server repository via an XMI import. Having done this, the custom search I created above now no longer works.  As far as I can see the search isn't timing out - it's taking longer but seems to complete - but comes up with no results at all.

I don't understand how a simple search can work OK in a local file and not on a shared repository.  To be clear, it's exactly the same search, held under 'My Searches'.

Any ideas?

4

General Board / Re: SQL search for conveyed items and source/target names

« on: June 20, 2017, 08:01:46 pm »

Many thanks, that gives exactly the result I need and it's quick and simple too!

5

General Board / SQL search for conveyed items and source/target names

« on: June 19, 2017, 08:00:48 pm »

I've been working with conveyed information and trying bits of script found on the forums.  I've managed to get the following SQL to list all items conveyed, and can return the Start_Object_ID and End_Object_ID:

select Connector_ID, Direction, Connector_Type, t_object.Name, Start_Object_ID, End_Object_ID from t_connector, t_xref, t_object where t_xref.Client = t_connector.ea_guid and t_xref.description LIKE '*'+t_object.ea_guid+'*'

What I'd really like is to return the names of the start and end object elements, not just the IDs.  Is there a bit of script that can do this?

I'm afraid I'm not a SQL expert and even less of a guru when it comes to finding info buried in Sparx's database!

6

General Board / Re: RTF Report: listing all connectors

« on: April 20, 2016, 07:21:56 pm »

I had the same problem with reporting of connector info and also had the idea of using the rtf generator to produce a csv-like output.  It's a bit clunky but does the job.

The code in the template editor looks something like this:

Code: [Select]

package >
connector,source,target
element >
connector >
{Connector.Type},source >element >{Element.Name},< element< sourcetarget >element >{Element.Name}< element< target
< connector
child element >
< child element
< element
child package >
< child package
< package
The output can be cut and pasted into Excel and turned into a table using the text to columns function.