Author Topic: Macros for Graph queries: package branch  (Read 1943 times)

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1078
  • Karma: +34/-2
    • View Profile
    • www.umlchannel.com
Macros for Graph queries: package branch
« 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
« Last Edit: December 11, 2019, 01:32:28 am by Guillaume »
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


Prolaborate Support

  • Prolab Moderator
  • EA User
  • *
  • Posts: 300
  • Karma: +22/-0
    • View Profile
    • Visit us
Re: Macros for Graph queries: package branch
« Reply #1 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 prolaborate@sparxsystems.com