User Answers

Hi Stella!

This is complicated cause the base class of a cube should contain the most granular records for the subject area being analyzed. Speaking with family terms children can analyze their dads in a cube but not vice versa.  That means want to analyze Kids - build the cube for Kids.

There is one trick though which lets you analyze Kids from Dads assuming if your Dad is not very fruitful ;) I mean this will work if your Dad has less then 1,000 kids)

Hi Vincent!

One of the working examples of DeepSee Dashboard filters promoted via URL you can check here in Developer Community

Hi Flavio!

Hope you are talking about Visual Studio Code, not Visual Studio.

There are at least two active approaches on coding and compiling ObjectScript from VSCode

Agree with @Eduard Lebedyuk answer, want to introduce another toolset:

1. Import ISC_DEV utility to a DEFAULT_INSTANCE say in a USER namespace and map the classes of the utility to %All.

2. Setup the workdir to export the code

YOURNAMESPACE> w ##class(dev.code).workdir("/path/to/your/wor

2. export code calling

Hi Thembelani!

For the new development with containers, the choice number one is InterSystems IRIS. You can try and build your solution with community edtion on AWS, Google or Azure

Also, the option which worked:

ClassMethod valuesCollectionToDisplay(val, delim) As %String
  quit ..AsJSON(val)

ClassMethod AsJSON(val) As %String
  set res = []
  set ptr = 0
  while $LISTNEXT(val, ptr, el) {
    do res.%Push(el)
  quit res.%ToJSON()

And the SQL call:

Select %EXTERNAL(values) values from data