Maybe %NOFLATTEN can help, if we're sure that inner query returns few results.

Also you can try to use IN.

Also possible to use $$$NULL macro:

do $$$AssertEquals(myObj, $$$NULL, "myObj is null")

For example, Java Gateway Wizard is at:

http:://host/csp/reg/%25ZEN.Template.ObjectGatewayWizard.JavaHome.cls

I usually use "find in files" and search for page title to find where it is.

[@Jeffrey Drumm]'s answer is way better.

in my sample, it should be like P.id = P1.id and P1.id =  P2.id.

It would work like that too.

Also, you self join on the identical fields "ID", so I guess the engine could infer p1.id = p2.id by "P.id  = P1.id and P.id = P2.id" , this would interfere my intention.

Please consider posting:

• sample classes
• sample data
• description of data you want to get
• what data you want to get
• query

SSH is more secure. Open telnet port can cause security problems.

Alternatively you can use WebTerminal.

You can call methods of parent class with ##super(arg1)

Have you tried d format flag

d - output Caché numeric properties that have value "" as null

Missed that.

Replacing "" with null seems like a better solution to me as " symbol is escaped to \", so "" should not be encountered in JSON, except for empty strings.

It seems to fail on second line of this code sample:

set prevspace="^"_$zu(96,12)
u 0::"^%X364"    ; Set mnemonic space
u 0::prevspace

Additional JSON functionality, such as JSON (de)serialization for arbitrary classes was at one point available but currently under review. It may appear in one of future versions. I've posted a workaround.

You can also check RESTForms - REST API  for your persistent classes, it does support JSON (de)serialization. Another article about RESTForms.

You can convert object to dynamic object and output it to JSON:

zn "samples"
set per = ##class(Sample.Person).%OpenId(1)
set obj = ##class(%ZEN.Auxiliary.altJSONProvider).%ObjectToAET(per)
write obj.%ToJSON()

Also check %ObjectToJSON in %ZEN.Auxiliary.altJSONProvider class.

1. There's no need to instantiate tResponse, it would be reinstantiated later anyway.

2. Please post ConsultaPaciente method from your class specified in WebServiceClientClass setting.

Another example - lets say you want to delete several files and check that all is fine:

ClassMethod MassDelete(){  #dim sc As %Status = $$$OK  // Deletes the file. Returns true if it succeeds and false otherwise.  // Pass return by reference to obtain the low level return value in case of errors  #define del(%file,%return) ##class(%File).Delete(%file,%return)  set file1 = "file1.txt"  set file2 = "file2.txt"  if (('$$$del(file1, .return1)) | ('$$$del(file2, .return2))) {    set sc = $$$ERROR($$$GeneralError, "Files '%1', '%2' deletion failed with codes: %3, %4", file1, file2, $get(return1), $get(return2))  }  quit sc}

In case of "||" if the first delete was successful , the second delete would not be called. Use '|' to attempt both deletes