Hi Jian, Many thanks for warm Welcome.
The only reason I want all information is the documentation. We want to have information for all projects --> Group --> User in Group--> All User --> Authorization details and any other details which we can keep handy in excel document rather than referring from Official Product API. I will try out suggest RQL below ; will update you for any further update from my side. Meanwhile I came up with below ways .. http://connectingreddotscms.blogspot.in/2014/05/how-to-find-all-user-for-given-project.html http://connectingreddotscms.blogspot.in/2014/05/how-to-find-list-of-group-for-given.html Many Thanks. On Thursday, May 22, 2014 3:27:20 AM UTC+5:30, Jian Huang wrote: > > 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.
