mapping "User Groups" to "Content Folders"

Jose Cabrera shared this question 4 months ago
Answered

hi,


I'd like to know if there is a way to identify the "User Groups" within "Content Folders". I looked specially into yellowfin_config."ContentManagement" and yellowfin_config."AccessGroup" but there is no relationship between the two.


Thanks.

Comments (3)

photo
1

Hi Jose,

If you mean the correlation between user groups and content folders in the configuration database, it involves more than a couple of tables, but the pairing takes place in the accesslevel table.

My example below shows that the content folder with entityid 10196 is matched up with accessgroupid 11950:

/0038934d22b2e646c2ecc3832e70920c

I hope that helps!

Kind regards,

Chris

photo
1

Hi Chris,

This's what I was looking for. Thanks for pointing me to the "AccessLevel" table. I joined that table to the "ContentManagement" table on "EntityId" = "ContentManagementId".

thank you again.

photo
1

Hi Jose,

That's great to hear! No worries. I'll move this to Answered but let me know if there's anything else you want to discuss on this topic.

Kind regards,

Chris