The diagramm shows to me 2 object REFERENCES (oref)
oref consists of a (local) integer@Classname and points to an object.
in your case both are of type %Collection.ListOfObj
by the reference you can't tell that this is the same.
any ##class(%Collection.ListOfObj).%New() will create a new oref
in your case I see a count of 1 and then a count of 2
you should look what happens in or after (19) and in or after (29)
looks to me like a fresh return value
COS shorthand is hard to read in browser;
I personally prefer full size COS + Courier as font.
set CountRow=pObject.IssuesList.GetAt(i).Count()
you assume pObject.IssuesList.GetAt(i) gives back a %Collection Object (Iist, Array, ..)
Before applying method .Count() you should check if this assumption is true.
your previous description with ASSIGN / APPEND wasn't that convincing that you always have the object you expect.
ref: "out of the scope of ENSEMBLE to an external class"
you should save anything that you want to keep over that call in one/multiple property of %context Object.
you missed the $TRANSLATE(.....," ",0) around
pls. set the hook to your preferred solution
$EXCTRACT() and also $LI(), $Piece()
is not allowed at the left side of SET when the target is an object property
use an intermediate variable instead.
e.g.
it might be easier that way
Thank you Heikki,
I have passed this "cooling" too and missed the "heat." So my mind is back and the body stays at home 
Hi Lexi,
if you prefer to work unplugged you also may use HAMSTER (it's bilingual DE/EN)
http://www.elbiah.de/hamster/pg/
*
wow, I wish a had more than 1 thumbs up 
Did it work ?
Looks like running the query but not getting a resultset.
You seem to be reading past the last row you got.
Hardcore fix, if noting better. Wrap it in Try { } Catch {} /// it's not my favourite
quite tricky
by lack of responses I converted it from a question to an article + comment
Then that's the curse of $PIECE() with no chance to fake it.
So name the separator # ' " . / \ ~ ^ ...anything but ,
[ as Johnny Cash was singing: ... anything but "Sue" ]
I did a short test fiddling arouned ^Samples.PersonI
an to demonstrate the output.
This looks good so far.
start here
it might not be as trivial as you think
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…
HTH
to work down a collection of varying number of elements I'd use this kind of loop
in this case it's a double loop
For res=1:1:callresponse.result.Count() {
Continue:'$IsObject(callresponse.result.GetAt(res)
For err=1:1:callresponse.result.GetAt(res).Count() {
Continue:'$IsObject(callresponse.result.GetAt(res).errors.GetAt(err)
Set context.ErrorMessage= callresponse.result.GetAt(res).errors.GetAt(err).message
- - - -
}
}This is the paranoic version!
If you trust ENSEMBLE you may skip the check for $IsObject()
HTH
this could have been what you were looking for.
it's pure CSP.
Light weight EXCEL download
https://community.intersystems.com/post/light-weight-excel-download
HTH
! "， " is seen just as another string text
You need the unicode character here to make it working
columnHeaders="house number"_$C(65292)_" appartment"
! "， " is seen just as another string text
You need the unicode character here to make it working
columnHeaders="house number"_$C(65292)_" appartment"
sorry, was in the wrong context before
Alexey,
with $ZF(-1,command) you are at OS level.
Nothing prevents you from extending command to a script that writes its pid in a file.
using $JOB_".pid" or similar as file name should be enough to identify it.
So after a moderate HANG your pid should be available.
I prefer this to using pipes or other sophisticated solutions (e.g. listening on a TCP/IP or UDP port, ...)
as you get an embedded trace for free
HTH
online docs don't give a direct hint.
so my shot from the hip:
selection expression - $select(), $case() where you get a value based on a condition
data expression - anything that sets, modifies, composes data.
this is a quite academic view since data expressions may contain selection expressions
and selection expressions may contain data expressions.
both variants and any mix of it are quite common in COS
HTH
Sorry, what's the context? SQL ? COS ?
Are there also english Versions of those videos ?
My Spanish is rather rusted and more oriented towards holidays.
I did a short test fiddling arouned ^Samples.PersonI
This looks good so far.
Similar using Class %System.License. ... you may reduce the number of allowed connections by USER
This might be interesting in SaaS situation.
classmethod SetUserLimit(MaxLU As %Integer) as %Integer
$SYSTEM.License.SetUserLimit establishes the maximum number of license units that this Cache instance will consume. This permits a system manager to prevent a Cache instance from consuming all the license units in a MultiServer key shared among multiple Cache instances. The Method returns the former maximum value. In the absence of a call to $SYSTEM.License.SetUserLimit(max) a Cache instance may consume all available license units.
Requires access to the %Admin Manage resource.
Using Class %System.License. ... you may reduce the number of allowed connections by instance
• classmethod SetConnectionLimit(MaxCon As %Integer) as %Integer
$SYSTEM.License.SetConnectionLimit establishes the maximum number of connections permitted per user on this instance. This enables a system administrator to prevent a user from making so many connections to a Cache instance that they consume all available license units. Calling $SYSTEM.License.SetConnectionLimit($SYSTEM.License.MaxConnections()) permits a user to make the maximum connections permitted but prevent transitioning to the license unit per connection state, insuring the user will consume no more than one license unit. A zero argument removes the limit. The failure to obtain a license will be indicated in the normal way. For example, a call to $system.License.Login() will return zero (0) while a failure to log in to a new terminal connection will receive a error. However, these license failures will not be reported in the console log. The method returns the former maximum value.
The limit applies only to the local instance. If a Cache MultiServer license is shared among several instances it is still possible to exceed $SYSTEM.License.MaxConnections() over all instances. This can be avoided by setting the limit low enough on each instance that the combined connections to all instances will be unlikely to exceed $SYSTEM.License.MaxConnections().
$SYSTEM.License.SetConnectionLimit reqires access to the %Admin Manage resource. It is suggested that customers call this API from SYSTEM^%ZSTART.
high comfort service !
ClassReference of %Library.Persistent shows it as sub classes
http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?…
Tom.
In a similar situation I changed only one of the Serial classes to %RegisteredObject.
Compilation was fine:
Next I changed it back to %SerialObject.
Complation was fine again. And remained fine.