How do I pass selected values from a multi select dropdown to a local database using SQLite?

Troubleshooting

I am trying to allow users to add multiple symptoms when they log an exercise. I have a multiselect dropdown called symptomDropDown. In my db schema, symptomsList is a Text. In my logExercise, updateExercise, and getExercise queries I have symptomsList selected as a String and List.

There are no bugs in the development UI but when I try to run the project I get the below error.

Please help!!! This seems like it should be super simple but I cannot find any docs on it and ChatGPT and Claude are no help!

The goal is to be able to add the symptoms to the database, and then on another screen get the logged exercises and display the symptoms. Thanks!

Target dart2js failed: ProcessException: Process exited abnormally with exit code 1: lib/backend/sqlite/sqlite_manager.dart:56:9: Error: No named parameter with the name 'symptomsList'. symptomsList: symptomsList, ^^^^^^^^^^^^ lib/backend/sqlite/queries/update.dart:4:8: Info: Found this candidate, but the arguments don't match. Future performLogExercise( ^^^^^^^^^^^^^^^^^^ lib/backend/sqlite/sqlite_manager.dart:79:9: Error: No named parameter with the name 'symptomsList'. symptomsList: symptomsList, ^^^^^^^^^^^^ lib/backend/sqlite/queries/update.dart:24:8: Info: Found this candidate, but the arguments don't match. Future performUpdateExercise( ^^^^^^^^^^^^^^^^^^^^^ lib/backend/sqlite/queries/update.dart:16:170: Error: Undefined name 'symptomsList'. INSERT INTO exercise_log (exerciseName, logTimestamp, duration, symptomsList, difficulty, pain, notes, size) VALUES ('${exerciseName}', '${logTimestamp}',${duration},'${symptomsList}',${difficulty},${pain},'${notes}',${size}); ^^^^^^^^^^^^ lib/backend/sqlite/queries/update.dart:42:19: Error: Undefined name 'symptomsList'. symptomsList = '${symptomsList}', ^^^^^^^^^^^^ lib/pages/log_exercise/log_exercise_widget.dart:581:29: Error: No named parameter with the name 'symptomsList'. symptomsList: model.symptomDropDownValue, ^^^^^^^^^^^^ Error: Compilation failed. #0 RunResult.throwException (package:fluttertools/src/base/process.dart:122:5) Error: Failed to compile application for the Web.

What have you tried so far?

I have tried every combination of having symptomsList be a List or a string that is nullable.

I have added a default value in the database schema for it to be '[]'.

I have tried to pass the symptomsList list to a custom function that returns it as a string that gets passed to the database table.

I have tried to convert the symptomsList list to a string using code expression.

Did you check FlutterFlow's Documentation for this topic?
Yes
2