Sparx Systems Forum

Pro Cloud Server / Prolaborate / WebEA => PCS Suggestions and Requests => Topic started by: Guillaume on December 10, 2019, 10:57:22 pm

Title: Macros for Graph queries: package branch
Post by: Guillaume on December 10, 2019, 10:57:22 pm

Hi,

Working on SQL custom searches in EA, I can use the #Branch# macro to get the list of package IDs from the selected package in the Browser.
It would be useful to have a similar macro in Prolaborate with the Package ID or GUID as the input parameter to select its full branch.

Is this feasible?

In the meantime, I added to my query the following condition: WHERE source.Package_ID IN (1,2,3) but this doesn't work. "WHERE source.Package_ID = 1 or source.Package_ID = 2 source.Package_ID = 3' works ok.

Thanks

Title: Re: Macros for Graph queries: package branch
Post by: Prolaborate Support on December 19, 2019, 11:44:21 pm

Hi Guillaume,

We don't have any plans to support macros at least in the near future.

Both the queries are expected to work! Could you please try this query:
WHERE source.Package_ID IN ('1','2','3')

If this query doesn't work, please feel free to share your query and the type of EA database server to [email protected]