Macros for Graph queries: package branch

[Guillaume]

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

[Prolaborate Support]

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]