…if the valuelist comes from a table and display values come from a calculation.
If I change the display type of the field on the form to ‘COMBOBOX’ then everything is fine, otherwise calculation is not working, the list is empty.
Here’s the calculation:
function typename_i18n_label()
{
var label = i18n.getI18NMessage(typenamei18nkey);
return label;
}
i guess that calculation is not stored?
Then it will not work, typeaheads can only work on stored data for the display values
This is because it is a typeahead, that means it searches for you when you are typing and that searching is done by direct queries to the database.
So if a none stored calc would be able to work, then we need to search in memory, that would mean that we need to get all the rows from the database to be able to calculate the display string. that really hinders performance.
jcompagner:
i guess that calculation is not stored?
Then it will not work, typeaheads can only work on stored data for the display values
This is because it is a typeahead, that means it searches for you when you are typing and that searching is done by direct queries to the database.
So if a none stored calc would be able to work, then we need to search in memory, that would mean that we need to get all the rows from the database to be able to calculate the display string. that really hinders performance.
That’s understandable, Johan.
Just to be clear on this, Servoy is not planning on changing typeaheads to feed from non-stored calculations, correct?
As an alternative, you could create a dataset with the values and the messages.
From that dataset you could create a datasource and from the datasource you could create a db-valuelist using the solutionmodel.
Every time the user changes the language you would have to refill the datasource (just create the with the same name again).
