Choose Logical Mode in dropdown near the Query Builder. Perhaps IRIS SQL tries to do some Logical -> Display conversion and fails.

See also

SET OPTION PKEY_IS_IDKEY = true

With this enabled your sample works as you expect

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

Mark, you need to close connections from Web Gateway to IRIS, so that Web Gateway reconnects and CSPSystem logins with the new role. You can do this in Web Gateway -> Status page -- close button for the second table. Or just restart the web server.

Note -- Roles field in the Audit details. Check that it has %DB_SRFT role when happens again.

In System Explorer -> Globals check "Show SQL Table Names". You'll see information on how particular global is used.

Hi Joel.

See decK utility
https://docs.konghq.com/deck/latest/

%GetParameter:

SET myinst=##class(Sample.Person).%New()
WRITE myinst.%GetParameter("EXTENTQUERYSPEC")

I think the following should do this

write *-3

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

Please see here
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

var from your sample is not an object in ObjectScript. It is an object reference.

So in first case you pass object reference by value.
In second case you pass object reference by reference. That is reference to object reference.

I don't think you should expect noticeably better performance

If you can select from this stored procedure then you can try to use this select in INSERT into.

Does the following work?

SELECT * Custom_MENS_Other.samplesp('2021-11-02','2021-11-04','H001')

See Table-Valued functions section:
https://docs.intersystems.com/ens201815/csp/docbook/Doc.View.cls?KEY=RSQ...

And INSERT with SELECT:
https://docs.intersystems.com/ens201815/csp/docbook/DocBook.UI.Page.cls?...