Messages

1

Automation Interface, Add-Ins and Tools / Re: Search-based Report

« on: May 03, 2012, 11:50:11 pm »

I tried out all the queries that you gave me and a implemented other ones. Many of them find the right package, BUT THE PROBLEM IS LIKE I SAID, THAT WHEN I APPLY THE TEMPLATE ON THE PACKAGE THAT I FOUND, THE TEMPLATE INTERPRETS THE FOUND PACKAGE AS A SIMPLE ELEMENT AND NOT AS A PACKAGE WITH ALL HIS ELEMENTS IN IT!!!

So I really think this is a bug...or do you have some TESTED SOLUTION  for my case???

Thank you very much!
Sam

2

Automation Interface, Add-Ins and Tools / Re: Search-based Report

« on: May 02, 2012, 06:53:50 pm »

Could anybody please help?? I really need it!!

Sam

3

Automation Interface, Add-Ins and Tools / Re: Search-based Report

« on: May 02, 2012, 05:38:41 pm »

The query should return results from my own project in EA which I'm actually working on, I'm not using some repository...

4

Automation Interface, Add-Ins and Tools / Re: Search-based Report

« on: May 02, 2012, 05:27:43 pm »

Could you not please write the whole sql-query selecting the Packages having Stereotype-value = 'someStereo' and returning the resulting packages as packages which contains all his subelements and can be used to apply a template on them?

5

Automation Interface, Add-Ins and Tools / Re: Search-based Report

« on: May 02, 2012, 05:22:09 pm »

from t_package
inner join t_object on t_package.package_ID = t_object.pdata1

but then you have to add the appropriate syntax/casts to make it work depending on your repository type.

Geert

How Can I do a cast? What is pdata1?

6

Automation Interface, Add-Ins and Tools / Re: Search-based Report

« on: May 02, 2012, 05:16:12 pm »

With the search I really find the package that I want (of type package), but when I apply the template to my result it treats it as a single element istead  of navigate it as a normal package!!

I really need some help! Thank you!!

7

Automation Interface, Add-Ins and Tools / Re: Search-based Report

« on: May 02, 2012, 05:08:41 pm »

The problem is always that I don't get a package back but only an element!! How can I get a package back??

Cheers
Sam

8

Automation Interface, Add-Ins and Tools / Re: Search-based Report

« on: May 02, 2012, 04:45:47 pm »

Ok I see, but what you mean exactly with "use the value in p_data1"? Can you write me the query? Many many thanks!!!

9

Automation Interface, Add-Ins and Tools / Re: Search-based Report

« on: May 02, 2012, 04:20:13 pm »

This doesn't give me error:
SELECT p.ea_guid AS CLASSGUID, 'Package' AS CLASSTYPE, p.Name FROM t_package p, t_object o WHERE p.package_id = o.package_id and o.object_type = 'Package' AND o.Stereotype ="aBOPackage"

But what I'm getting back is just the super-package of what I'm looking for and this one also just as an Element and not as a package!! How can i get back a package from an SQL-query??? The whole package with all his elements in it?

Tank you very much!!
Sam

10

Automation Interface, Add-Ins and Tools / Re: Search-based Report

« on: May 02, 2012, 04:09:19 pm »

I cannot write "t_package.Stereotype" this simply doesn't exists!

11

Automation Interface, Add-Ins and Tools / Re: Search-based Report

« on: May 02, 2012, 04:04:40 pm »

Hi qwerty, the query you gave me return an error: "Too few parameters. Expected 1."

Hi Geert, I don't exactly what you mean to do the query without "t_object" could you please write me the query which you mean??

I'm struggling with this problem since day!! Thank you very much!
Sam

12

Automation Interface, Add-Ins and Tools / Search-based Report

« on: May 01, 2012, 12:47:34 am »

Hi everyone,

I'm trying to generate a report selecting some packages using an SQL search : SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE FROM t_object WHERE t_object.Stereotype ="ABOPackage"

The selection works fine, the problem is that when I apply my template to the result of the query, the template reads the result-packages as a simple elements instead of reading it as  packages, and so I don't have all the elements included in the packages in my report...somebody could please help me?

Thank you veeery veeery much!!

13

Automation Interface, Add-Ins and Tools / Re: Virtual Document and SQL Search

« on: May 02, 2012, 06:27:25 pm »

Hi DhoX I'm sticking with the same problem and actually I found out, that your query just return an Element (namely the package-element you were searching for). Thus you just have a single element instead of the whole package containing all his elements...so when you apply your template to the result it doesn't find any element in your result...thats why the whole thing is not working!
Unfortunately I also didn't find any solution, did you? Thank you very much!

Sam