DBjoin checkbox with where-clause

[PvN94]

I have a databasejoin, rendered as checkbox, 'my_table___join' joining to another table 'my_other_table'. I set the value as 'my_other_table___id' and label as 'my_other_table___name' and then in the where clause I make sure to select only appropriate rows using 'WHERE {thistable}.link_id = '{my_table___id}', {thistable} here referring to my_other_table

Works great for displaying the right rows in the dbjoin, but when saving I get the error 1054 unknown column 'my_table_repeat_join___link_id'. Somehow when saving {thistable} is no longer my_other_table, but the created join table 'my_table_repeat_join'.

Is this intended behavior, and if so how do I make it work? Or is it a bug?

 

[cheesegrits]

Probably a bug. I'll take a look.

-- hugh

 

[cheesegrits]

Yup, bug. Should be fixed as of this commit:

https://github.com/Fabrik/fabrik/commit/3652fe0efbddc3fe975e341bdcde7fae871b07fc

-- hugh

 

[PvN94]

Yup, works great. Thanks!

 

[cheesegrits]

BTW, as you seem to be a paid up Standard member, best to post in the Standard forum, as I don't always look in Community on any given day.

-- hugh