Pre-filter Joined Tables

[tendesign]

Hi,

I know this question has been asked before, but I can't seem to get this working correctly.

I have two tables 'trips' and 'trip_notes'.

'trip_notes' has a database join element of 'trip_notes___trips_id'

and 'trips' has an inner-join from 'trips' to 'trip_notes' and 'id' to 'trips_id'

Under 'trip_notes' there is a column for display which can have a value of Yes/No which should determine if the note is displayed on the front-end. I tried the following in the Data-Where field for the 'trips_id' field

WHERE trips_notes.display = "Yes"

but got an error Unknown column 'trip_notes.display' in 'where clause'

I'm not the best at writing queries, so not sure what I'm missing here...

 

[troester]

Use
WHERE {thistable}.display = "Yes"
literally {thistable}
http://fabrikar.com/forums/index.php?wiki/database-join-element/#data-where

 

[tendesign]

i am getting this when I try to view the record now...

Unknown column 'trips_3.display' in 'where clause'

which I have no idea where it's getting the trips_3 from. that is not that database name of either table.

 

[tendesign]

I solved this on my own. I needed to set a pre-filter WHERE trip_notes EQUALS Yes type = Text apply-to = Registered