Seems to work. Please provide small standalone example, so that we can reproduce

C:\InterSystems\ENSEMBLE2017x2x2\bin>set AA=22

C:\InterSystems\ENSEMBLE2017x2x2\bin>echo %AA%
22

C:\InterSystems\ENSEMBLE2017x2x2\bin>cache -s ..\mgr

Узел: ru-akoblovW10VM, Экземпляр: ENSEMBLE2017X2X2

USER>w $system.Util.GetEnviron("AA")
22

If Caché is Unicode you can upgrade Caché to Ensemble:

Good idea in such cases -- enable Audit and audit events LoginFailure and Protect. Reproduce the problem and then check Audit log.

I understand that get data method only needs to return the Y-Axis values

Yes!

Do you think it is good to try and store values for x and y-Axes in the same data array?

No, keeping values in getChartData and labels for X axis in getAxisTime is fine.

You can use $system.OBJ.Export to export LUT document to file:

ENSDEMO>w $system.OBJ.Export("AlertTable.LUT","c:\temp\qq.lut")
 
Exporting to XML started on 08/30/2019 12:03:14
Exporting type : AlertTable.LUT
Export finished successfully.
1
ENSDEMO>w $system.OBJ.Load("c:\temp\qq.lut")
 
Load started on 08/30/2019 12:03:26
Loading file c:\temp\qq.lut as xml
Imported document: AlertTable.LUT
Load finished successfully.
1

If you have index.csp and it is specified as login page and you are seeing 404 error, try following:

a) Enable Audit b) Enable Protect event in Audit c) Reproduce the problem. e) Check Audit records if any Protect errors were logged

less quotes

I like usage of parameter, as it is computed once -- at compile time. And after you only fetch value in cycle.

You can also use $listfromstring via the same technique.

CASE statement expects expression after THEN. DESC or ASC are not expressions. That's why you are getting syntax error.

So you need to supply some expression, ordering by which would mean reverse ordering by FirstName.

I don't know how to do this.

I would do sorting on the client or use dynamic SQL to create the query. As below for example.

Important! Nowhere I concatenate parameters of the stored procedure with the query to avoid SQL injections. Only SortingField is concatenated after checking that it has approved value.

ClassMethod Search(
    Name As %String = "",
    SSN As %String = "",
    Title As %String = "",
    SortingField As %String = "",
    StartIndex As %String = "") As %Integer [ SqlName = ExternalUsersSearch, SqlProc ]
{
 set query = "select Name, Title, SSN from Sample.Employee WHERE 1=1 "
 kill args
 
 if Name'="" {
     set args($I(args)) = Name
     set query = query _ "AND Name like ? "
 }
 
 if SSN'="" {
     set args($I(args)) = SSN
     set query = query _ "AND SSN like ? "
 }
 
 if Title'="" {
     set args($I(args)) = Title
     set query = query _ "AND Title like ? "
 }
 
 set AllowedFieldsToOrderBy = $LB("Name", "SSN", "Title")
 if $ListFind(AllowedFieldsToOrderBy, SortingField) {
    set query = query _ " ORDER BY " _ SortingField
    
    if StartIndex = 1 {
        set query = query _ " DESC"
    } else {
        set query = query _ " ASC"
    }
 }

 set rs = ##class(%SQL.Statement).%ExecDirect(,query,args...)

 #dim %sqlcontext As %SQLProcContext
 if rs.%SQLCODE >=0 {
     do %sqlcontext.AddResultSet(rs)
 } else { // pass errors to the caller
     set %sqlcontext.%SQLCODE = rs.%SQLCODE
     set %sqlcontext.%Message = rs.%Message
 }
 quit 1
}

Return statement is

do %sqlcontext.AddResultSet(rs)

When you call this stored procedure it returns resultset

For example:

call CMT.ExternalUsersSearch('%in%',,,'Title')

If you call this stored procedure via ODBC / JDBC you need to add ReturnResultsets to the method definition: https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=ROBJ_method_returnresultsets

Well, it still works blinks!

No. You need to use Eclipse IDE Photon R with Atelier.

I also see this error for some tables. I don't know what's causing this.

I've googled it and looks like some error with ODBC Connections from Power BI.

Check if you have Windows-keys enabled in Terminal settings.

If yes -- this can handle Ctrl-C as "Copy to clipboard"

Not necessarily

 set CNT=10e7
 
 write "for test",!
 set z1 = $zh
 for i=1:1:CNT {
 }
 set z2=$zh-z1
 write "time: ",z2,!
 
 
 write "while test",!
 set z1 = $zh
 set i=1
 while i<=CNT {
	 set i = i+1
 }
 set z2=$zh-z1
 write "time: ",z2,!

Running this program:

USER>do ^test
for test
time: 2.017099
while test
time: 1.542252

Yes, first screenshot illustrates what I said.

CSPSystem tries access User.Login in USER database, but fails.

Give CSPSystem role that has resource protecting user database.

Close all connections from Web Gateway to IRIS.

Try again. It should work

Neerav,

relative cost is only useful when you compare different plans for the same query. By itself "relative cost" means nothing.

I agree