When using a value list with ‘Table Values’ select a field that is of type DB Native UUID as the real value, it appears as TEXT type in the valuelist. This then causes a problem saying that the “real type TEXT does not match the dataprovider with type MEDIA” if used on an element whose dataprovider is a form variable of type UUID. When using a global method you can specify the real type to be MEDIA but there doesn’t seem to be a similar option for table values (I assume because it pulls it from the db field)
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Value list data type error | 17 | 6329 | April 1, 2005 | |
| Value Lists Again?? | 8 | 3034 | February 25, 2010 | |
| Issue with realValue in valuelist | 1 | 1538 | May 14, 2018 | |
| valuelist issue | 7 | 3753 | November 14, 2007 | |
| Valuelist: XY used with different types | 10 | 5520 | January 30, 2025 |