Who's On?

	Membership:
	Latest: Brady
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5274

	People Online:
	Visitors: 194
	Members: 1
	Total: 195

	Online Now:
	Orlando Gray

New Topics

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

Employee Group Criteria of Not Having UserField

4 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

Woozy

Veteran Member Send Private Message

Posts: 709

8/22/2012 8:07 PM

I need to create an Employee Group that has a number of criteria. One of the requirements is that an employee can be a member of the group if they DON'T have a specific UserField value.

For Example, something like:

Union=N
UserField "Vesting" = from 1 to 9
OR
Union=N
UserField "Vesting" {does not exist}

Is there a way to do this? Can I use *BLANK as the value or something?

Thanks!

Karen Ploof

Veteran Member Send Private Message

Posts: 118

8/22/2012 8:37 PM

Would this work?

Include: Union=N
Include: UserField "Vesting" = from 1 to 9

OR

Include: Union=N
Exclude: UserField "Vesting" = from 1 to 9

Woozy

Veteran Member Send Private Message

Posts: 709

8/22/2012 9:02 PM

Hi Karen,

Ahhh...that makes sense. The issue is that there may be other valid "Vesting" values above 9 - like 10, 27, 44, etc. - that aren't between 1 and 9 and that I would not want it to include. I suppose if I 'exclude' all the possible valid values for "Vesting", then that would be perfect! Something like this:

Include: Union=N
Include: UserField "Vesting" = from 1 to 9

OR

Include: Union=N
Exclude: UserField "Vesting" = from 0 to 999

I think that will work. I'll have to test to be sure. Thanks!

Dave Curtis

Veteran Member Send Private Message

Posts: 136

9/8/2012 1:23 PM

I would actually build one group that has criteria to include everyone with the values you want excluded from the group. Then use that group as criteria in your final group to exclude them. Because you may want to include anyone with no value in the user field, this may be your best method.

Woozy

Veteran Member Send Private Message

Posts: 709

9/10/2012 1:47 PM

Thanks Dave. That's another good option. I'll explore this as well.

Thanks! Kelly