<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>I found the solution... if anyone is experiencing the same issue,
there's a bug in modules/CustomView/CustomView.php line 2015:</p>
<p>$sql = "select vtiger_users.id from vtiger_customview inner join
vtiger_users where vtiger_customview.cvid = ? and
vtiger_customview.userid in (select vtiger_user2role.userid from
vtiger_user2role inner join vtiger_users on
vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on
vtiger_role.roleid=vtiger_user2role.roleid where
vtiger_role.parentrole like<span style="background-color:#ff6;">
'%" . $current_user_parent_role_seq . "::%</span>')";</p>
<p>should be: <br>
</p>
<p>$sql = "select vtiger_users.id from vtiger_customview inner join
vtiger_users where vtiger_customview.cvid = ? and
vtiger_customview.userid in (select vtiger_user2role.userid from
vtiger_user2role inner join vtiger_users on
vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on
vtiger_role.roleid=vtiger_user2role.roleid where
vtiger_role.parentrole like<span style="background-color:#ff6;">
'%" . $current_user_parent_role_seq . "%'</span>)";</p>
<p>basically $current_user_parent_role_seq . "::%' should have no
columns</p>
<p>After removing the double columns from the query, both the user
and the group started working as expected</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 08/01/2019 14:12, lucia digirolamo
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:57eb9c53-5870-7709-3d67-2a2d2a471c80@websonica.net">Hi,
<br>
<br>
I've just noticed something weird on my vtiger 7.0...
<br>
<br>
Situation:
<br>
<br>
- a non-admin user (user A in group A) creates a list and shares
it with another user with same level and privileges as he (user B
in group A)
<br>
<br>
- user B clicks on the list
<br>
<br>
What I expect:
<br>
<br>
- the list gets loaded and user B can interact with it
<br>
<br>
What really happens:
<br>
<br>
- after user B clicks on the list, the correct list appears while
the page is loading but when loading is done, the user is
redirected to All.
<br>
<br>
Note:
<br>
<br>
- this doesn't happen with admin user. If admin user wants to see
the list, he just clicks on the list and it gets loaded correctly
<br>
<br>
- I tried with different sharing options: with both specific user
and group the problem happens. however it doesn't happen if I
select "all users" as a sharing option
<br>
<br>
<br>
Any idea on how to solve this?
<br>
<br>
<br>
</blockquote>
</body>
</html>