I have a collection of job highlights that have been categorised based on their industry sector, industry or if they are related to all industries. I want to have them displayed in a choice chip widget for the user to then select which ones are relevant to their job ad. I only want to display those relevant to the industry sector the job ad is for and therefore I need to do a query filter. I am having trouble figuring out how to do the query with the filter "array contains" option as either, I cannot select the appropriate field (it does not allow me to select a single string field, only those that are lists) or when I change the field to a list of strings, I am unable to save the filter and it tells me the "current variable is not valid." I'm stumped on how to make it work and Flutterflow's documentation inadequately explains the logic behind these types of queries. What am I missing?
For reference, is is the "available options" section of the query filter that is causing the issues. I am using Firestore for the database.
UPDATE: I made the decision to move my backend to Supabase and this solved my issues around complex handling of my data.