Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - erobinson

Pages: [1]
General Board / Indexes and constraints
« on: October 27, 2021, 07:27:45 pm »
If I create indexes and constraints on certain columns, in which EA table will I find this? I can see the basic information in t_attribute, and I notice there is a t_attributeconstraints table, but not finding any helpful information there. Any ideas?

General Board / IBM Doors / Sparx EA integration
« on: April 08, 2021, 10:35:30 pm »
Can EA Sparx communicate/share data with IBM DOORS Next Generation, and IBM DOORS Classic, either directly or through a middleware? We use the former and want to make sure that we can carry out data exchange between the two tools.

I have a diagram which contains 4 lanes (vertical partitions). Each of these can contain one or multiple elements, and all the elements have notes behind them. The aim is to have 4 different sections in the document, each section should contain information from one of the lanes:
•   Name of the lane
•   Name of the element
•   Notes behind the element

If I use the ‘standard’ functionality provided in the document generator, i.e. don’t write custom SQL fragments, the following extract will print everything after the diagram image, but I cannot move it to different sections and you are dependent on the order EA loops through the elements. Please correct me if I’m wrong here….

diagram >
< diagram
element >

child elements >
< child elements
< element
< package

I’ve tried removing the element >  tag and writing custom SQL (using fragments) to retrieve the information. This works up to a point, but then I get stuck with the notes coming back ‘unformatted’. Also, when the script returns multiple elements, I don’t know how to get the information in the ‘Element Name’ with ‘Element Notes’ underneath it format. (I’m not that up to date with writing complex SQL queries.)

Has anyone tried something similar before?


General Board / Can you create a 'checkbox' tagged value type?
« on: October 02, 2019, 12:01:14 am »
I am creating a template to generate a custom document from information stored in EA. One of the values in the document needs to be populated from a 'checkbox' type field. I want the user to see a list of items and it should be possible to select one or more of these items. The selected items should then be displayed in the generated document. The only thing I could think of was tagged values, but if there are any other suggestions, that would be welcome!  :)

Pages: [1]