Thank you for your answer!

Thank you for your answer! This video helped.

%Get Members For Filter class method. In particular restriction to show only 2500 members in filter list.

Any console with ability to display debug information. IRIS Terminal is too bulky to operate effichancy. I am searching for a simple ways to investigate what variables hold what and what return this or another method

Looks simple, but I'm still having trouble with it. First of all, do I have to be logged into Intersystems Servers in Intersystems Tools for debugging? Secondly, every time I start debugging I get an error.

What should I do about it? It prevents me from working.

/MDX2JSON/Test gives an adequate response yes
How can i retrieve a logical name of a cube?

Yes, exactly like your example

The WritePivotVariablesForCube upon debug however return proper response 

{

"children":[

{

"name":"Year",

"caption":"Year",

"defValue":2018,

"context":"literal",

"desc":""

}

]

}

It is very useful! At first it gave out "The web application does not exist." Then I create it manually and then the response was "Illegal web request".

This is something to start with! Thank you.

Hi! 

Thanks for your answer. I've read the docs through out couple times to find the explanation but did not find any. I'll try to express my self more crystal

Suppose i have some myUI app in my IRIS instance. This myUI using DeepSee REST API to get the data. I need to get track of any activity on that UI at any time (in general when a user requests the data)

What should i need as the audit source? 

myUI? Some endpoint from API? Some class executing by this endpoint?
Documentation says:
"Event Source*

The component of the InterSystems IRIS instance that is the source of the event. For InterSystems IRIS events, this is “%System” or “%Ensemble”. For user-defined events, the name can be any string that includes alphanumeric characters or punctuation, except for colons and commas; it can begin with any of these characters except for the percent sign. This can be up to 64 bytes."
Ok, what string? How any random string can be serve as audit source? Same for the audit type 
I get that the string represents my app or part of it, but how that will track actions from myUI?

Thanks for the answer. If i understand correctly, this specific line should be place inside REST API for make audit to work? So, if i don't have any access to the REST API code the desired audit is not possible?

Thank you so much. You were very helpful.

The code piece that reading file 
 

If '$IsObject(pStream) {
            Set tFilename = pStream
            Set pStream = ##class(%IO.FileStream).%New()
            Do pStream.Open(tFilename,,pTimeout,"UTF-8", .tStatus)
            If$$$ISERR(tStatus) Quit
        }

As far as I understand from your answer, I have no choice but to apply some hacks to my data. This is unfortunate. I was thinking about using a hash too. I think I will do that.

Thanks for the reply.
CASCADE means that the data is deleted also in parent and child tables, RESTRICT means that only parent data is deleted. Changing the default RESTRICT does nothing, the data is still there
Any other option?

UPD: i've managed to delete data with

UPDATE TABLE table SET column = NULL

But issue is still open, why %DELDATA do nothing

Thanks for the clarification.

Now that you've answered, I feel embarrassed by how easy it was to set the default data source.

But I must say, the error message is a bit confusing. If there's no way to set a default key:value pair from a termlist, why is the default editor available?

Thanks for the information, but I would like to see more comprehensive documentation. Such feature rich application and no solid docs anywhere. I think i would create an idea on Ideas Portal about it.

If it is pure ObjectScript how to write IF ELSE statement in %expression for example? Or can i use RETURN stetement? 

There are situations when you need to return a specific value. The Range expression doesn't work, for example, when you need to determine the display value for Null.

So there's only one way
IF 'value {return "Value is False"} else {return "Value is True"}
But this is wont work
I can still define a class method inside the cube and reference it from within, for example, %cube.CustomLogicClass(%source.DBValue), but that seems redundant. It leaves my cube looking cluttered with simple functions containing only if-else logic.

Thanks for the reply!
As i said, the query works perfectly fine when executed normaly (without $$$ tokens). The data is correct
I should add some details then

When I compare dates in the WHERE clause, I convert them to INTs, just to make sure all the data is consistent. I also do a slightly more complex comparison. I've omitted the details because they're not relevant to my case

anotherDateField BETWEEN CAST(TO_CHAR(dateFieldOne, 'YYYYMM') as int) and CAST(TO_CHAR(dateFieldTwo, 'YYYYMM') as int)

Next, the date format is %TimeStamp, and it's very common in my data. I work with it every day, and every time function you can think of works without a problem
So the time data works fine, the outer WHERE clause doesn't catch up because of $$$RESTRICT in the inner section but without it the listing would not work at all