Re: query against the user form group list field

2011-04-03 Thread Rick Phillips 

Thad,

Thanks, what actually worked was:
('Group List' = ;20213;2;) OR ('Group List' = ;2;20213;)

Rick

On 4/1/2011 3:40 PM, Thad Esser wrote:

**
Rick,
You say ONLY those two groups, so that means the group list could only 
be one of two things:

('Group List' = 20213;2;) OR ('Group List' = 2;20213;)

Thad
On Fri, Apr 1, 2011 at 11:53 AM, Rick Phillips r...@netfirst.com 
mailto:r...@netfirst.com wrote:


Happy Friday!

I would like to search for all User form records where the group
list is ONLY Service Request User and General Access.

Service Request User  group id = 20213
General Access group id = 2

I'm having problems with the advanced query.  Can anyone help?

Thanks,

Rick

ARS 7.6.03
SQL 2005


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org/
attend wwrug11 www.wwrug.com http://www.wwrug.com/ ARSList:
Where the Answers Are


_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

Re: query against the user form group list field

2011-04-01 Thread Andrew C Goodall 
'Group List' LIKE %20213% OR 'Group List' LIKE %2%

Also - try searching search permission groups instead of going against
user form.

Regards,
 
Andrew Goodall
 
Software Engineer | Development Services |  jcpenney . jcp.com  |
972.431.1518

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Phillips
Sent: Friday, April 01, 2011 1:54 PM
To: arslist@ARSLIST.ORG
Subject: query against the user form group list field

Happy Friday!

I would like to search for all User form records where the group list is

ONLY Service Request User and General Access.

Service Request User  group id = 20213
General Access group id = 2

I'm having problems with the advanced query.  Can anyone help?

Thanks,

Rick

ARS 7.6.03
SQL 2005


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged 
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any 
attachments is strictly prohibited.  If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

Re: query against the user form group list field

2011-04-01 Thread Thad Esser 
Rick,

You say ONLY those two groups, so that means the group list could only be
one of two things:
('Group List' = 20213;2;) OR ('Group List' = 2;20213;)

Thad

On Fri, Apr 1, 2011 at 11:53 AM, Rick Phillips r...@netfirst.com wrote:

 Happy Friday!

 I would like to search for all User form records where the group list is
 ONLY Service Request User and General Access.

 Service Request User  group id = 20213
 General Access group id = 2

 I'm having problems with the advanced query.  Can anyone help?

 Thanks,

 Rick

 ARS 7.6.03
 SQL 2005


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are