BusinessObjects Board

Query Builder in 3.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)

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 :uk: (BOB member since 2004-03-17)

Thank you so much. This is amazing.


Bolandb (BOB member since 2010-06-08)

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)

http://myserver:8080/AdminTools/querybuilder/ie.jsp

Thanks for the Quick reply… It works…!!!


SRR (BOB member since 2009-01-20)