Request to Join Group

[Captain_Gossip]

If a user requests to join a group, they can fill out a reason. Group leader can view this reason and accept/deny user for the usergroup.

My question: afterwards, can we still find this info somewhere? So if a user misconduct in a forum, can we have a look at the reason he stated when applying to join the group?

Thanks!

[Steve Machol]

Good question. I believe you can do this with this query:

SELECT reason FROM usergrouprequest WHERE userid='xxx';

...with 'xxx' being the userid of this member.

[Captain_Gossip]

That query returns the people who still need to be approved...

[Steve Machol]

Hmmm...try this:

SELECT * FROM usergrouprequest WHERE userid='xxx';

Then view the reason field.

[Captain_Gossip]

Thanks, that worked!