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.

Messages - erobinson

Pages: [1]
General Board / Re: Indexes and constraints
« on: October 28, 2021, 07:36:19 pm »
Thank you so much! That helped!  :)

General Board / Re: Indexes and constraints
« on: October 28, 2021, 01:44:16 am »
Thanks for the quick replies! Really useful book, I'm certainly getting one!

I found the basic information in the t_attribute table, but not the additional information regarding the constraints / indexes. I create the index by following the steps below:
1.) Right-click on the Table element I created --> Features --> Constraints/Indexes
2.) Provide a name for the index, choose the Type of constraint (in my case 'index'), choose the column on which the index applies from the Available Columns list.

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 / Re: IBM Doors / Sparx EA integration
« on: April 09, 2021, 05:59:53 pm »
Thank you for the responses everyone, this really helped a lot!

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 recently logged this issue again in V15. Does anyone have a workaround?

That worked like a charm! Thank you so much for your help Geert!  ;D

Thank you Geert, that was really helpful! For some reason didn't find that bit of information when I was searching through the documentation.

However, I've tried various permutations now, but I still don't get formatted notes.

This is my query:
select t_object.Name as FMP5_ElementNames, t_object.Note as [Notes.Formatted]
from t_object
WHERE Object_Type = 'Object' and Object_ID in (select Object_ID from t_diagramobjects where Diagram_ID = #DIAGRAMID#) and PDATA5 = '1st Line Support'

And this is in my template:
custom >

< custom

I've also tried the .Formatted outside the curly brackets in my template.

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 / Re: Can you create a 'checkbox' tagged value type?
« on: October 02, 2019, 01:10:44 am »
Thanks for the quick reply Phil.  :)

I've tried this before and it didn't seem to work as I wanted it to. A value of 'Complete' is displayed in the Tagged Value window if all checkboxes are selected, otherwise a value of 'Incomplete'.

In my example though, when I print the document, 'Complete' is printed and not the comma-delimited list from the database. Is there something specific you need to do? I use {Pkg.valueOf(FMP2)} in my template where FMP2 is the name of my Tagged Value field.

How did you actually manage to map the comma-delimited list using a script driven fragment? Can you perhaps give me an example?

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]