Hi Team,
User is in need to enter Custom Values via Tempo Actions for a drop down list to fetch values, So We designed a DB table to store the custom values entered in the "Editable Grid" under Actions Menu(Tempo).
In the interface we are fetching column values from the DB column via query. Now when user is removing the values in editable grid under Actions Menu, the interface is throwing an error like
A dropdown component label=ABC has an invalid value for "value".All selected values must be present in the choice values array, but the value was "x" and choice values was "y,z,c,d"("X" is removed now in editable grid)
As we are querying the table , it should now fetch only the values present in table.but there may b few records that are still having the old values set to the field.is there a solution?How to handle this.
Please help.
Discussion posts and replies are publicly visible
Another option is to check to see if the value is active in the reference table or not. If it is not present in the reference table, display a null value and force the user to update the value to one of the active values. Look at using the contains function to check to see if the value is in the list of active values.