You are totally right.
I tried to stick with the original questions. And I wouldn't formulate it that "traditional" way.
As you noticed there are more efficient and meaningful constructs possible.
- Log in to post comments
All
Accepted answers
Try "" instead of null which would be a variable named null
do $$$AssertEquals(myObj, "", "myObj is null")
or
set null="" do $$$AssertEquals(myObj, null, "myObj is null")
or to cover undefined as well
do $$$AssertEquals($GET(myObj), "", "myObj is null")
- Log in to post comments
quicker again
- Log in to post comments
My sample took somewhat longer to prepare then Edward's 
and Gerd's
#1) to evaluate SQL statements use MgmtPortal/ Explorer/SQL and check the generated query plan.
#2) if you don't use special attributes to SELECT clause or sub-queries all SQL statements are strictly worked from left to right.
your first statement is ok for SQL your 2nd is just a fragment that I interpreted as to be a sub-query
Summary: they are not identical.
Now the example transformed for namespace SAMPLES to have 3 tables as A, B, and C:
select A.id,B.id,c.Id from
sample.person A left join
sample.employee B on A.id = B.spouse
inner join sample.company C on B.company = C.id
sample.person A left join
sample.employee B on A.id = B.spouse
inner join sample.company C on B.company = C.id
Row count: 100
Query Plan:
Relative cost = 4200
Read extent bitmap Sample.Employee.$Employee, looping on ID.
Read extent bitmap Sample.Employee.$Employee, looping on ID.
For each row:
Read master map Sample.Employee.IDKEY, using the given idkey value.
Read extent bitmap Sample.Person.$Person, using the given ID.
For each row:
Read master map Sample.Company.IDKEY, using the given idkey value.
Output the row.
Read extent bitmap Sample.Person.$Person, using the given ID.
For each row:
Read master map Sample.Company.IDKEY, using the given idkey value.
Output the row.
transformed to sub-queries:
select aid,bid,cid from
(select A.id aid, b.id bid, b.company cid
from sample.person A
left join sample.employee B
on A.id = B.spouse)
inner join sample.company C
on cid = C.id
(select A.id aid, b.id bid, b.company cid
from sample.person A
left join sample.employee B
on A.id = B.spouse)
inner join sample.company C
on cid = C.id
it is obviously identic ! just more expressive.
Row count: 100
Query Plan:
Relative cost = 4200
Read extent bitmap Sample.Employee.$Employee, looping on ID.
Read extent bitmap Sample.Employee.$Employee, looping on ID.
For each row:
Read master map Sample.Employee.IDKEY, using the given idkey value.
Read extent bitmap Sample.Person.$Person, using the given ID.
For each row:
Read master map Sample.Company.IDKEY, using the given idkey value.
Output the row.
Read extent bitmap Sample.Person.$Person, using the given ID.
For each row:
Read master map Sample.Company.IDKEY, using the given idkey value.
Output the row.
the next LEFT_JOIN(A,INNER_JOIN(B.C)) requires immediate transformation
select A.id,bid,cid from
sample.person A left join
(select b.id as bid,c.id cid, b.spouse bsp
from sample.employee B
inner join sample.company C on B.company = C.id)
on A.id = bsp
sample.person A left join
(select b.id as bid,c.id cid, b.spouse bsp
from sample.employee B
inner join sample.company C on B.company = C.id)
on A.id = bsp
Row count: 237 (!!!!)
Query Plan:
Relative cost = 32408
Read extent bitmap Sample.Person.$Person, looping on ID.
For each row:
Call module E.
Read temp-file A, using the given VIEW column #3, and looping on VIEW counter.
For each row:
Generate a row padded with NULL for the view if no row qualified.
Output the row.
Read temp-file A, using the given VIEW column #3, and looping on VIEW counter.
For each row:
Generate a row padded with NULL for the view if no row qualified.
Output the row.
module E
Read extent bitmap Sample.Employee.$Employee, looping on ID.
Read extent bitmap Sample.Employee.$Employee, looping on ID.
For each row:
Read master map Sample.Employee.IDKEY, using the given idkey value.
Read master map Sample.Company.IDKEY, using the given idkey value.
Increment view row counter.
Add a row to temp-file A, subscripted by VIEW column #3 and VIEW counter,
with node data of VIEW column #1 and VIEW column #2.
Read master map Sample.Company.IDKEY, using the given idkey value.
Increment view row counter.
Add a row to temp-file A, subscripted by VIEW column #3 and VIEW counter,
with node data of VIEW column #1 and VIEW column #2.
So both variants are possible though the result is different
HTH,
- Log in to post comments
As alternative to copy you can also map ^EnsPortal.SavedSearch* in your secondary namespace to use it in parallel.
- Log in to post comments
Telnet port 23 is typically blocked on Unix/Linux Servers.
I'd suggest to use some other terminal program with support of SSH to log in (eg. Putty www.putty.org)
But be aware on UNIX/LINUX you log in to a shell and have to start csession for "Terminal like" access
- Log in to post comments
the key difference is that you can pass the classname by a variable.
So you are prepared to get the classname passed by some other method.
In your example with a constant string"circle"you miss the key advantage and It's of o added value.
BTW. Correct is $classmethod("circle.radius","%New")
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…
- Log in to post comments
For testing with Terminal I typically use PuTTY. http://www.putty.org/
There I can have multiple terminals with separated Sessions/$JOB in parallel without problem.(pls. don't ask how )
Terminal driver changes to a free set of ports ( 51133|10088) as you see by $IO
so it's no problem to have multiple terminal sessions connected
USER>w $io
|TNT|127.0.0.1:51133|10088In Atelier just click again to the Terminal Open Icon:
- Log in to post comments
valid observation.
- Log in to post comments
is Enable %Service_Telnet set ?
in the Management Portal (http:///csp/sys/sec/%25CSP.UI.Portal.Services.zen)
My Caché runs on Win .(I'm not sure if this works also for Caché on Unix )
It does NOT work for Unix:
| %Service_Telnet | Yes | Yes | Unauthenticated | Unrestricted | Controls Telnet sessions on a Windows server |
So on UNIX you go to bash and have to start via csession....
- Log in to post comments
so what you are looking for is something similar to XML IGNORENULL = 1
short time ago I ended up with export to XML and then convert XML to JSON.
Not so impressive but better than chasing unwanted "".
- Log in to post comments
Right: if you don't establish TELNET connection it's just bash or MS-DOS depending on your local OS.
Also for local localhost access !
so from Help:
Using the Terminal Plug-in
Telnet Connection
If your Caché instance is on a remote Windows server, you will need to connect using Telnet.
-
Enable %Service_Telnet from the Management Portal (http://
/csp/sys/sec/%25CSP.UI.Portal.Services.zen) -
In the main menu, select Show View > Other > Terminal > Terminal, or click this link to open the
Terminal View. -
Select the Open a Terminal button on the Terminal view toolbar.
-
Select Telnet Terminal from the Choose terminal drop down menu.
-
Complete the Telnet session configuration and click "OK"
-
If csession isn't in your PATH, navigate to your instance's bin directory. For example, cd C:\InterSystems\Cache\bin.
-
Launch a Caché terminal session. For example, csession Cache.
Setup Connection
And you get your Caché Terminal
HTH
- Log in to post comments
Funny to meet amCharts again as I presented it first to customers as alternative to ZEN graphics
around 2011/12 with Caché 2011.1
- Log in to post comments
¿ did the answers solve the issue ?
- Log in to post comments
and keep quiet when it installs.
this is not Caché and it takes it's time 
(I just spent 25 min for an Update/Upgrade)
- Log in to post comments
It is. I have used it some time ago.
You need a suitable plug in and connect to port 23 of your server
(provided it is not blocked by Win* firewall.
plugin from the following update repository: http://download.eclipse.org/tm/terminal/marketplace/.
- From your Eclipse/Atelier workspace, navigate to
Help > Install New Software from the main menu. - Enter the URL for the Terminal plugin update site in the Work with field. Ensure that the Group items by category check box is selected.
- Once the groups are displayed, select the check box by the newest version.
- Click Next to open the Install Details page. Review your installation choices.
- Click Next to open the Review Licenses page. Accept the license terms and click Finish.
- To open the Terminal view, select Window > Show View > Other on the main menu and type "terminal" in the filter box. Select Terminal and OK.
- Log in to post comments
Because it's so easy I've added a solution for those readers that don't refuse to work with Caché Objects & Classes .
Class Definition
{
Property product As %String(CONTENT = "MIXED", XMLPROJECTION = "CONTENT");
}
Simple display method
{
set rd=##class(%XML.Reader).%New()
,sc=rd.OpenString(xml)
do rd.Correlate("product","DC.productListing")
while rd.Next(.obj) {
write !,"######"_$i(cnt)_"#########",$replace(obj.product,$c(10),$C(13,10))
}
}
Extended test data
USER>write xml
<productListing title="ABC Products">
<product>
<name>Product One</name>
<description>Product One is an exciting new widget that will simplify your life.</description>
<cost>$19.95</cost>
<shipping>$2.95</shipping>
</product>
<product>
<name>Product 2</name>
<description>Product 2 is an exciti</description>
<cost>$19.95</cost>
<shipping>$2.95</shipping>
</product>
<product>
<name>Product 3</name>
<description>Product 3 is simplify your life.</description>
<cost>$19.95</cost>
<shipping>$2.95</shipping>
</product>
</productListing>
USER>
<productListing title="ABC Products">
<product>
<name>Product One</name>
<description>Product One is an exciting new widget that will simplify your life.</description>
<cost>$19.95</cost>
<shipping>$2.95</shipping>
</product>
<product>
<name>Product 2</name>
<description>Product 2 is an exciti</description>
<cost>$19.95</cost>
<shipping>$2.95</shipping>
</product>
<product>
<name>Product 3</name>
<description>Product 3 is simplify your life.</description>
<cost>$19.95</cost>
<shipping>$2.95</shipping>
</product>
</productListing>
USER>
Result
USER>do ##class(DC.productListing).Show(xml)
######1#########
<name>Product One</name>
<description>Product One is an exciting new widget that will simplify your life.</description>
<cost>$19.95</cost>
<shipping>$2.95</shipping>
######2#########
<name>Product 2</name>
<description>Product 2 is an exciti</description>
<cost>$19.95</cost>
<shipping>$2.95</shipping>
######3#########
<name>Product 3</name>
<description>Product 3 is simplify your life.</description>
<cost>$19.95</cost>
<shipping>$2.95</shipping>
USER>
######1#########
<name>Product One</name>
<description>Product One is an exciting new widget that will simplify your life.</description>
<cost>$19.95</cost>
<shipping>$2.95</shipping>
######2#########
<name>Product 2</name>
<description>Product 2 is an exciti</description>
<cost>$19.95</cost>
<shipping>$2.95</shipping>
######3#########
<name>Product 3</name>
<description>Product 3 is simplify your life.</description>
<cost>$19.95</cost>
<shipping>$2.95</shipping>
USER>
- Log in to post comments
what's wrong with Caché Objects and Classes ?
I remember, you had a similar fear some time ago 
- Log in to post comments
Class not found + Win7 makes me think you should check your System Variable CLASSPATH ?
just a guess.
- Log in to post comments
This is one of my personal reasons to use PuTTY or WebTerminal or anything else than TERMINAL.
- Log in to post comments
Kevin,
if you call a ClassMethod() it will return whatever the type of return value is like.
some variants:
- your Classmethod generates the CSV file as you do and the return value is the filename
ClassMethod Kevin1() as %String [SqlProc]
{
....... generate CVS File
quit Filename
}
- instead of a file you generate a 2 dimensional $Piece String (, as field separator and ^ as record separator)
ClassMethod Kevin2() as %String(MAXLEN="") [SqlProc]
{
....... setup ResultSet
set output=""
while rs.Next() {
for col=1:1:rcws.GetColumnCount() { set output=output_rs.GetData(col)_"," }
set output=output_"^"
}
quit output
}
- a similar thing could be rows as a list of JSON sets
ClassMethod Kevin3() as %String(MAXLEN="") [SqlProc]
{
set output=""
&SQL( SELECT LIST(line) into :output FROM (
Select top 3 JSON_OBJECT('Name':Name
,'ZIP':Home_ZIP
,'State':Home_State) as line
from sample.Person where name [ 'A' )
)
)
quit output
}
/// {"Name":"Xiang,Agnes O.","ZIP":56604,"State":"MT"},{"Name":"Zubik,Bill A.","ZIP":78872,"State":"NV"},"Name":"Schaefer,Alvin X.","ZIP":63607,"State":"ME"}
in all cases you have to disassemble the result on the EXCEL end.
BUT as this is MS-EXCEL
my personal preference would be anyhow to connect to Cache over ODBC with a local DSN
and just call your data via SQL and get back a full working XLS table that feeds the rest in your XLS.
This is standard in EXCEL and except for the DSN the same for ACCESS or real DBs.
(as I don't own and use EXCEL any more I can't offer an example)
- your initial question didn't mention CSV nor MS-EXCEL
so my Article on Light weight EXCEL Download may apply
https://community.intersystems.com/post/light-weight-excel-download
or Tips & Tricks - SQL to Excel
https://community.intersystems.com/post/tips-tricks-sql-excel
HTH,
Robert
- Log in to post comments
An alternate approach to SOAP:
a) you run your query over JDBC on your DataServer
so you can query what ever you like
b) slightly more sophisticated
you create a ClassMethod with [SqlProc] parameter and also call it over JDBC
like this. SELECT Pkg.Class_ClassMethod()
It's totally up to you what the content of your return value is.
I personally prefer JDBC as it's platform independent
in fact b) is pretty much the same as SOAP just with a different transport that avoids %CSP and its side effects.......
- Log in to post comments
Proposal:
Store your JSON String as %String(MAXLEN="") like a log file
for the typical components type, age, firstname, lastname, ...
create calculated properties that find its content by $piece, $find or some JSON specific stuff.
setup an index on those calculated properties to find your record.
With this approach you keep the origin as you get it and get te indices you may require.
It's pretty similar to what I did to mimic an XML DB with Caché
so 1) =NO 2) =see above 3) =YES 4) = it's just another challenge
- Log in to post comments
Evgeny,
it's great !
only the link requires adjustment.
NOT https://community.intersystems.com/post/github.com/intersystems-communi…
but https://github.com/intersystems-community/
- Log in to post comments
Hi Tim,
I'm highly interested to see this result.
I tried to do something similar recently to to be able to feed back to the sender what was wrong if something was wrong.
I failed to get the combinations of params for XERCES parser right. XMLIGNORE* worked OK but was not so useful.
You might have a shorter link to contact Marvin Tenner then me.
- Log in to post comments
As we see your ID is combined by 3 properties
for the sake of this example I name them id01, id02, id03
so your ID is this combination ID = id01_"||"_id02,_"||"_id03
so you may reformulate your query to make it readable
SELECT * FROM TafnitCore_Logistics_TransferPackage_DB.PackageData
WHERE id01=1 AND id02=1 and id03 IN (9852553062, 9852553061 )
ORDER BY Building
WHERE id01=1 AND id02=1 and id03 IN (9852553062, 9852553061 )
ORDER BY Building
- Log in to post comments
I'd suggest you apply as Support Engineer @ InterSystems
and over the years you might learn all the secrets of Caché.
I doubt what you ask for is subject for a public forum.
- Log in to post comments
check side conditions of the related column.
from docs:
property onclick as %ZEN.Datatype.eventHandler;
onclick event handler: This event is fired when the mouse is clicked within a cell in this column. If the column does not have data associated with it you will have to set the linkCaption property.
Note that this callback is called before the new row in the table is selected so you will not have the current selectedIndex for the table when this callback is fired. If you need that, use the tablePane's onselectrow callback.
Note that this callback is called before the new row in the table is selected so you will not have the current selectedIndex for the table when this callback is fired. If you need that, use the tablePane's onselectrow callback.
- Log in to post comments
See details here:
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…
especially:
Sample Global Names and Their Uses
-
^globalname — a standard global
-
^[directory,system]globalname — bracket syntax for an implied namespace in an extended global reference
your case
2) is a broken call for a label in a routine and has nothing to to with globals
probably do a^myroutine
2) is a broken call for a label in a routine and has nothing to to with globals
probably do a^myroutine
3) looks like a broken condition on variable a also no globals around
a| could be the beginning of a OR ....
a| could be the beginning of a OR ....
- Log in to post comments
If your connection is not stable enough I'd suggest to take a closer look to good old Shadowing.
It's really jungle proof.
I used it in past to transfer data from an oil drill platform somewhere out on the ocean over a satellite link with just 64k bd bandwidth without any data loss. And this link was far from whatever you would expect from a wired connection on ground.
Shadowing did id with incredible stability and no loss.
Cascading of shadowing is also almost unlimited with no issue.
- Log in to post comments