Find table's relation

[dianamp]

• deleted -

[ngegw]

hello:

I need to find the table that relates the groups to the users who belong to
this group.
the table egw_accounts list in the field account_lid the names of groups
and the names of users, and the field account_id contains the code of users
or groups, but what table relates these fields?

egw_acl, but why?
In almost every case, you’re better off using the API to get the
information you want.

---

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[dianamp]

• deleted -

[dianamp]

• deleted -

[Leithoff_Klaus]

You may use the Groupfilter in Admin->User Accounts.
Or:
select * from egw_accounts where account_id in (SELECT acl_account FROM
egw_acl where acl_appname=‘phpgw_group’ and acl_location = (select
account_id*-1 from egw_accounts where account_lid=‘YOUR-PRECIOUS-GROUP’ and
account_type=‘g’)) and account_type=‘u’ ;