Hi Pradeep, welcome to the forum.
Please feel free to ask any questions. >From your posts, it seems like you are trying to get a list of project guids, then for each project, get a list of user groups and users. Is that right? Is there a reason why you are trying to get the information from the database rather than via official product API? I wrote a little tool for the product, once installed, you can send RQL (the official project language) to query various information. RQLConsole http://simplyreddot.blogspot.com/2012/02/rqlconsole.html To get the list of projects and project guids, run this code <ADMINISTRATION> <PROJECTS action="list"/> </ADMINISTRATION> Then for each project, you can do <ADMINISTRATION> <PROJECT guid="[!guid_project!]"> <GROUPS action="list"/> <USERS action="list"/> </PROJECT> </ADMINISTRATION> . . . or <PROJECT guid="[!guid_project!]"> <GROUPS action="list"/> <USERS action="list"/> </PROJECT> . . . just replace [!guid_project!] with guid of the project On Wednesday, May 21, 2014 6:40:43 AM UTC-4, Pradeep Shukla wrote: > > Hi All , > > I know by using "Administer User and Groups" I can find the list of user > for given Project. > > But I need to perform this steps for certain set of Projects "Say 100 > projects" So I was wondering if I can find some mapping in database from > where i can find the list of users for given projects. > > Many Thanks. > Pradeep > -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/reddot-cms-users. For more options, visit https://groups.google.com/d/optout.
