Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 29 JUL 2022 05:56:42PM Barry Stevens wrote:

OI9.4

Does anyone have a rough report they are willing to share that list all SPROCS and WINS that were modified since an inputted date (and account) showing:

Account

type

entity Name

date/time modified

size


At 01 AUG 2022 08:29AM Andrew McAuley wrote:

I would say something like

run rlist "LIST SYSREPOS WITH UPDATED GE '01 JUL 2022 01:00:00' AND WITH APPID = 'SYSPROG' AND WITH TYPEID = 'STPROC' 'OIWIN' ENTITYID UPDATED",1

But a quick test fails the date check.

The Sprezzatura Group

The Sprezzatura Blog

World leaders in all things RevSoft


At 01 AUG 2022 05:49PM Barry Stevens wrote:

I would say something like

run rlist "LIST SYSREPOS WITH UPDATED GE '01 JUL 2022 01:00:00' AND WITH APPID = 'SYSPROG' AND WITH TYPEID = 'STPROC' 'OIWIN' ENTITYID UPDATED",1

But a quick test fails the date check.

The Sprezzatura Group

The Sprezzatura Blog

World leaders in all things RevSoft

thank you

I came up with this:

LIST SYSREPOS APPID JUSTLEN 12 ENTITYID JUSTLEN 30 UPDATED BY TYPEID BY APPID BY ENTITYID WITH UPDATED GE '02 FEB 2022 00:01' AND WITHOUT TYPEID EQ 'approw' 'DBTABLE' 'dbcolumn' 'oiwinexe' 'stprocdbg' 'stprocexe' ID-SUPP BREAK-ON TYPEID (P

View this thread on the Works forum...

  • third_party_content/community/commentary/forums_works/bee0e75c8bccbb48ba686916798579d7.txt
  • Last modified: 2024/01/04 20:57
  • by 127.0.0.1