Who's On?

	Membership:
	Latest: Emily
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5308

	People Online:
	Visitors: 167
	Members: 0
	Total: 167

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

RD30 & PORTALROLE attrib

2 Replies

0 Subscribed to this topic

14 Subscribed to this forum

Sort:

Author

Messages

Greg Moeller

Veteran Member

Posts: 1498

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: 3359

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.