Cases Tile View - New status not available in tile view config

Hi Alexander Fechner ,

There's nothing you are doing wrong; this looks to be a Sugar defect. I replicated your issue in a stock Sugar instance by doing the following:

1. Go to Tile View Settings and move the 'Rejected' and 'Duplicate' options to the Hidden column
2. Go to Dropdown Editor and modify the case_status_dom as follows:
   1. Remove 'Rejected' and 'Duplicate'
   2. Add 'In Progress'
3. Go back to Tile View Settings and observe that the new 'In Progress' option is not available

The issue is that once you save changes in Tile View, they are written to the database. Saving updates to a dropdown list (label changes or new entries) make no attempt to update Tile View configurations. At a minimum, I would expect it to add the new entry to the Hidden options. If you are in SugarCloud, the best thing to do is raise a support case as they can manually update the database to show your new option.

If you are on-premise, you can update the database yourself. You can see the value you need to update by running the following query:

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

That will give you a long text string where you need to find the following string:

"Cases":{"status":{"New":"New","Assigned":"Assigned","Pending Input":"Pending Input","Closed":"Closed"}}

You will want to replace that text with:

"Cases":{"status":{"New":"New","Assigned":"Assigned","In Progress":"In Progress","Pending Input":"Pending Input","Closed":"Closed"}}

Once those changes are made in the database by you or Sugar Support, you will then need to run a quick repair by going to Admin > Repair > Quick Repair & Rebuild. After the repair completes, your tile view should be updated!

Chris

Hey Chris Raffle ,

since still cannot change anything in the tile view config as admin (saving results in 500 error and the logs give no further explaination about the root cause), could you pls tell me how I can change the tile body fields via DB statement? Is there a fix, so that I can change the tile view without asking IT personal?

BR

Alexander

Hi Alexander Fechner ,

It seems likely that the database update did not contain the expected format. Please provide the full output of the following query when you get an opportunity:

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

Chris

Hi Alexander Fechner ,

It seems likely that the database update did not contain the expected format. Please provide the full output of the following query when you get an opportunity:

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

Chris