New post
AllAccepted answers
Alexander Koblov · Jun 13, 2016

Hi Randy.

FILTER option in SETTINGS references "Allowed Default Values for Filters" section of doc
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

You can specify set of members as follows:

"{&[keyval1],&[keyval2],&[keyval3]}"

Then you need to URL encode this value:
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

Particularly by replacing & with %26 and , with %2C

For example, if I want to pass to "Basic Dashboard Demo" several values for Home Zip Code filter I need to create following string:

&SETTINGS=FILTER:[HomeD].[H1].[ZIP].{&[32006],&[32007]}

And then URL encode it to

&SETTINGS=FILTER:[HomeD].[H1].[ZIP].{%26[32006]%2C%26[32007]}
Alexander Koblov · Jun 8, 2016

Hi Blaise.

Does following query looks like what you need?

With Member Measures.[RunningTotal] As 
     'AGGREGATE(%TIMERANGE(DateOfSale.[Actual].[MonthSold].&[201101],DateOfSale.CurrentMember),
                MEASURES.[Amount Sold])',FORMAT_STRING='$#,#.#' 
SELECT {Measures.[Amount Sold],Measures.[RunningTotal]} ON 0,  
        [DateOfSale].[Actual].YearSold.&[2016].CHILDREN ON 1 
FROM HOLEFOODS

It prints two columns -- Revenue in current month and Total revenue from 2011-01 up to current month. Rows are months of 2016 year.

Alexander Koblov · Jun 7, 2016

Hi Paul.

Compact view is great. With it I can see sixteen topics on one screen instead of four.

What I would like to see is links instead of ajax buttons.

For example, I want to bookmark compact view of unanswered posts.

I've tried linking to https://community.intersystems.com/?filter=unanswered, but that is just a JSON content.

Alexander Koblov · May 23, 2016

Thank you Jose-Tomas.

As I understand (please see last three paragraphs of "Cyrillic4, Cyrillic3, and umlauts" section), Spanish language has some specific collation rules and satisfying these rules require more general (and complex) algorithm than sorting two strings based on individual character codes. That is why Spanish collations are slower then Caché Standard.
https://en.wikipedia.org/wiki/Alphabetical_order#Language-specific_conve...

The more processing you application does besides looping with $Order/$Query and inserting data into global the less impact has collation performance. Running ^%SYS.MONLBL with globals/locals with different collation settings should give you more accurate performance data.

Alexander Koblov · May 16, 2016

As far as I know it is not possible to switch it on.

You might find function DESCENDANTS (http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...) helpful.

For time dimension, all members of the level are generated and available to queries that show empty. This means

SELECT DESCENDANTS([DateOfSale].[YearSold].&[2015],DateOfSale.DaySold) ON 1 FROM HoleFoods

will show all days from 2015 on rows, whether there are facts recorded for those days or not.

Alexander Koblov · Apr 21, 2016

SQL Adapter does some metadata caching.

See, for example, doc for method EnsLib.SQL.Common:ExecuteProcedure
http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...

"Appending a '#' to the pIO argument (or passing only '#') prevents the adapter from using cached DescribeColumns() results for the procedure call output, forcing a fresh call to ODBC DescribeColumns() every time the stored procedure is invoked. This can be necessary if the procedure is capable of returning different sequences of result types from consecutive invocations"

I'm not sure if this is what happened in this case, though.

Alexander Koblov · Mar 29, 2016

By default %ToJSON method prints empty properties.

If you pass pFormat without "e" flags (that is passed by default), then empty properties are skipped:

USER>set p = ##class(%ZEN.proxyObject).%New()

USER>set p.a = 1

USER>set p.b = 2

USER>do p.%ToJSON()
{
        "a":1,
        "b":2
}
USER>set p.b = ""

USER>do p.%ToJSON()
{
        "a":1,
        "b":""
}
USER>do p.%ToJSON(,"alotw")
{
        "a":1
}

I encourage you to use Caché 2016.1 with native JSON support. Don't start with %ZEN.proxyObject.
See great article by Stefan Wittman about JSON support in 2016.1:
https://community.intersystems.com/post/introducing-new-json-capabilitie...