Flexible Query to find usergroup rights

[Former Member]

Hi All,

I need to see in the Hybris what all userrights are associated to any usergroup for any item type using flexible query.

When I am using query select * from {userGroup}, it is not giving any userright deatils.

Can you please help.

[geffchang]

You can try this script to export all UAC:

# ---- Extension: core ---- Type: UserRight ----
"#% impex.setTargetFile( ""UserRight.csv"" , true, 0, 0 );"
#SPECIAL CASE: Type UserRight will be exported with special logic (without header definition), see https://wiki.hybris.com/x/PIFvAg
"#% impex.exportItems( ""UserRight"" , false );"

I'm not sure if you can filter it to export a specific usergroup only. But, it's a good workaround for now.

Reference: https://launchpad.support.sap.com/#/notes/0002384816