How to find the Users for Given Project from SQL Database

[Pradeep Shukla]

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 

[Jian Huang]

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

[Pradeep Shukla]

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.

[Pradeep Shukla]

Hi Jian,

I have installed the RQL Console Plug and tried the below query ..

<PROJECT guid="[6C8A3094541911D4BDAB004005312B7C]">

<GROUPS action="list"/>

<USERS action="list"/>

</PROJECT>

But the Output came is

[object Object]

How to get the list?

Any further help will be appreciated.

Many thanks.

[Jian Huang]

Without the [ ]

[Pradeep Shukla]

Hj Jian,

 I have all ready tried with out the [ ] But no Luck.

Any further ways to investigate further.

Many Thanks.

Pradeep Shukla 

91 97699 20828

Without the [ ]

--
You received this message because you are subscribed to a topic in the Google Groups "RedDot CMS Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/reddot-cms-users/vZmzfUfupac/unsubscribe.
To unsubscribe from this group and all its topics, send an email to reddot-cms-use...@googlegroups.com.
To post to this group, send email to reddot-c...@googlegroups.com.
Visit this group at http://groups.google.com/group/reddot-cms-users.
For more options, visit https://groups.google.com/d/optout.

[Jian Huang]

My apologies, the issue has been identified.

It is a bug for RQLConsole in 7.x to 10.x.

It has now been fixed.  Please download latest version and replace existing.

-Jian