There's nothing built-in for this, but you can simulate it via custom class queries or %SQL.AbstractFind. I have an implementation of %SQL.AbstractFind/%Library.FunctionalIndex that does some things with hierarchies but falls short of the capabilities you linked in the Oracle doc. Specifically, it can find all ancestors/descendants/both (the whole tree) in a hierarchy efficiently, but it doesn't follow the same rules around ordering and won't let you do paths and such. (I'd want to clean it up a good deal before sharing, but that's probably worthwhile at some point.)
I think I've seen this before when IRIS responds with a login page due to credentials being passed to the SOAP call incorrectly. https://community.intersystems.com/post/example-connecting-cach%C3%A9-we... has an example of the expected headers, though in PHP (likely not your language of choice here).
go to post
I filed it June 18, 2019.
go to post
Worldwide Response Center (WRC)
For Immediate Response
Phone:
+1-617-621-0700
+44 (0) 844 854 2917
0800615658 (NZ Toll Free)
1800 628 181 (Aus Toll Free)
Email:
support@intersystems.com
Online:
WRC Direct
Email support@intersystems.com for a login.
go to post
This is the right answer. It would be nice if there was a more built-in way to include row IDs in %JSONExport without having to do this though.
go to post
The closest thing to what you're looking for is %VID (link to documentation)
You can use this even without an actual view as follows (for example):
go to post
@Tani Frankel this is a nice solution! I'd still like to see this there automatically somehow though.
go to post
With what we've done the syntax ends up looking like:
Because there's a self-referencing property with a bitmap index, the hierarchy support is automatic via the MemberSuper class. Output is:
go to post
There's nothing built-in for this, but you can simulate it via custom class queries or %SQL.AbstractFind. I have an implementation of %SQL.AbstractFind/%Library.FunctionalIndex that does some things with hierarchies but falls short of the capabilities you linked in the Oracle doc. Specifically, it can find all ancestors/descendants/both (the whole tree) in a hierarchy efficiently, but it doesn't follow the same rules around ordering and won't let you do paths and such. (I'd want to clean it up a good deal before sharing, but that's probably worthwhile at some point.)
go to post
Ah - yes, that would make sense. I suspect VSCode would do better. ;)
go to post
You can use as modern HTML and CSS as you want.
go to post
I think I've seen this before when IRIS responds with a login page due to credentials being passed to the SOAP call incorrectly. https://community.intersystems.com/post/example-connecting-cach%C3%A9-we... has an example of the expected headers, though in PHP (likely not your language of choice here).