Education & Training
Services & Support
to create and rate content, and to follow, bookmark, and share content with other members.
how to get list of projects based on group ID
Question asked by
on Oct 15, 2008
on Oct 23, 2008 by Dave
Show 0 Likes
hi,it might be simple query but I'm not sure how to retrieve list of projects that a group has access to. I can't find the relationship between Group ID from (CMN_SEC_GROUP) and OBS and the investmetns. any help is appreciated.thanks
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Oct 23, 2008 11:03 AM
Hi - I would NOT say that it is SIMPLE to get that relationship from the database! It is contained accross the CMN_SEC_GROUPS, CMN_SEC_ASSGND_RGHT tables but it is not obvious how the relationship works! Off hand I remember that it is CMN_SEC_GROUPS also contain groups of projects as well as the "security group" that you are analysing. I only managed to work out how this worked by watching what SQL was ran on the database when I used the "Full View" functionality against a project (then spending a lot of time looking at that SQL trying to work out what each bit wasdoing (its a UNION of 9 different SQL statements, only 1 of which you would be interested in!). Good luck! DavidMortonCapgemini
Show 0 Likes
Retrieving data ...
[COMMUNITY WEBCAST] - OAuth integration with IFTTT - June 19, 2018 @ 12 p.m. ET
MAY18 Published Tecdocs / Tech tips / Posts to Spectrum Community board
Show details for unresolved connections
JAVA Dynamic combo box