Integration of an existing table in datebasejoin checkbox

[Kant]

Hello,
I would like to integrate an existing database into the fabrik. At the moment I am only attached to the sorting function.
This should add an individual sort code to the addresses
I showed the structure here:

http://prntscr.com/hfs6qb


In sort_map the element sortier_id is executed as databasejoin and render as checkbox.
For multiple input, a table (sorting_code_map_repeat_sortier_code_id) was generated

1. Is it possible to contect an existing table for the checkbox application? I still want to use the existing table name and index name for a different connection.

2. I get the following error message from the factory-generated table
"You have an error in your SQL syntax, check the manual that corresponds to your MySQL server version for the correct syntax for use near 'AND ID NOT IN (3)' on line 3"

Greetings,
Oliver

 

[cheesegrits]

Any idea where that NOT IN is coming from? I can't think of anywhere in our code we use a NOT IN with joins. Do you have a custom WHERE filter on it?

No, it's not currently possible to use your own name for the many-to-many map table generated for the checkbox join.

-- hugh

 

[cheesegrits]

Actually, I tell a lie, we do use NOT IN, when deleting checkbox join selections, ie. if you unselect a checkbox and submit the form.

I've committed a change to quote the field names:

https://github.com/Fabrik/fabrik/commit/cdd43836399c9d62d82d67415107bd3ccedc5998

... just in case for whatever reason your MySQL doesn't like that unquoted 'id', as it's strange that your system is rendering it in CAPS in that error msg, which may indicate it thinks it's a reserved word.

-- hugh

 

[Kant]

Hi,

I could solve the mistake. This was due to the attempt to integrate the existing lists. soory for the false alarm

regards,
Oliver