Thanks a lot Conny for bringing the end to my silly misery! Cheers, Naveen
Conny Martin wrote: > > Naveen, > > The Grouplist is stored internal as a list of groupids separated by a > semicolon (and sometimes an additional space) > > For example to search for all User belonging to group Administror your > advanced query should look like this > > ('Group List' like "1;%" or 'Group List' like "% 1;%" or 'Group List' like > "%;1;%") > > HTH > > Kind Regards Conny > > -----Ursprüngliche Nachricht----- > Von: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] Im Auftrag von NNMN > Gesendet: Freitag, 2. Juli 2010 12:31 > An: arslist@ARSLIST.ORG > Betreff: Curious Advanced Search > > Hi ARSers, > > Hi have a pretty silly and curious advanced search issue. This is a > "Advanced Search" i am trying on User Form. I am trying to give a search > on the basis of 'Group List'. I have,say 6 groups, Group1 to Group 6. > > I want to list out record of users belonging to Group List namely > 'Group1', 'Group2' and 'Group3' > > So I gave, > 1.'Group List' = ("Group1") OR 'Group List' = ("Group2") OR 'Group List' = > ("Group3"). It doesn't fetch me any record. > 2. I have been trying to search for records which has 'Group1' only also. > But its not giving me any records. > 3. Then I tried 'Group List' != ("Group1") whihc fetched me all the > records. > :S > > I am going crazy over here. Can anyone help me. > > Thank you > > Cheers, > Naveen > > ----- > With Warm Regards, > Naveen > -- > View this message in context: > http://old.nabble.com/Curious-Advanced-Search-tp29054806p29054806.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 > www.wwrug.com ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > ----- With Warm Regards, Naveen -- View this message in context: http://old.nabble.com/Curious-Advanced-Search-tp29054806p29055120.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"