Problem with databasejoin filter (WHERE)

[jo-ka]

Hello.

I have a databasejoin element on a form, connected to a list, nothing special here...



But I have a WHERE clause, that's giving me problems. Ajax update is on, watching the element on the WHERE clause.




When I use this clause on the form, at first everything seems to be correct, this is, thw dropdown values on the list are correctly filtered and, when the form is saved, the data is stored on the database.



But, when editing the form, after save of course, the previous selected value is missing, and the 'Please select' is the only option available, although the value is still stored on the dabase.


If I remove the clause, everything is OK.

What am I doing wrong here?

Thanks in advance.

 

[troester]

Try ...idjogo = '{..._raw}'
If this doesn't help:
Enable Fabrik debug in FabrikOptions and append fabrikdebug=1 to your form URL.
This should show somewhere the generated query.

 

[jo-ka]

Try ...idjogo = '{..._raw}'
If this doesn't help:
Enable Fabrik debug in FabrikOptions and append fabrikdebug=1 to your form URL.
This should show somewhere the generated query.

Thanks @troester. The {..._raw} suffix made the trick!