CiviCRM Community Forums (archive)

Hi

I have a custom profile that certain users of type 'a' can use to create, edit and search for contacts.
I would like to limit the results in the search listings, so it only comes up with contacts that have the same relationship as the current logged in user.

How do I do that ?

Extra info: I have already made a little module that uses the hooks civicrm_buildForm and civicrm_postProcess - I'm using it to limit access to the profile to users of type 'a' and to give new contacs created with the profile the same relationship as the current logged-in user (the user using the profile) - it works great, but I'm a bit stuck with limiting the listings. I've already set the "Limit listings to a specific group" in the advanced profile settings - that is not the "solution" I'm looking for - relationship is the key for me here.
I've also made another module using civicrm_aclWhereClause to limit searches and contact forms to only display contacts with the same relationship as the current user. But this doesn't work for profiles as they ignore acl's ( ?right? - it doesn't work for me anyways), and with the aclWhereClause I have access to the where clause and wheretables - can I get that with  civicrm_buildForm or civicrm_postProcess ?

Thanks in advance for any help and/or pointers in the right direction

PS: Bonus question: I would like to share all the code from my modules, customizations etc. - where's the best place to do that ? here in the forums ?

Thanks Lobo.

I guess another hook is something that will come in a future release - in the meantime do you have any pointers to where I could start myself - can I make some sort of temporary hack that could do this ?

Why do I need this? Well here is my case:
I have 200 schools (organisations) in civicrm, each one have between 100 and 1000 (on average 200) related students - that is students with a relationship "Student of" with contact a being the student and contact b being the school.
I have a group called "school coordinators", which are students who need to be able to edit the other students (contacts) from their own school. I could make a group for each school, and a profile for each school that limit listings to contacts from the school group, and then make ACL's for each school coordinator, so they can only edit the contacts from their own school. For me that would mean making 200 school groups, 200 profiles and close to a thousand ACL's (there are between 2 and 10 coordinators on each school). Then I should cutomize each profile to only allow the coordinators from a school to use the profile for the school.
All in all a lot of circling/working around the real (and simple) problem: if you are coordinator you should only be able to see and edit contacs with the same relationship as yourself.

I believe this is a very common scenario:
an admin in an organisation needs to be able to administer the other people in the organisation.

If anyone have suggestions of how to do this simpler that described above please enlighten me

PS: I have already made it so the school coordinators can only see and edit contact records with same relationship - it just doesn't work for profiles, and I don't want the coordinators to get lost in all the details of the contact records - I don't even want them in the civicrm system - they should just use profiles which are an easy way to view and edit contacts.

I spent some time looking at this and the code and I dont think we can do this with profiles (or acl hooks since they dont apply at the profile level)

I think the easiest solution would be to just use the contact edit form for the school coordinators and if needed simplfy that form a wee bit (u can do most of this via the settings screen to hide various sections)

Another alternative might be to use a combination of views + webform, but permissioning might still be an issue there

I would say 99% of orgs using civicrm are the one org model and hence the problem below is not as common as you think

Lobo