List as input won't work

filiphartman

I want an input to be a list, but I get this message - what does it mean and how do I solve it?

Chris Coleman

Hi @filiphartman. The input is fine, but I expect there is an error coming from where you're trying to refer to the list in the function stack. Can you show me what you're trying to do with it?

Louis Machado - CSA

Did you set your input to be a list?

filiphartman

Okay, it seems so!

So I'm basically want to filter the database based on if the "users_id" is found in the "notification.to"-column.

It says that it requires an integer - but if I try to create a new variable that is an integer I get the same error still

filiphartman

And yes, the input is set to list

Louis Machado - CSA

Provided that the field to in the notification database table is a list, the operator == won't work. You will want to use overlaps instead.

Also, in the screenshot, the input users_id is apparently set as text and the field to is presumably a table reference containing unique IDs, which are integers. Let me know if this information was helpful.

filiphartman

Aha, "overlaps" was the piece of the puzzle I was missing, thanks a lot!

danielbevan_tinkso

There might actually be a bug here. All of a sudden the following isn't working and throwing the following error:

Error

danielbevan_tinkso

Update. Believe it not, the string "dyn" is causing this error. @Chris Coleman Please look into this.