go to post Alexander Koblov · Jan 12, 2023 Generally, you should install external web server and use it with the application. Private Web Server (the one that runs on 57772) are for Management Portal and some basic tests only https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...
go to post Alexander Koblov · Jan 10, 2023 Why do you want to know this, Gabriel? For some application logic or to estimate size of the global? Or for something else?
go to post Alexander Koblov · Dec 28, 2022 ODBC driver is backwards compatible. You can always use latest ODBC driver with previous IRIS versions
go to post Alexander Koblov · Dec 26, 2022 Choose Logical Mode in dropdown near the Query Builder. Perhaps IRIS SQL tries to do some Logical -> Display conversion and fails.
go to post Alexander Koblov · Dec 12, 2022 Make sure that you select the whole lines, so that first character on each line is selected
go to post Alexander Koblov · Nov 29, 2022 What error did you get? Are you sure, that the error is inside %CSP.Broker? %CSP.Broker is a dispatch class to call server-side methods. In most cases the error happens in the application method that is called via %CSP.Broker. Enable logging for CSP Broker and see if any additional information is logged in ^ISCLOG: USER>zn "%SYS" %SYS>kill ^ISCLOG, ^%ISCLOG %SYS>set ^%ISCLOG("Category","CSPBroker")=3 %SYS>set ^%ISCLOG=3 To disable logging: %SYS>kill ^%ISCLOG If %CSP.Broker is used to call ZEN Methods then enable also ZEN logs: %SYS>do ##class(%ZEN.Utils).%StartLog() %SYS>do ##class(%ZEN.Utils).%ShowLog() 1 13:40:51.606 OnPreHTTP /csp/sys/%CSP.Portal.Home.zen 2 13:40:51.809 InvokeInstanceMethod 138@%ZEN.Auxiliary.jsonProvider:RefreshFromServer 3 13:40:51.830 InvokeClassMethod %CSP.Portal.Home.GetNamespaceList 4 13:40:51.845 InvokeInstanceMethod 169@%ZEN.Component.html:ReallyRefreshContents %SYS>do ##class(%ZEN.Utils).%StopLog()
go to post Alexander Koblov · Nov 4, 2022 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...
go to post Alexander Koblov · Oct 25, 2022 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.
go to post Alexander Koblov · Oct 24, 2022 In System Explorer -> Globals check "Show SQL Table Names". You'll see information on how particular global is used.
go to post Alexander Koblov · Oct 4, 2022 Hi Joel. See decK utility https://docs.konghq.com/deck/latest/
go to post Alexander Koblov · Oct 3, 2022 %GetParameter: SET myinst=##class(Sample.Person).%New() WRITE myinst.%GetParameter("EXTENTQUERYSPEC")
go to post Alexander Koblov · Sep 28, 2022 I think the following should do this write *-3 https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
go to post Alexander Koblov · Sep 27, 2022 Please create a separate question. As I understand it is not related to the original one
go to post Alexander Koblov · Sep 27, 2022 Please see here https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
go to post Alexander Koblov · Sep 16, 2022 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
go to post Alexander Koblov · Sep 6, 2022 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?...