nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Report to show all groups a user belongs

Chukwudi_Awaibe

Pls I need a report that will show all groups that a user belongs including the user's base group

Find more posts tagged with

Comments

Tim_Hunter

This query only works on oracleselect level as depth,kuc.id,kuc.childid,g.id groupid,g.name groupnamefrom kuafchildren kuc,kuaf gwhere kuc.id = g.idstart with kuc.childid = %1connect by prior kuc.id = kuc.childidorder siblings by childidif you look around the forums you can find examples similar for mssql

Chukwudi_Awaibe

Thanks, We use oracle and it worked perfectly well.