<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Thank you Joe, with this script I was
indeed able to quickly add the user selection system and
throughout the day have managed to adjust queries as needed to the
point where we almost have a working solution (at least for
accounts, but the replication to other modules would be simple). <br>
<br>
Unfortunately, the user selection in this manner seems to only
work for administrators (I guess because only admins have access
to the users information). Can anyone suggest a solution for me
where I will be able to use a related list of users and allow all
users to adjust it?<br>
<br>
Thank you in advance<br>
<br>
On 05/12/12 09:29, Joe Bordes wrote:<br>
</div>
<blockquote cite="mid:50BE5D35.2050000@tsolucio.com" type="cite">Well,
we have to keep saving the banks and giving money to the people
who don't know where to put it anymore. We have nothing better to
do with the money ;-)
<br>
<br>
That said, the thing is more a question of time. I have a bunch of
people waiting on me already, so dedicating 10-20min to remember
what project(s) we did this on then undig it from svn (thank
goodness for subversion, thank you!!) and answer the email is a
luxury. I try my best to answer questions, but generally can only
get at those that I can answer very quickly.
<br>
<br>
As I remembered the additional change was on the delete action
which needs some code modifications, although I see that we
created a specific method for the list which I didn't remember.
<br>
<br>
Hope that helps.
<br>
<br>
Note: support to keep the banks happy is welcome :-)
<br>
<br>
<br>
Let us know how it goes.
<br>
<br>
Regards
<br>
Joe
<br>
TSolucio
<br>
<br>
<br>
<br>
On 04/12/12 20:34, Richard Hills wrote:
<br>
<blockquote type="cite">Hi Joe,
<br>
<br>
I also considered using the _crmentityrel table however am still
having
<br>
issues with my custom timesheets loading from this table despite
<br>
covering indexes (the list query is taking like 30 minutes). I
realise
<br>
that my own queries won't suffer from this lag however was
thinking it
<br>
might be safer to avoid it all together. The fact you also did
it that
<br>
way changes my mind however and I guess we will do it the same
way
<br>
(saves all those custom fields for users).
<br>
<br>
Thanks for your input. If you want to share what script you
adjusted
<br>
then feel free, though I am aware you most likely will use this
as a
<br>
commercial product :)
<br>
<br>
On 04/12/12 22:15, Joe Bordes wrote:
<br>
<blockquote type="cite">We have done this in the past a few
times for very specific situations.
<br>
What we do is create a vtlib related list that saves the users
in
<br>
_crmentityrel. You have to modify some code (don't remember
exactly
<br>
what), but it is very little.
<br>
This way you avoid having to create new uitypes and the like.
<br>
Obviously you still have to modify the privileges system.
<br>
<br>
In case that helps
<br>
<br>
On 03/12/12 23:14, Richard Hills wrote:
<br>
<blockquote type="cite">Hi guys,
<br>
<br>
I have been looking at extending our vtiger installations to
allow
<br>
multiple users to be assigned a single entity. Currently I
am looking at
<br>
doing the following to achieve this:
<br>
<br>
1 - add a new uitype 52 field (or more than one) to the
modules I wish
<br>
to use.
<br>
2 - adjust the getNonAdminAccessControlQuery to return a
where clause
<br>
instead of an inner join.
<br>
3 - adjust the modules where getNonAdminAccessControlQuery
is used to
<br>
place the query change properly.
<br>
4 - further tweak the query to include a where for each of
the
<br>
"smownerid" custom fields for this module as well as the
smownerid field.
<br>
<br>
If anyone can tell me something which obviously won't work,
or can
<br>
suggest a better solution I would be open to hearing about
it.
<br>
<br>
Groups will not work as we would end up with a group for
every entity
<br>
and the administration of these groups would be more work
than simply
<br>
assigning the entity to 2-3 users.
<br>
<br>
Thank you
<br>
<br>
</blockquote>
</blockquote>
<br>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
<a class="moz-txt-link-abbreviated" href="mailto:richard@tw.co.nz">richard@tw.co.nz</a>
<a class="moz-txt-link-abbreviated" href="http://www.technologywise.co.nz">www.technologywise.co.nz</a>
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061</pre>
</body>
</html>