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

Thx for your reply. Since we are on premise I will ask my tech colleagues to make that db update.

BR

Alexander

Thx for your reply. Since we are on premise I will ask my tech colleagues to make that db update.

BR

Alexander