go to post Alexander Koblov · Jun 5, 2022 Additionally seehttps://docs.intersystems.com/iris20221/csp/docbook/DocBook.UI.Page.cls?...
go to post Alexander Koblov · Jun 3, 2022 Hi Yone. Enable SOAP Log and check the SOAP Response that IRIS sendshttps://docs.intersystems.com/iris20212/csp/docbook/Doc.View.cls?KEY=GSO...
go to post Alexander Koblov · Dec 10, 2021 Open settings for the web application (Menu -> Web applications -> [choose web application]) where you run the production and put %CSP.Error.cls as the "Custom Error Page". Reproduce the error. You should see the actual error on the page.
go to post Alexander Koblov · Aug 18, 2021 Should work. What does this function returns? Does it work if you put something very simple in the bat file? E.g. echo qq > c:\temp\test.txt
go to post Alexander Koblov · Aug 18, 2021 InterSystems IRIS does not have a MEDIAN SQL function. However, it has different window functions. For example, Percent_Rank might help you here. create table test(c1 varchar(10), c2 integer) insert into test(c1,c2) select 'a',1 union all select 'b',2 union all select 'c',3 union all select 'd',3 union all select 'e',3 union all select 'f',4 union all select 'g',5 union all select 'h',6 select c1, c2, Percent_Rank () OVER ( ORDER BY c2 desc ) rank_no from test order by c2 desc c1 c2 rank_no h 6 0 g 5 .1428571428571428571 f 4 .2857142857142857143 c 3 .4285714285714285714 d 3 .4285714285714285714 e 3 .4285714285714285714 b 2 .8571428571428571429 a 1 1 Doc: https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=RS... Also, it's possible to create a user-defined aggregate function. See https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
go to post Alexander Koblov · Aug 9, 2021 You are connecting to the server 'localhost'. This server sends back the certificate. And this certificate says that it is for the server "cache". "cache" is not equal to the "localhost", hence the error. Either access the server using the name "cache" (e.g. by changing hosts file). Or change the certificate
go to post Alexander Koblov · Jul 21, 2021 Perhaps pagemaster and masterreference elements can help you here. There you can define different templates for the pages depending if the page is first or last https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=GRPT_r...
go to post Alexander Koblov · Jul 19, 2021 Hi Kevin. What version of Caché or InterSystems IRIS do you have? INFORMATION_SCHEMA.COLUMNS seem to be available only since Caché 2015.2