Pls. don't forget to mark your question as "answered" on Developer Community, please click the checkmark alongside the answer you (as author of the question) accept
SELECT *
FROM
(SELECTTOP ALL
sslog.userRowid,
sslog.CreateDate,
sslog.CreateTime,
Sslog.SSUSR,
sslog.Terminal,
ssuser.Initials,
ssuser.USName
FROM SUser_Log sslog
LEFTJOIN DHC_SSuser ssuser ON (Sslog.SSUSR = ssuser.userRowid
OR sslog.ssusr = ssuser.Initials
OR sslog.ssusr = ssuser.USName)
WHERE ssuser.USName ['admin'ORDERBY sslog.CreateDate DESC)
WHERE %VID> 5
Alexey, - The final size after some design optimizations was 175 GB DataGlobals + 216 GB IndexGlobals ; separated for backup considerations (on 1 single drive )
- data analysis was all done with SQL + a bunch of "homemade" SQL Procedures / ClassMethods running specific subqueries.
Documentation is the art to express facts in a way the non insiders could understand. Engineers are quite often "unverbose" and "limited in verbal communication skills". In any language exept programing languages
BTW. your book made things clear to me that I assumed to know for many years.
Based on the results of %GSIZE you now compact those globals with most blocks and lowest packing. This generates free blocks that will be eliminated during GBLOCKCOPY.
Routine ^%FREECNT might help you to follow up your efforts Purpose: Displays the total amount of disk space within a volume group and the amount of free space.
go to post
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
go to post
not a problem of version
A subquery using ORDER requires a TOP clause
Change the query to
SELECT * FROM (SELECT TOP ALL sslog.userRowid, sslog.CreateDate, sslog.CreateTime, Sslog.SSUSR, sslog.Terminal, ssuser.Initials, ssuser.USName FROM SUser_Log sslog LEFT JOIN DHC_SSuser ssuser ON (Sslog.SSUSR = ssuser.userRowid OR sslog.ssusr = ssuser.Initials OR sslog.ssusr = ssuser.USName) WHERE ssuser.USName ['admin' ORDER BY sslog.CreateDate DESC) WHERE %VID> 5
go to post
HI Dave,
Great to meet you again on one of my favorite subjects.
go to post
To mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept.
go to post
You have 2 Options for LOCK
1) LOCK lockargument
either you succeed or you hang until you get success or forever
2) LOCK lockargument:timeout
timeout releases your attempt after the defined time
and signal by system variable $TEST if you were successful or not
so your code may have this structure
If $TEST {
write "successful Locked",!
} ELSE { write "attempt to Lock failed",! }
more on LOCK: http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
if failing you may want to identify your competitor using ^$LOCK
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
go to post
given the property you want to sort is unique and suitable as key for your array you may get the expected result.
set tSC=myArray.
go to post
To mark your question as "answered" on Developer Community, please click the checkmark alongside the answer you (as author of the question) accept.
go to post
You are welcome.
When I loaded the class first I was surprised too just to see 4 methods.
go to post
Amir,
I don't agree with you on %List
http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...
There's no annotation to be reserved or not to use it
go to post
Mike,
You are formally correct but data type %List just has no method LogicalToDisplay !
but:
- LogicalToOdbc
- LogicalToXSD
and reverse
it seems the implementer expected us to use $ListToString(...) and $ListFromString()
so far for consistency in object model support
go to post
Alexey,
- The final size after some design optimizations was
175 GB DataGlobals + 216 GB IndexGlobals ; separated for backup considerations (on 1 single drive )
- data analysis was all done with SQL + a bunch of "homemade" SQL Procedures / ClassMethods running specific subqueries.
go to post
Documentation is the art to express facts in a way the non insiders could understand.
Engineers are quite often "unverbose" and "limited in verbal communication skills".
In any language exept programing languages
BTW. your book made things clear to me that I assumed to know for many years.
BTW. I appreciate if you accept my answer
go to post
I'd try to have just 1 query with 3 parameters and switch them on/off as you need
SELECT ID FROM Table WHERE (Field1 %STARTSWITH :par1
AND ((0=:sw2) OR (Field2 = :par2))
AND ((0=:sw3) OR (Field3 = :par3))
Now using only par1 means (par1=whatever, sw2=0,sw3=0, par2="",par3="") so the 2nd + 3rd condition is switched off and par2,par3 ignored
2nd case: (par1=whatever, par2=something, sw2=1,sw3=1, par3="") so only 3rd condition is switched off par 3 ignored
3rd case: (par1=whatever, par2=something, par3=other, sw2=1,sw3=1) all conditions active
you see this could be extended easily
go to post
%Library.Char uses MAXLEN as size: LogicalToOdbc and LogicalToDisplay appending Blank until MAXLEN is reached
it's applied in
anyting else is inherited from %String
go to post
before launching your request in your check your %Net.HttpRequest object
property Https is obviously set.
property SSLConfiguration has to be
if the request fails in execution
property SSLError tells you what went wrong
more on %Net.HttpRequest here
http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...
go to post
It's not yet time for GBLOCKCOPY.
In namespace %SYS you should find a routine ^GCOMPACT
(at least according to docs http://docs.intersystems.com/documentation/cache/cache5docs/PDFS/GMSM.pdf)
Based on the results of %GSIZE you now compact those globals with most blocks and lowest packing.
This generates free blocks that will be eliminated during GBLOCKCOPY.
Routine ^%FREECNT might help you to follow up your efforts
Purpose: Displays the total amount of disk space within a volume group and the amount of free space.
HTH
go to post
Check win version against version supported by Caché first.
http://docs.intersystems.com/cache20141/csp/docbook/DocBook.UI.Page.cls?...
go to post
I was waiting for it.
And I missed this setup in other places.
go to post
So we are back to Documentation vs. Reality.
And another excellent example for the importance of this community.
go to post
develop on prod ?