Hiding rows according to yes/no plugins

[7webcreator]

Hello,

I currently have a list with a databasejoin element linked to another list containing one yes/no plugin. I'm seeking guidance on filtering and displaying only the rows where the associated condition is marked as 'yes.' Could you please provide instructions or suggestions on achieving this?

Thank you

 

[troester]

Some pre-filter?

 

[7webcreator]

Both the lists don’t have pre-filters. When a user is completing the form that has the database join element, the user should only see one element of the rows that have been selected as yes.

 

[troester]

I meant did you try to add a pre-filter to your list?

 

[7webcreator]

Yes, I have added a pre-filter on the list providing the data where the databasejoin element looks for it. The list pre-filtered displays what I want, however, it doesn't seem to work as the user completing the form still sees all the options.

 

[troester]

What do you mean with "all the options"? Which options? Where?

 

[7webcreator]

I have identified the solution by incorporating the following code into the "data-where" section of the database join element. I appreciate your guidance in directing me towards the resolution. Thank you.

 

[troester]

Yup, pre-filters are not applied to the selected dbjoin table (it's a DB table, no list), you have to do it again in the Data-where