CAS only knows the authenticated username. If you are only concerned with attribute resolution after authentication, isn't that just a matter of adding a join to your attribute query?
-dirk On Sat, Oct 13, 2018 at 12:44 AM Fahmi L. Ramdhani < [email protected]> wrote: > Hi, > > I use JDBC as database authentication. I want to retrieve user attributes > based on ID (int, not uid login ex: [email protected]), after logging in > with [email protected], I hope CAS takes the user id (int). > > With the following relationships: > > *users (table)* > - id (PK, int) > - email > - password > > > id email password > ============================================== > *1* [email protected] ************** > *2* [email protected] ************** > > > *user_attributes** (table)* > - id (PK, int) > - user_id (FK, int) > - attr_name > - attr_value > > id user_id attr_name attr_value > ============================================== > 1 *1* first_name One > 2 *1* last_name Example > 3 *2* first_name One > 4 *2* last_name Example > > How to solve this? Thank you. > > -- > - Website: https://apereo.github.io/cas > - Gitter Chatroom: https://gitter.im/apereo/cas > - List Guidelines: https://goo.gl/1VRrw7 > - Contributions: https://goo.gl/mh7qDG > --- > You received this message because you are subscribed to the Google Groups > "CAS Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/a/apereo.org/d/msgid/cas-user/0f66f6e7-fa85-4105-a4ca-db83d907f49d%40apereo.org > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/0f66f6e7-fa85-4105-a4ca-db83d907f49d%40apereo.org?utm_medium=email&utm_source=footer> > . > -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAJ%3D0EZz-UzEYgjmZXMaYcp-31uQizcx8m6j-6k_nDy3MuFrKUg%40mail.gmail.com.
