meaning of: pa_m2m_targets_users

[Detlef Biederma]

Hello 

my understanding:

pa_targets.owner - empty  ->  global target   (tab: "Users" (pa_m2m_targets_users) is visible)

pa_targets.owner - set  ->  personal target    (tab: "Users" (pa_m2m_targets_users) is not visible)

I have done some tests:
pa_targets.owner - empty  ->   add entries to  tab: "Users" (pa_m2m_targets_users)
result:
- the target is still a global target  (seen by users added and not added to the list)
- the user in list can not change the target value, if they do not have the "pa_target_admin" role
- any user with the "pa_target_admin" role can change the target value

My question: What changed for the user added to "pa_m2m_targets_users" ?

Sincerely Detlef Biedermann

[Detlef Biederma]

I found out that  responible users are saved under  "pa_targets.responsible_users".  they can edit targets. 

Still open for what "pa_m2m_targets_users"  is used?!

[DLHill]

I think you may have answered the question already regarding what that table is used for.

There's not a many to many relationship for a personal target (owner field covers that) but there are many users on many global targets so addition of a user to the m2m table means they got assigned a global target (owner is empty so the indicator is used to work out who should have this target).