Select component show only values not inserted in database

[pernetpervenches]

Hi
I wish to have a select component that show a list of values that remains to be inserted in database.
Everytime I insert a value in the database, the select component should remove this value.
It is possible? How to do that?

Thanks

[SWInfotech]

Yes, It could be done in query level, that the inserted values should not show
or
use dmx-hide if its inserted

[pernetpervenches]

Hi thanks for your reply. Could you please show me an example of that?

[SWInfotech]

connect me with anydesk id, ill help, send via message

[pernetpervenches]

I’m sorry but I’m at work and I cannot use Anydesk

[Teodor]

You can filter the database query, which is used to populate the select using the NOT IN condition and use as a value the items already inserted in the database.

[pernetpervenches]

thanks Teodor, could you please show me visually?

[Teodor]

You need two database queries - one, which returns the items stored in the database and another one for the query items:

You don’t need to filter the first one, just turn off the output for it.
The second query will used the results from the first one in the filters. So:

In the conditions, select the id column, select NOT IN and then select the first query, apply the flatten formatter and select the id column.

[pernetpervenches]

It works, thanks Teodor