Database View shows old reference display value after fix script update

[js222359]

I’m running into an issue with a database view showing a stale reference display value after a fix script. I updated a list type field (Network) on a custom table via a fix script. The Network column is being treated like a reference on the database view. The record form shows the correct, updated value. The database view list still shows the old display value. List refresh, cache flush, and re-querying the view do not resolve it. Also re-saving the record does not refresh the value in the view.

[Matthew_13]

Understood. If the sys_db_view_table_field mapping is correct and a rename/revert plus cache flush did nothing, then I think you are almost certainly dealing with display value resolution for list field inside a DB view, not a “bad mapping” problem.

• handle it at the view metadata level by deleting and recreating the Network field mapping so the platform recompiles that column, and

• if that still doesn’t refresh the label, use a derived string display field on the base table, or move the field to a normalized m2m table, which works reliably in database views and reporting.

So basically the view mapping is fine; its the way database views show list display values that causes the stale label.

@js222359 - Please mark as Accepted Solution and Thumbs Up if you found Helpful!!