Show unused values in databasejoin

[chatequap]

I have a list of timeslots in a table. The values are displayed as databasejoin that is rendered as checkboxes in an entertainment form. Entertainers can choose up to 4 slots.

I would like to only display timeslots that are not used by other entertainers.


The tables are as follows:

timeslots
id timeslot
1 11:00 AM
2 11:15 AM


entertainers
id group .... timeslot


Each timeslot can only be used by one entertainer. Entertainers can choose up to 4 timeslots



Thank you.

 

[troester]

You can use the "Data -where" to restrict the options.
For multiselect dbjoins Fabrik will create a table your-table_repeat_your-dbjoinelement
with columns id, parent_id, your-dbjoinelement (+unused params)
http://fabrikar.com/forums/index.php?wiki/database-join-element/#data-where

 

[chatequap]

I am a little confused on the where clause. This is what I have so far:

where `id` NOT EXISTS (select `timeslots` FROM `mfd_entertainment_repeat_timeslots` where 1)

It gives an error

 

[troester]

It's the wrong NOT EXISTS syntax
where NOT EXISTS (select * FROM `mfd_entertainment_repeat_timeslots` m where m.timeslots = {thistable}.id)

 

[Aaron147]

Did you have a fix on this issue? I have the same problem with it.