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 - Arquesoft

Pages: [1] 2 3 ... 6
1
General Board / Re: Querying multiple optional tag values in SQLServer
« on: April 13, 2018, 08:55:57 am »
Not sure whats returned, but this may also be an option,
Code: [Select]
SELECT t_object.ea_guid AS CLASSGUID,
       t_object.Object_Type AS CLASSTYPE,
       t_object.Name,
   t_object.Stereotype,
   t_object.Author,
       t_objectproperties.Value As TAGVALUE
FROM t_object, t_objectproperties
WHERE t_object.Object_ID = t_objectProperties.Object_ID and t_objectproperties.Property in ('TV Name1', 'TV Name2')

The problem with this option is that there is only one column (in the results) with the value of all tag values and for each element you have multiple rows (one for each tag value).

The idea is to have a single row per element and the tag values as columns, even with bull values if they don't exist.

2
General Board / Re: Querying multiple optional tag values in SQLServer
« on: April 13, 2018, 08:51:58 am »
Aliases are wrong?

tv1.Value AS tv1,
tv2.Value AS tv1,
tv3.Value AS tv1,
       ...

should be...
tv1.Value AS tv1,
tv2.Value AS tv2,
tv3.Value AS tv3,
       ...

Sure, just a typo when copy-pasting and editing.

3
General Board / Querying multiple optional tag values in SQLServer
« on: April 13, 2018, 05:50:34 am »
We are implementing a custom search in SQL (for a model stored in SQLServer) trying to get a list of elements and their optional 'n' tagged values.

In our scenary, there are some elements without tagged values, other with some (< 'n') tagged values and other with all the 'n' tagged values.

We are trying a query structured like that:
Code: [Select]
SELECT o.ea_guid AS CLASSGUID,
       o.Object_Type AS CLASSTYPE,
       o.Name,
       tv1.Value AS tv1,
       tv2.Value AS tv1,
       tv3.Value AS tv1,
       ...
       tvn.Value AS tvn
FROM t_object o
     LEFT JOIN t_objectproperties tv1 ON tv1.Object_ID = o.Object_ID
     LEFT JOIN t_objectproperties tv2 ON tv2.Object_ID = o.Object_ID
     LEFT JOIN t_objectproperties tv3 ON tv3.Object_ID = o.Object_ID
     ...
     LEFT JOIN t_objectproperties tvn ON tvn.Object_ID = o.Object_ID
WHERE tv1.Property = 'TVName1'
  AND tv2.Property = 'TVName2'
  AND tv3.Property = 'TVName3'
  ...
  AND tvn.Property = 'TVNameN'

But it does not returns the expected results (all the elements and the values of the tags if they are present).

Any idea in how to structure this query? What's wrong?

4
The schema we used had been created with 20-Jun-2016 version. EASchema_1220_SQLServer.sql
There is not a new version of the schema since our database creation.

5
Thanks Geert. Actually I was thinking the same, but I just asked in case somebody had a better idea. So I will use one of them. Thanks.

6
I'm planning to develop an automation app that send emails to model users based on business rules on model data.

Where do you think is the best place to store the users email having in mind the model uses Windows authentication?

7
Still not possible in version 14 Beta  :(

8
This is a very serious bug which still exists in 12.1. Can't quite believe this has not been fixed as it can result in data corruption ad IMHO put into question whether EA can be regarded as fit for Enterprise. All of the below seem to happen to all team members almost daily

- script execution runs older version of the script
- script execution runs script form another tab
- script execution stops half way through without any error or warning

Closing project alone will not fix this only a restart of the client will.

My team experienced the same behavior frequently. We use a sqlserver repository, multiple users and version 13.5 (build 1352).


9
General Board / Tag groupping in extended stereotypes?
« on: March 07, 2018, 08:09:37 am »
I created a profile with stereotypes includig tag groups. Then, I created a new (child) stereotype extending (with a Generalization) the stereotype with tag groups. But the child stereotype, when using the profile, doesn't include the tag groups. The tags are plain-shown, not in groups as the father stereotype.

Any idea or suggestion? is this possible to do?

10
General Board / Latest version date on registered users section wrong
« on: January 03, 2018, 05:30:52 am »
When you log in into the registered users section, it says the lastest version is "Enterprise Architect 13.5, Build 1352. Posted 05-July-2017" but build 1352 was released in december.

For me it is ok, but as reseller, my clients feels the application has not been updated since july, which is not attractive when they pay for the subscription renewal.

Please fix it. Thanks.

11
As tested in a real environment (and confirmed via Sparx support), ALTER permission is not enough to make it works properly. Not found yet a solution.

12
General Board / Re: Filtering Matrices
« on: September 29, 2017, 11:50:27 pm »
Note the source of the row or columns of the matrix could be a selected package or a search. If you select a search, you can specify the search filter using the parameters you want, as the stereotype and any other.

13
General Board / Re: Capacitación EA
« on: September 21, 2017, 03:01:06 am »
Also consider https://arquesoft.com

14
You can create relationship matrix profiles and switch between them. It is the same as switching between diagrams but in the same window

15
I guess, as it happens always, these proxy elements are located in the same package of the diagram they are created in. Every time you create a new element (a new row in t_object table) in a diagram, its parent package is the same as the diagram parent package.

So, my suggestion is: create a locked package (in order to avoid user deletion), and via your automation relocate the proxy elements as children of this package. If you don't delete the package, the elements will remain in the model.

Pages: [1] 2 3 ... 6