ca.portal.admin

JREPORTS for a specific record name???

Discussion created by ca.portal.admin on Nov 4, 2010
Latest reply on Nov 4, 2010 by ca.portal.admin
Hello All:



Anybody have a sample of a JREPORT where they pull off updates to a
specific record name?



For example I want to see all OPEN-ORDER-HDR records modified or stored
between 3:10 AM and 5:10 AM this Morning.



Any samples would be greatly appreciated.



William M. Allen, Jr.

ARCH Consulting Associates, Ltd.

(704) 641-0296
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: JREPORTS for a specific record name???
"Bill,

You can't use record names in the JREPORTs. You use USER-REC-ID

From old code (I use JA now):

SELECT WHEN TYPE EQ ('BGIN' 'BFOR' 'AFTR' 'COMT' 'ENDJ' 'ABRT') =20
* AND TRANSACT-ID EQ ( 7879 ) =20
* AND RUN-UNIT-ID EQ ( 2230229 2268916 3053043 3074405 ) =20
* AND ( RUN-UNIT-ID EQ 37479 OR RUN-UNIT-ID EQ 37473 ) =20
* AND USER-REC-ID EQ ( 5028 5030 5044 ) =20

Also, check out WK-DTETI from JREPORT 008.


Dick=20
Richard Pierce=20
(617) 973-8911=20
richard.pierce@state.ma.us=20

Outcomes