I found this in the docs:

• From the server, users can:
  • Run, filter and modify reports.
  • Export to a variety of formats.
  • Schedule reports to be distributed via email or FTP.

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

And docs on the API:
https://reportkbase.logianalytics.com/v23.1/api/index.html

Have you looked at the Zen demos in the SAMPLE namespace?
https://docs.intersystems.com/ens201817/csp/docbook/DocBook.UI.Page.cls?...

This demo page shows a file upload control:
http://<HOST>:PORT/csp/samples/ZENDemo.ControlTest.cls

One quick/dirty(?) way is to do a "View Code in Namespace" for "%SYS". Under the %SYS namespace the percent classes are not filtered out.

I found a tokenize method in one of the %DeepSee packages:

USER>w ##class(%DeepSee.extensions.utils.StringMatchUtils).tokenize("this is a string blah blah.",.tokenArray)
1
USER>w

tokenArray=6
tokenArray(1)="this"
tokenArray(2)="is"
tokenArray(3)="a"
tokenArray(4)="string"
tokenArray(5)="blah"
tokenArray(6)="blah"
USER>

Would the built-in management reports meet your needs?
https://docs.intersystems.com/hs20222/csp/docbook/DocBook.UI.Page.cls?KE...

And these docs on HealthShare auditing should be helpful:
https://docs.intersystems.com/hs20222/csp/docbook/DocBook.UI.Page.cls?KE...

Standalone installers for Caché ODBC drivers are available on the software distribution page in the WRC.

Hi Rochdi,

You don't need to use %File and then copy it to a file stream. You can just use %Stream.FileCharacter to directly open and read the file:

  Set stream=##class(%Stream.FileCharacter).%New()
  Set sc=stream.LinkToFile("c:\myfile.txt")
  While 'stream.AtEnd {
  Set line=stream.Read()
  ; Process the chunk here
  }

And I can confirm that I've also seen %Stream.FileCharacter significantly outperform %File for reads.

-Marc

I suspect the problem is that you're using a %DynamicObject. BPLs should use persistent/persistable objects because business process execution can in some cases be suspended temporarily and then resumed. Before execution is suspended, context objects are saved into the DB.

%DynamicObjects are not persistent objects, so their values are lost when execution is suspended. You can overcome this by using %ToJSON to serialize the %DynamicObject into a stream property of the context object. Streams are persistable.

It's not clear to me what "early binding" means in the context of a data transformation. Do you mean something that happens at the time the DTL is compiled rather than at runtime?

If you can clarify what you mean by "early binding" that will help us get you an answer.

It would be great to have a cheat-sheet for all of these keyboard shortcuts and other tricks, especially in terms of "if you used to do X in Studio, here's how to do that in VS Code".

A few months ago I happened across the incantation for the VS Code equivalent of Studio's "Find in Files" (free text search of server-side classes) but forgot the key combination and haven't had the time to try to figure out which docs to check and guess at whether it's a standard feature of VS Code or of the ObjectScript plug-in.

Yes, you can absolutely do that. You separate statements with 2 spaces. Here's an example:

for i=1:1:10 {
    write i,!
    write i*10,!
}

This gives the same output:
for i=1:1:10 {  write i,!  write i*10,!  }

It also works without brackets, but IMHO is less readable:

for i=1:1:10  write i,!  write i*10,!

Menno,

In your ObjectScript code you never base64 decode the key:

set key="pZR8qfrz7t47G+dboyJCH4NnJRrF+dJbvxq37y/cLUo="
...
Set encrypted=$SYSTEM.Encryption.AESCBCEncrypt($zcvt(text,"O","UTF8"),key,iv)

But you did this in Python:

keyBase64="pZR8qfrz7t47G+dboyJCH4NnJRrF+dJbvxq37y/cLUo="
key = base64.b64decode(keyBase64)
...
cipher = AES.new(key, AES.MODE_CBC)

Adding the additional logging helped. Looking at it now, it looks like it is working as coded:

9413847-9428572 BEGENING OF LOOP FOR: XAL465.1110.A0
9413847-9428572 START RECURSIVE
9421986-9428572 Has Value
9413847-9428572 BEGENING OF LOOP FOR: XAL465.1110.A1

The call for 9413847 is looping through all results of the query. It finds that 9421986 has a composition so it calls itself recursively. The call for 9421986 finds that it already has a value so it returns control to the 9413847 loop which continues iterating.

If you want all super and sub loops to quit as soon as any sub-loop finds "has value" then you will need to check for this condition inside the loop.

It's a bit hard to follow the output. I think things will become clearer if you add "mainArticle" and "article" to every WRITE statement, for example:

You can check the audit database for RoutineChange events.

This has come up a few times before in other threads.

https://community.intersystems.com/post/encoding-base64-stream-chunk-sizes

The ORC group is repeating, and all of it's child segments are optional, so you can iterate through the ORC group in order to get at the OBRs that it contains.

But... you can also just set the DTL create mode to "copy" and all of the segments will get copied over automatically without needing to iterate through each ORC.