system
#1
I am trying to write a query to get all of the users for a particular group.
If I have the group’s ID (an easy enough query), how do I query the database from there?
I’ve tried looking up SQL syntax on arrays, I’ve tryed *=, I’ve tried SI_USERGROUPS in (groupID) I’ve tried groupID in SI_USERGROUPS
Nothing. Can anyone help?
Bolandb (BOB member since 2010-06-08)
system
#2
hi, see this topic for a list of CMC queries including users of a group.
Also check out the attachment mentioned in the reply
rgds
agulland (BOB member since 2004-03-17)
system
#3
Thank you so much. This is amazing.
Bolandb (BOB member since 2010-06-08)
system
#4
By accessing the URL for BOXIR3, i am not getting the Link for Query Builder. Can anyone plz tell me the URL path to access Query Builder in BOXIR3.
SRR (BOB member since 2009-01-20)
system
#6
Thanks for the Quick reply… It works…!!!
SRR (BOB member since 2009-01-20)