Mosaic view returns no result - missusage or bug?

Good morning fellow users,

I was wondering if it was a known bug or a bad usage from me: since i changed the "Available Values" in the parameters, the mosaic view does not return any results. I got 0 on all columns. If i switch to view list i got all the cases, but nothing in mosaic.

Other users have the same problem and it keeps happening even tho i changed the parameters back to their default values. 

Thanks.

Parents
  • Hi  ,

    The issue you are seeing with tile view is likely related to a known defect which can happen when changing the dropdown labels. The bug is fixed in the next planned release (15.0) but can be mitigated with a database update. Please provide the results of the following query from your instance:

    SELECT value FROM config WHERE name = 'available_columns' AND category = 'VisualPipeline';

    If you are hosted in Sugar Cloud or do not have direct database access, you can run this query by creating a custom query under the Advanced Reports module by substituting your instance name into the following URL:

    https://<your_SugarCRM_URL>/#bwc/index.php?module=CustomQueries&action=index&return_module=CustomQueries&return_action=DetailView

    Please also provide a screenshot of your case status dropdown list from the dropdown editor to show the database and display values. 

    Chris

Reply
  • Hi  ,

    The issue you are seeing with tile view is likely related to a known defect which can happen when changing the dropdown labels. The bug is fixed in the next planned release (15.0) but can be mitigated with a database update. Please provide the results of the following query from your instance:

    SELECT value FROM config WHERE name = 'available_columns' AND category = 'VisualPipeline';

    If you are hosted in Sugar Cloud or do not have direct database access, you can run this query by creating a custom query under the Advanced Reports module by substituting your instance name into the following URL:

    https://<your_SugarCRM_URL>/#bwc/index.php?module=CustomQueries&action=index&return_module=CustomQueries&return_action=DetailView

    Please also provide a screenshot of your case status dropdown list from the dropdown editor to show the database and display values. 

    Chris

Children