Create a report using Owned By Group feature

Elizabeth McKinnon asked on August 28, 2017 19:09

I am trying to create a custom report that will list all pages owned by a certain group; however, in order to write the SQL query I need to know the Code Name for "Owned By Group" that is listed as page data on the General tab. I am having a lot of difficulty finding what that code name/field name is. Any help?

Thanks!

owner owned by group

Correct Answer

Brenden Kehren answered on August 28, 2017 19:58

Ahh you are correct. So the groups would have to be managed in the Groups application. The groups are in the community_group table and the group members are in community_groupmember. The ID you'd most likely reference would be from the group table called GroupID

1 votesVote for this answer Unmark Correct answer

Recent Answers

Brenden Kehren answered on August 28, 2017 19:27

The column name is NodeOwner. You'd then have to link that to the CMS_User table to get the owners name or other attributes.

0 votesVote for this answer Mark as a Correct answer

Elizabeth McKinnon answered on August 28, 2017 19:31

Awesome - I was playing with that field and only getting numbers as results. This makes a lot of sense.

0 votesVote for this answer Mark as a Correct answer

Elizabeth McKinnon answered on August 28, 2017 19:54

I believe it actually might be NodeGroupID to get the Owned by Group field. Do you know that name of the table that ID references in order to get the Display Name or Code Name for the group?

0 votesVote for this answer Mark as a Correct answer

Elizabeth McKinnon answered on August 28, 2017 20:27

This is awesome - thank you!

0 votesVote for this answer Mark as a Correct answer