Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

RD30 & PORTALROLE attrib

2 Replies

0 Subscribed to this topic

16 Subscribed to this forum

Sort:

Author

Messages

Greg Moeller

Veteran Member

Posts: 1498

MVP

New Poster

Engaged Reader

Avid Reader

3/23/2006 9:50 PM

We have about 5000 rd30 records. Most of which do not have the PORTALROLE attribute filled out.
Is there an easy way to identify the blank ones, and therefore create a LX995 job/file to fill JUST the ones that don't have something in them already?

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

3/23/2006 10:11 PM

You could do a quick Crystal report, joining WEBUSER TO LOMXVALUE on OBJ-ID for MATRIX-CAT=PORTALROLE, and hide ones that don't have a Blank/NULL value on the LOMXVALUE side of the JOIN.

You could also do something in SQL with SELECT ... MINUS ... along the same lines...

Alex Tsekhansky

Veteran Member

Posts: 92

3/24/2006 3:43 PM

I also recommend doing PORTALROLE per user category (if you have large number of users to be assigned for the same role) rather than doing individual LX95. See Lawson KB article on Required Content assignment.

Thanks.

Alex.