[Vtigercrm-developers] Problem filtering by assigned_to search field

[Rishab K]

We will update you once we review this problem
Thanks


On Thu, Aug 7, 2014 at 6:09 AM, johnnyrockets <johnb at newsreview.com> wrote:

> Greetings all.  First of all, fantastic work on Vtiger 6.1 thus far.  We're
> eagerly awaiting the upcoming release.
>
> We're noticing an issue when it comes to searching or filtering using the
> assigned_to field.  The following steps will reproduce the problem.  Note:
> two users assigned to the same role will be necessary.
>
>     1) Create a new organization with User1.
>     2) Go to Organization module.
>     3) Transfer ownership of new organization to User2 (everything, all
> contacts, documents, etc).
>     4) Logout and log back in with User2.
>     5) Go to the Organization module and filter the results using the
> assigned_to text field (set it to User2).  Click search button.
>
> The newly created organization that was just transferred to User2 doesn't
> appear.
>
> Upon further investigation, it appears that the sql being executed is
> searching for the creator, instead of the owner.
>
> SELECT
>     count(*) AS count
> FROM
>     vtiger_contactdetails
>         INNER JOIN
>     vtiger_crmentity ON vtiger_contactdetails.contactid =
> vtiger_crmentity.crmid
>         LEFT JOIN
>     vtiger_users ON vtiger_crmentity.smcreatorid = vtiger_users.id
>         LEFT JOIN
>     vtiger_groups ON vtiger_crmentity.smcreatorid = vtiger_groups.groupid
> WHERE
>     vtiger_crmentity.deleted = 0 AND
> (((trim(CONCAT(vtiger_users.first_name,
>                 ' ',
>                 vtiger_users.last_name)) LIKE '%Gil Gunderson%' or
> vtiger_groups.groupname LIKE '%Gil Gunderson%')))
>
> We are not completely up to date with the 6.1 branch so I'm not sure if
> this
> issue has already been addressed and/or handled.  Please let me know if
> more
> information is needed or if there is a known solution to this problem.
>
> Thanks,
> John Biz
>
>
>
> --
> View this message in context:
> http://vtiger-crm.2324883.n4.nabble.com/Problem-filtering-by-assigned-to-search-field-tp11761.html
> Sent from the vtigercrm-developers mailing list archive at Nabble.com.
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140807/25dd1857/attachment.html>