Valuelist Stuck in Old Design?

Classic Servoy
1

I’ve got a valuelist that seems to be stuck in an old design… I created the valuelist - based on a table, which worked a treat! I’ve now changed the table structure, and of course reworked the valuelist.

One of the columns the valuelist was based on is now no longer in place (column deleted), but the valuelist does not point to that column any more. However the valuelist continually creates an error and suggests the missing column needs to be there??? :?

Saved the valuelist, closed and reopened Developer yet still the error persists? Is there a way to fix the valuelist - don’t really want to re-build it as there are quite a few forms using it currently.

2

Switch to the resource perspective, select the valuelist, right-click it and choose “Open With… Text Editor”, you will see something like this:

addEmptyValue:1,
dataProviderID1:"cdcol",
name:"color_codes_codesonly",
relationName:"vl_available_colors",
returnDataProviders:1,
separator:" ",
showDataProviders:1,
sortOptions:"",
typeid:34,
uuid:"bbcb2004-f54b-4c5a-9ed5-3deda032bf94",
valueListType:1

Backup the text by pasting it somewhere and try to figure out how to remove the offending column, beware to not touch the uuid or you will have to relink the valuelist to all the elements that are using it.

Or maybe it’s easier if you change the valuelist to a fixed list of items, save, change it back to a DB table/columns.

3

Thanks Nicola - that’s what I was looking for! :D

Looks like its a bug that it hangs on to the old settings though - especially after editing, saving and then close/reopen developer? :x