All
Accepted answers
Evgeny Shvarov · Dec 12, 2016 go to post

The Tools tag introduced. I tagged some posts with Tools announcements, maybe missed some. Please add here in comments to let me tag it. Or tag it yourself if you are an author.

Evgeny Shvarov · Dec 8, 2016 go to post

Good point, Peter. Maybe we should add "InterSystems Caché" button which will paste two words? 

According to my experience if you want to find Caché you should search for "InterSystems Caché".

Evgeny Shvarov · Dec 6, 2016 go to post

Hi, Alessandro!

Thank you for the valuable post! 

One question: should we consider using %TIMERANGE or %OR instead of AGGREGATE just because of better query performance?

Evgeny Shvarov · Dec 2, 2016 go to post

Use $translate?

e.g.

ClassMethod NoAccents(stringWithAccents as %String) as %String 

{

 w "before: ",stringWithAccents

 set accent="Áêã",usual="Aea",!

 set val=$translate(stringWithAccents,accent,usual)

 w "after: ",val

 return val

}
Evgeny Shvarov · Dec 2, 2016 go to post

Eduard, thanks for the very promising article!

If I decide to use your framework, how can I deploy the library in my solution? What are the best practices for that?

Evgeny Shvarov · Dec 2, 2016 go to post

Somebody downvoted this post. Would you please comment, what is wrong? We can make it better, that's why this post is here.

Evgeny Shvarov · Nov 27, 2016 go to post

Thanks Andreas, that's interesting!

It's getting even more interesting with Web Terminal where is the sql mode enabled:

But "CREATE DATABASE" SQL expression creates only the Namespace and Database, but it doesn't create the default web app and the CSP/Namespace folder in case if you need it too.

Evgeny Shvarov · Nov 23, 2016 go to post

Benjamin, just a note: it would be great to have one question per one question posting. Here we have at least three :)

Evgeny Shvarov · Nov 23, 2016 go to post

Hi, Benjamin!

Have you tried dependent levels?

Say you have LevelA which shows dates and LevelB which is applicable for the relevant date values.

Make LevelA depends on LevelB in the Cube.

Then you can place a LevelB filter on the widget in hidden mode with some default value, which is relevant for desired values in LevelA and you'll see in LevelA filter only the desired values on this widget.

Evgeny Shvarov · Nov 23, 2016 go to post

Yes.

Finally calls:

d $System.OBJ.Export("Sample.*.cls","sample1.xml")

and

d $System.OBJ.ExportPackage("Sample","sample2.xml")

produce equal files of Sample package export in "xml" format.

Evgeny Shvarov · Nov 22, 2016 go to post

What the terminal do you mean? I believe there are plenty of terminal apps with this feature, e.g. this one.

Or do you want to log only Caché terminal sessions? And store it on the server?

Evgeny Shvarov · Nov 21, 2016 go to post

Should the derived class be placed in %SYS? I would prefer the way to store the optional class in my Namespace or in %All if I want it be visible in all the namespaces. Unless my class will be erased with the next Caché update.

Evgeny Shvarov · Nov 21, 2016 go to post

What does $System.OBJ.ExportPackage() function do special which $System.OBJ.Export() doesn't?

Evgeny Shvarov · Nov 20, 2016 go to post

One detail regarding this. To export only classes (and not Globals and OBJ code) you should put it in the pattern:

w $System.OBJ.Export("Sample.*.CLS")

will export only the classes.

Evgeny Shvarov · Nov 20, 2016 go to post

This is cool! Moreover, this:

w $System.OBJ.Export("Package1.*,Package2.*","Solution.xml")

will export two your class packages into the one 'solution.xml'.

Evgeny Shvarov · Nov 20, 2016 go to post

Thanks, Dmitry! Tried with $System.OBJ.Export and was not successful.  Maybe makes sense to add "Export Package" functionality to general OBJ.Export too.