Question
Arto Alatalo · Mar 10

Alternatives to View Journal

#Journaling #Management Portal #Caché

Is View Journal of Cache Management Portal the only way to search in Cache journals? I need a way to define several search conditions and Portal often breaks on http timeout.

0
0 235
Discussion (6)3
Log in or sign up to continue
Robert Cemper · Mar 10

in namespace %SYS you may run DO ^JRNDUMP  from the terminal prompt

1 0
Arto Alatalo · Mar 10

Hi Robert,

JRNDUMP does solve the timeout issue, but searching with it looks really challenging.

0 0
Nick Hershberger · Mar 10

There's documentation and examples for searching using JRNDUMP here. Using SELECT^JRNDUMP is very handy to find a specific address(es) which you can then jump straight to in the Management Portal to get a view of what else was going on around that particular entry.

1 0
Arto Alatalo · Mar 10

Oh, thank you, that looks promisingyes

0 0
Hans-Peter Iten · Mar 14

You could also use the class  %SYS.Journal.File

Example:
Set JournalFile = ##class(%SYS.Journal.File).%OpenId(EXISTING_JOURNAL_FILE)
Set JournalRecord = JournalFile.FirstRecordGet()
While (JournalRecord '= "") {
  Here you can program your search criteria example:
  If JournalRecord.%IsA("%SYS.Journal.SetKillRecord") {
   insert your code
}
}

Check documentation for further hints.
 

1 0
Warlin Garcia · Mar 14

Journal files are also exposed as SQL (readonly) tables. In theory, you could write SQL statements to search/filter. 

0 0