Home > Forum > General > WEBCON Tables: BpsUsers & BpsUsersGroupRelations

WEBCON Tables: BpsUsers & BpsUsersGroupRelations
0

MVP

Hello everyone,

thank you very much so far for all your questions/comments which helped me a lot or inspired me at least.

Today, i have my own problem/question and maybe someone of you were struggling with it before.

I am working on a "BPS groups Managing Tool" and therefore wanted to use the WEBCON tables
BpsUsers & BpsUsersGroupRelations.

But actually both tables are returning nothing, when using "SELECT * ...".

Does anyone have an idea, what i am doing wrong ?
It's irritating, because the use of the table "Companies" is working.

Thanks in advance, Bjoern

MVP

Hello Bjoern,

there's probably a simple reason, you are looking at the BPS_Content database instead of the BPS_Config.
I'm not sure when there are "real" users in this table but BPS Groups are added to the BPSUsers table in the Config database. From there they are synchronized into all content databases using the default user tables:
CacheOrganizationStructure
CacheOrganizationStructureGroupRelations

Here's a little snippet to retrieve all users in the group 'dc_managers'

SELECT COS_DisplayName, COS_BpsID
FROM [dbo].[CacheOrganizationStructure] as users join
[dbo].CacheOrganizationStructureGroupRelations as relations
on users.COS_ID = relations.COSGR_UserID
where relations.COSGR_GroupID in (
SELECT COS_ID
FROM [dbo].[CacheOrganizationStructure]
where COS_BpsID like 'dc_managers'
)



Best regards,
Daniel

MVP
In reply to: Daniel Krüger (Cosmo Consult)

Hello Bjoern,

there's probably a simple reason, you are looking at the BPS_Content database instead of the BPS_Config.
I'm not sure when there are "real" users in this table but BPS Groups are added to the BPSUsers table in the Config database. From there they are synchronized into all content databases using the default user tables:
CacheOrganizationStructure
CacheOrganizationStructureGroupRelations

Here's a little snippet to retrieve all users in the group 'dc_managers'

SELECT COS_DisplayName, COS_BpsID
FROM [dbo].[CacheOrganizationStructure] as users join
[dbo].CacheOrganizationStructureGroupRelations as relations
on users.COS_ID = relations.COSGR_UserID
where relations.COSGR_GroupID in (
SELECT COS_ID
FROM [dbo].[CacheOrganizationStructure]
where COS_BpsID like 'dc_managers'
)



Best regards,
Daniel

Hello Daniel,

thank you very much / vielen Dank.

Perfect solution for my problem.
Now i can use some data tables to display the information and i also have built some "Global Business Rules".

Best regards,
Bjoern