SQL Search macro #BranchGUIDorID= xyz#

[McMannus]

Thanks for the enlightenment, Helmut! I thought this is a hidden EA feature that I can use in my add-ins as well :-)

[Helmut Ortmann]

Hi  McMannus,

hoTools is a Windows COM Object. If you need the feature to run advanced SQL from another Addin or even Script (vbScript, JavaScript, JScript) you should be able to use the functionality.

The interface would be:

• Repository
• SQL String
• Search Term (can handle wild cards)

There could be two features:

• Run SQL
• Return SQL

If you are interested let me know.

On GitHub you can get the newest release and the current documentation. I don't always update the EA Community.

Regards,

Helmut

[qwerty]

Helmut, you could save yourself quite some work by just linking the community site to your github page :-)

q.

[PeterHeintz]

Thanks to Helmut’s hoTools the functionality is available, however I think to have the feature build in EA would be good e.g. build “self-maintained” Kanbans having elements underneath a defined package. A more general implementation would be to have the possibility to call script methods from SQL returning a SQL fragment as string.