omit the server name and just use "" for your local server
%SYS>set db=##class(Config.Databases).DatabasesByServer("",.dbList)
%SYS>zw
db=1
dbList="DEMO,IRISSYS,CACHE,ECODE,EDATA,ENSLIB,IRISAUDIT,IRISLIB,IRISLOCALDATA,IRISTEMP,USER"
%SYS>
BIG CONGRATULATIONS.
https://docs.intersystems.com/iris20211/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_fzdate
write $zd(+$h,4,,4)s max=0,glb="^MyGlobal" f s glb=$q(@glb) q:glb="" s:$ql(glb)>max max=$ql(glb)
zw maxSMP > SQL
select a table
then Action > Tune table
Beginners see the query plan first and then create the index on items in WHERE clause.
Experts mostly reverse the sequence.
for questions 1.1
You should use static IP addresses. hope this description helps
https://pimylifeup.com/raspberry-pi-static-ip-address/
#1 add an extent Index
#2 try https://community.intersystems.com/post/repairing-your-index
SSO account can be shared for WRC (if enabled), DC, OEX, Learnig, ..
Global Masters is an external application that can make use of SSO
but has its own independent accounts as well.
did you try
.png)
ZN "%SYS"to return ? or switching to a different Namespace and back to %SYS ?
@Kurro Lopez
Show me yours and I show you mine 
private on discord.
for details see Class %ZEN.Component.dateText
setting format:
Property format As %ZEN.Datatype.string(MAXLEN = 3, VALUELIST = ",MDY,DMY,YMD", ZENEXPRESSION = 1)
you have exactly 3 formats or ""
Your guess on values is correct and documented:
/// The value of this control is always in the canonical form: YYYY-MM-DD
As this is one of the oldest components of ZEN your only chance to achieve
your way of operation is to create your own version inheriting from
Class %ZEN.Component.dateText and overloading the parts you want to change
OK! you talk about a local variable array
If you don't pass the local array with the JOB command it is not defined in the new JOB
because it is LOCAL
except if you run the 2 SET commands of your example also in the JOBbed routine.
also your WRITE command will fail if you don't specify some output device.
since by definition a background JOB doesn't have foreground output.
I just found Facebook link is operational again in GM.
I just had to "associate" in personal settings and it worked with no other input.
ping @Olga Zavrazhnova
@Lewis Houlden
If you stop a process from the Management portal you have the option to launch an <RESJOB> error in $ZE
this allows you to clean out the message that triggered your process.
If not, the triggering message remains unprocessed in the queue.
Which results in the retry you see.
reported to GM Master already.
@Olga Zavrazhnova
You might be able to achieve the first part of your description by some tricky JOIN constructs.
Just access to a non-existing column will fail at generating the Query.
Cascading might be easier (also for maintenance) by filling a TempTable over several cycles
and so assemble the final result.
I would suggest to create a ClassMethod projected to SQL as Stored Procedure.
then instead of the trick with the switch you just provide the parameters that you really have
to rephrase your problem:
- You look for a way to switch on/off column 1
so you need a switch: >>> new parameter
and use it like this:
... WHERE (0=? OR column1=?) AND column2=?if your first param is 0 then 2nd param (for column1) is irrelevant
if your first param is 1 then 2nd param (for column1) is effective
so execute(0,a,b) uses any value of column1
whille execute(1,a,b) filters column1 and column2
the maxSCALE = 18
see Doc on $NORMALIZE()
used in ##class/%Library.Numeric).Normalize()
ClassMethod Normalize(%val As %RawString) As %Numeric [ CodeMode = generator, ServerOnly = 1 ]
{
s %codemode=$$$cMETHCODEMODEEXPRESSION
s %code="$select($zu(115,13)&&(%val=$c(0)):"""",1:$normalize($decimal(%val),"_+%parameter("SCALE")_"))"
QUIT $$$OK
}
But it is no problem to clone this data tape and write a private one
ah!
So you don't use the Caché provided Default Link generator in SMP !!!
So you get the default of datatype class %Numeric (=> SCALE=2)
It might be enough to add :
$SELECT(columntype["Numeric":"%Numeric (SCALE=4)",1:columntype) It's all under your own control.
And therefore you should edit the generated class and not touch any defaults.
I assume it's the Link Generator that uses SCALE=2 if Oracle doesn't provide anything.
if you link a table from another DB (Oracle) there is a related class generated in Caché.
In this class a property related to your column with type %Numeric.
all you have to do is to add (SCALE=4) or whatever scale you need.
this data type existed already in Caché 5.* about 20 years back.
The system-wide control is stored in Cache.cpf file.
You can change ist from SMP in System > Configuration > System-defined DDL Mappings
though I would not recommend to do it on a system-wide scope
as this affects ALL mapping between Caché Objects and SQL
default SCALE=2 for %Library.Numeric (since ever)
https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic.cls?LIBRARY=%25SYS&CLASSNAME=%25Library.Numeric
it makes sense also to display what you group
SELECT count(*),substr(TimeLogged,1,7), ConfigName
FROM Ens_Util.Log
where TimeLogged %STARTSWITH '2021-07'
and ConfigName = 'operation_Name'
group by substr(TimeLogged,1,7)@Flávio Lúcio Naves Júnior
usr= dcmember works. allow insecure port
I see we share the same approach. Thanks for the confirmation.
As an isolated developer, I couldn't identify any significant improvement over my actual environment.
Though this looks quite impressive I have 2 concerns
#1.png)
#2.png)
Still 23 days to go free.
I just found a note on Syntax Highlighting.
Though I have no idea how this is related to this new editor ? Ping @Dmitry Maslennikov ?
https://docs.github.com/en/github/writing-on-github/working-with-advanced-formatting/creating-and-highlighting-code-blocks#syntax-highlighting
I'll stay with the old one
It seems in github.com .gitattributes are honored and code coloring works OK
while the NEW editor in github.dev ignores it. 
And I found it boring slow in startup