Overall a nice idea.
the package still needs some polishing to convince

suggestion1:  fix issue to build clean docker
suggestion2:  re-enable Start+Stop message so uses see it was moving
suggestion3:  show which class you check , kind of work log
suggestion4:  also step into sub-packages e.g. not just rcc but also rcc.unittests. codeinspector could be a good start
sugesstion5: allow also MAC, INT, INC code to be checked 

I just can repeat my message from OEX review !

it would be great if the issues in building Docker container would be fixed.
so we can touch it and reduce frustration of evaluators first
Actually it is broken,  Issues pending since some days

• is there anywhere a working example using the template ?
• or a hint of how to apply it ?

Your code looks like a ClassQuery.   %Library.Query

This is not a Stored Procedure  :=>  a ClassMethod ...[SqlProc,SqlName=anyname]  

and everything happens inside this ClassMethod
you run is by CALL PROCEDURENAME

I use it since Caché 2014.* at least.
this just the latest documentation.
What's the purpose of the semicolon ?  SELECT Name,Home_State FROM Sample.Person   ;
for TEMP table see: https://docs.intersystems.com/iris20242/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_createtable#RSQL_createtable_desc_temp

Before collecting all pieces in the Stores Procedure
I'd suggest to test you queries isolated im SMP or from terminal in SQL shell

UNderstand a STORED PROCEDURE as a special case of a ClassMethod
using CREATE PRODURE .......LANGUAGE OBJECTSCRIPT
You can write it with all specials you need
see docs: https://docs.intersystems.com/iris20242/csp/docbook/Doc.View.cls?KEY=RSQL_createprocedure

 

Thanks! A great summary!

@Marykutty George 

there is one.

I just posted a cross namespace cross CLS, MAC; INT, INC search
https://community.intersystems.com/post/code-scanner

It's pretty fast just using COS and Globals.  No class.

Congrats:
I like your code example that demonstrates deep understanding of the DB concept.
 💪

From docs:

tformat = 1  >>> Express time in the form "hh:mm:ss" (24-hour clock).

W $ZTIME(338,1,)
00:05:38

W $ZTIME(338+43200,1)
12:05:38

My guess: You look for this

​​​​​​​W $tr($ZTIME(338,3),"AM")
12:05:38

set time="2023-09-28T20:35:41Z"
write $TRANSLATE(tine,"-:TZ")

20230928203541

Do you look for a kind of LOGGING ?

👍💪