go to post Eduard Lebedyuk · Jul 3, 2018 Here's an example of accessing properties and array elements: set jsonObj = [].%FromJSON(filename) set i = jsonObj.resultSets.%GetIterator() while i.%GetNext(.key , .resultSet ) { set i2 = resultSet.rowSet.%GetIterator() write resultSet.name,! while i2.%GetNext(.key , .rowSet ) { write rowSet.%Get(0),! } }
go to post Eduard Lebedyuk · Jul 3, 2018 $zu(68,40,switch) can be replaced with: set old=$system.Process.SetZEOF(switch) Also, what does this command do? kill ^TMP($zn,$j)
go to post Eduard Lebedyuk · Jul 3, 2018 This error indicates that either login and password are incorrect or that user has insufficient permissions to access management portal.
go to post Eduard Lebedyuk · Jul 2, 2018 Generally you'll need to check the service and adapter method lists. Callbachs are often called "On*".Similar discussion for SQL adapter.
go to post Eduard Lebedyuk · Jul 2, 2018 1. Connect to other system via xDBC2. Query %Dictionary package on a local and remote system and compare results.
go to post Eduard Lebedyuk · Jun 29, 2018 But prior to 2010.1 we didn't have $NAMESPACEAs @Lucas.Fernandes uses $namespace in his solution: #dim currentNamespace As %String = $namespace that is not a concern in this particular case.
go to post Eduard Lebedyuk · Jun 28, 2018 Here's my URL template jdbc:Cache://{host}[:{port}]/{database} If you connect but get Access Denied, try user with %ALL permissions to remove doubts about insufficient privileges.
go to post Eduard Lebedyuk · Jun 28, 2018 Are there advantages to using: set currentNamespace = $namespace znspace "%SYS" // do stuff znspace currentNamespace Instead of: new $namespace set $namespace = "%SYS" // do stuff
go to post Eduard Lebedyuk · Jun 27, 2018 You can use %Stream.FileBinary and %Stream.GlobalBinary classes.
go to post Eduard Lebedyuk · Jun 26, 2018 4. Didn't found how to do that automatically, but adding <br/> to text value adds a new line, i.e.: Set var(0,1) = "!!!!!!!!!!!!!!!!<br/>!!!!!!!!!!!!!!!!!!!!!"
go to post Eduard Lebedyuk · Jun 25, 2018 Thank you, Marc!Set body to Arial and it works: <body foStyle="font-family='Arial'">
go to post Eduard Lebedyuk · Jun 25, 2018 So far I got: Class Test.Zen Extends %ZEN.Report.reportPage { Parameter DEFAULTMODE = "pdf"; /// ReportDefinition is a placeholder. XData ReportDefinition [ XMLNamespace = "http://www.intersystems.com/zen/report/definition" ] { <report xmlns="http://www.intersystems.com/zen/report/definition" name="MyReport" runonce="true"> </report> } XData ReportDisplay [ XMLNamespace = "http://www.intersystems.com/zen/report/display" ] { <report xmlns="http://www.intersystems.com/zen/report/display" name="MyReport"> <body> <table ongetData="GetCount"> <table orient="row" ongetData="NamesAndAddresses" style="border:1pt solid black"> <parameter fieldnum="1"/> <item fieldnum="1" > <caption value="Name"/> </item> <item fieldnum="2" > <caption value="Title" /> </item> <item fieldnum="3" > <caption value="Pages" /> </item> </table> <parameter value="test" /> </table> </body> </report> } ClassMethod GetCount(ByRef var As %String, ByRef params) { set count=3 for i=0:1:count-1 { set var(i, 0) = i } } Method NamesAndAddresses(ByRef var As %String, ByRef params) { if (params(1) = 0) { Set var(0,0) = "Alice" Set var(0,1) = "Hello" Set var(0,2) = 123 } elseif (params(1) = 1) { Set var(0,0) = "Bob" Set var(0,1) = "World" Set var(0,2) = 456 } elseif (params(1) = 2) { Set var(0,0) = "Charlie" Set var(0,1) = "!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!" Set var(0,2) = 789 } } } Which produces this output: The questions I have: Is there a way to add breaks between "rows"?How do I add inside table borders?How do I give 10% of width to Name/Page/Title and the rest to values?How do I auto-break long strings into several?
go to post Eduard Lebedyuk · Jun 25, 2018 Please try to send 1.txt through the pipeline with contents like 123.Are the hexdumps the same for that case?
go to post Eduard Lebedyuk · Jun 22, 2018 Try setting Charset to Binary in your BO, and check that file is Binary in your source BH.I'd try sending txt file through the pipeline and compare the results.