Multiselect dropdown default value from DB problem

Need help Plugins

as1 September 23, 2021, 10:50am 1

I use multiselect dropdown with values from external dictionary got from API.
User choose some options from dropdown, I save it to database through API, everything works fine.

But there is a trouble with default value. I need to get default values from the same type of data as Choices source and this is my dictionary.

Okay, but I need to filter it with user saved values. And here I can choose only single element as a constraint (not a list of them). I’ve got to compare if with list of items (saved by user in database). And there is a conflict.

As a result - empty default value.
Details you can see on screenshot.

Do you have any solutions guys?
Thank you!

codecompany September 23, 2021, 11:40am 2

Instead of selecting ‘id =’ try the Advanced option instead.

as1 September 24, 2021, 4:31am 3

I’ll try it, thank you

as1 September 27, 2021, 5:57am 4

Unfortunately it doesn’t work in a way I need. Let me explain.

What I need is to compare my dictionary id’s with database values.
For example if I set constraint as one ID, it works correctly.

But there are list of ID’s in value. And if add one more ID to constraint, dropdown value turns into empty.

If I try Advanced method, it evaluates as true/false. If true dropdown value returns all the options from dictionary. If false - no options at all.

codecompany September 27, 2021, 8:30pm 5

Hi @as1 ,

Have a look at the filter Advanced: Thing > ContainsList.

as1 September 28, 2021, 4:09am 6

Yeah bout somehow it doesn’t work that way.
It should evaluates as ‘yes/no’, but evaluates as empty.

codecompany September 28, 2021, 2:31pm 7

Hi!

Please check that you are working with compatible data types.

as1 September 28, 2021, 3:40pm 8

Here is the thing:

dictionary - API method №1
saved values - API method №2

So I need to filter List №1 with values from list №2.
And yes, Bubble define them as a different types because they came from different API-methods.

In this case with two API-methods how exactly can I filter lists?

codecompany September 28, 2021, 4:07pm 9

Three possible options:

Format the result of both as text on request. You might have “Format as text” available after ie. “…item’s id”.

Filter when you build your API query string.

Save the data in Data Types or Custom States and apply a filter.

as1 September 29, 2021, 2:43pm 10

Thanks, I’ll try first option.