burghard
Member
I need the user element plugin for a cross database join because all my data for fabrik are in a different database for my installation (not the joomla database). I would contribute code to it, if I get a pointer to the code (probably in the database join element plugin code).
In http://fabrikar.com/forums/index.ph...d-in-numeric-not-user-name.45611/#post-235183 cheesegrits states that the dbms MySQL does not support cross database joins. But this seems not to be true since the SQL command
SELECT * FROM this_database.table_1 t1
JOIN that_database.table_2 t2 ON t2.column= t1.column
works well as stated in https://stackoverflow.com/questions/1972943/how-do-i-construct-a-cross-database-query-in-mysql.
So can anyone give me a pointer to the code?
In http://fabrikar.com/forums/index.ph...d-in-numeric-not-user-name.45611/#post-235183 cheesegrits states that the dbms MySQL does not support cross database joins. But this seems not to be true since the SQL command
SELECT * FROM this_database.table_1 t1
JOIN that_database.table_2 t2 ON t2.column= t1.column
works well as stated in https://stackoverflow.com/questions/1972943/how-do-i-construct-a-cross-database-query-in-mysql.
So can anyone give me a pointer to the code?
Last edited: