[Vtigercrm-developers] Multiple user assignment

[Richard Hills]

Hi Joe,

I also considered using the _crmentityrel table however am still having 
issues with my custom timesheets loading from this table despite 
covering indexes (the list query is taking like 30 minutes). I realise 
that my own queries won't suffer from this lag however was thinking it 
might be safer to avoid it all together. The fact you also did it that 
way changes my mind however and I guess we will do it the same way 
(saves all those custom fields for users).

Thanks for your input. If you want to share what script you adjusted 
then feel free, though I am aware you most likely will use this as a 
commercial product :)

On 04/12/12 22:15, Joe Bordes wrote:
> We have done this in the past a few times for very specific situations.
> What we do is create a vtlib related list that saves the users in
> _crmentityrel. You have to modify some code (don't remember exactly
> what), but it is very little.
> This way you avoid having to create new uitypes and the like.
> Obviously you still have to modify the privileges system.
>
> In case that helps
>
> On 03/12/12 23:14, Richard Hills wrote:
>> Hi guys,
>>
>> I have been looking at extending our vtiger installations to allow
>> multiple users to be assigned a single entity. Currently I am looking at
>> doing the following to achieve this:
>>
>> 1 - add a new uitype 52 field (or more than one) to the modules I wish
>> to use.
>> 2 - adjust the getNonAdminAccessControlQuery to return a where clause
>> instead of an inner join.
>> 3 - adjust the modules where getNonAdminAccessControlQuery is used to
>> place the query change properly.
>> 4 - further tweak the query to include a where for each of the
>> "smownerid" custom fields for this module as well as the smownerid field.
>>
>> If anyone can tell me something which obviously won't work, or can
>> suggest a better solution I would be open to hearing about it.
>>
>> Groups will not work as we would end up with a group for every entity
>> and the administration of these groups would be more work than simply
>> assigning the entity to 2-3 users.
>>
>> Thank you
>>
>


-- 
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
richard at tw.co.nz
www.technologywise.co.nz
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061