Users not able to see listview under cases *search citeria is clear*

[katrix1982]

Hi,
I have the weirdest issue. Users can see the cases that are assigned to them only on the dashlet on the front page. But they can't see the Cases under "case list" I thought it might have been my search criteria, but I have checked and rechecked all the search fields, hit clear 10-20 times... nothing worked.

when i log in under admin i can access all the cases, and see all the cases under Case list.

the cases are being created, and everything is functioning the way it should...expect users are unable to view anything under caselist. How can i fix this?

I tried doing role management repair.
I tried doing database base repair on just cases module.
I tried giving non restricted access to the user.
I tried creating a new test account and not assigning any roles to it.

I have tried to Google/search forums... no luck
any help is greatly appreciated

**update**
The new account "test" seems to show the results only when i click on clear, or select any search option.
Reading one of the other posts http://www.sugarcrm.com/forums/showt...t=no+case+list I tried to remove the 'save_query'. This didn't solve the problem

[chinwoei]

try following method:

1. Remove all the fields inside the list view, only remain case number and case name.
2. Do a repair on the Case module only.
3. Do a clear.

[katrix1982]

Thanks for the response... I tried what you recommended
1. Remove all the fields inside the list view, only remain case number and case name.
2. Do a repair on the Case module only.
3. Do a clear: *there were 4 clear options under repair, i cleared them all..

Still no luck

I have a team module installed... i tried to disable that thinking that may have been it... but that didn't help either.

any other ideas???

Thank you.

[leowolff]

I think its something related to team module that you just got rid off. Have you tried assigned the cases to new users after clearing it? You might take a look at the database and see what fileds that module has installed and try to clear it.

[katrix1982]

It seems like the "teams" module is the culprit... i tried to uninstall the team module... and i got bunch of errors.

Now when i go cases now, i get this error.

Warning: require_once(modules/team/teams_logic.php) [function.require-once]: failed to open stream: No such file or directory in /home/XXXXXX/sugarcrm.XXXXXXX.com/custom/modules/Cases/metadata/listviewdefs.php on line 83

to fix this:

I had to go into the following files and delete the code associated with "teams" module... the code looks something like this:
<?php
/*
This limits the ListView based on teams - part of the CE Teams module
It is a template which is added to the end of modules/<module>/metadata/listviewdefs.php
by the custom logic whenever it is needed
This is needed because there is no logic hook that can modify the listview query
*/
require_once "modules/team/teams_logic.php";
$tmp = new teams_logic();
$tmp->limit_list_access($this, 'before_listview');
?>

I had to take this code out under the following files... all located under: "/custom/modules/"
Listviewdefs.php (under users)
popupdefs.php (under users)
listviewdefs.php (under cases)

I had to remove that code from bunch of files in /custom/modules


Thank you for taking some time to address this issue.

the following post was also helpful
https://www.sugarcrm.com/forums/show...t=41696&page=6

[geraldobh]

I had the same problem! I made a manual update on database:

UPDATE accounts SET deleted = '0' WHERE account_type ='Customer'