Keep stored values on select

hi!

We have some selects where there is a list of values stored on sql. Some of this values are not available with the time, but we want to keep the old value stored when looking at it on the front (maybe on the backend also?)

For example, imagine that I have a table like

id,name,validTo
1,Foo,null
2,Bar,2014

I don´t want the user to be able to select "Bar", but if it was selected on the past, I want to keep that info

If I make my sql query something like

select * fom list where validTo is null or validTo > today

I don´t see Bar on the select (this is nice) but I don´t see it neither on the front

There is an additional complication and that is that maybe Bar is modifiable (and called later Barrr), so its not as easy as store also the label... although it could be a compromise

What do you think?

Regards

Hello

-- in all cases whatever solution is proposed the rows should not be deleted from YOUR sql table

About solution, i think it can be to add a state properties 'state' in our SQL SELECT

state: 0 : unpublished -- hide it in form, but show it in form if field has the value already, hide values when item is viewed
state: 1 : or missing: published -- show it (current behaviour)
state: 2 : archived -- hide it in form, but show it in form if field has the value already (otherwise show as disabled), also show existing values when item is viewed
state: -2: trashed -- hide it in form, and delete existing on form save, hide values when item is viewed

SELECT col1 as value, col2 as text, col3 as valgrp, col4 as image, col5 as state ...

that sounds wonderful!

any estimate on this?

Hello

Yes have implemented states:
- "published, archived, unpublished" as described above

[strike]the "trashed" state was not done and probably will not be done later either because it could lead to issues[/strike]
No 'Trashed' will be done too

Needs a little more testing and it will go to github too

Hello

it is now on github , you may test it