is it possible to get the values of the object to use as parameter of the query?
I don't think so. SQL must work from xDBC context and objects don't exist there.
How would you call your function from Management Portal or any SQL Editor?
Maybe you can go into Application Roles tab and add %ALL role.
After that try again from private window or another browser.
Unknown User must also be enabled.
This is only for dev/testing.
Consider updating to InterSystems IRIS.
By default Content is a stream. Try converting it into dynamic object
set content = {}.$fromJSON(%request.Content)OS update?
Contact the WRC.
Do you want to send a custom header with your HTTP request?
Check WorkflowUI-ngx / WorkflowAPI for customizable rendering.
Does it work over https?
Ctrl+Shift+C?
Why? Your shell is run under your user (vrogers). You use $ZF(-1) to spawn a child process which inherits everything from parent. Ergo, $ZF(-1) started from shell is also run under your OS user.
cacheusr is a linux user.
You can use %CSP.SessionEvents for that.
Correct.
Terminal sessions are run under OS user who runs the terminal.
CSP and Interoperability jobs run under cacheusr or irisusr by default or some other custom user if you specified that during installation.
@Sean Connelly shared a tip on how to enable auto-complete for macros.
No idea about routines though.
What do you want to achieve?
During installation you specified the user who owns the system. Try running cstop as that user.
You should check for disk speed and latency especially under heavy load. HS should be given a separate disk(s). Hyper-converged infrastructure like you describe can invite performance lags in unexpected ways.
Calling @Mark.Bolinsky.
Generalize.
1. You can have 1 BP/1 BO called GET resource which gets:
And based on that information constructs the required JSON.
2. If BP only proxies requests to BO you can skip BP and call BO straight from BS.
Check out RESTForms2 - it does something similar (CRUD over classes) and there's only 4 handlers for all classes.
If you want to minimize the roles given to a user, use Privileged Routine Applications.
With them, only specific lines of code would have additional privileges, such as %DB_CACHESYS:R.
For community Python Gateway I wrote an $lb -> tuple converter.
You can check it out here. To be callable from Python you can expose it as a Python C extension.
While I do agree, what's the use case?
If you're requesting objects en masse it's usually via sql and it's easy to provide id there.
In a case of a singular object you usually request it by ID so it's known beforehand.
Interesting question!
Here are my findings for store/intersystems/irishealth-community:2020.4.0.524.0 and a simple app in the USER namespace.
| Uncompressed (Mb) | Compressed (Mb) | |
|---|---|---|
| IRIS | 3 323 | 897 |
| IRIS Squashed | 3 293 | 893 |
| App | 8 436 | 1 953 |
| App MSB | 3 526 | 937 |
| App Squashed | 3 576 | 931 |
| App MSB + Squashed | 3 363 | 904 |
Notes:
docker inspect -f "{{ .Size }}" $image(docker manifest inspect $image | ConvertFrom-Json).layers | Measure-Object -Property size -SumConclusion: either MSB or Squashed work fine, but just MSB would be better for storage as it can have shared layers (squash always produces one unique layer). Squashed is easier to implement.
The best place to do that is your REST broker.
After you got your error from BP, just create your own error and pass that.
Can DB made RO for a while?
Check this article.
Doubltul - it requires Java installation or configuration.
Iterating through large pandas dataFrame objects is generally slow
You're right.
Thank you!
Why do you map %ZLANGC00/%ZLANGF00 to %ALL? They are available everywhere by default.