New List Doesn't Show Site Database Tables

[talkinggoat]

I am trying to create a dropdown list of Joomla users for someone to select, when creating or editing a record, on a form. The problem I'm having is, I have created a records database, to store everything entered, that is separate from my Joomla database. I can't seem to add the Users (Fabrik) group into the form I'm creating. I am guessing it's because I'm trying to draw User info from the Joomla database and join it in a form that uses another database and they are different databases. Whenever I try to use join, it only shows the tables from the database the forum's list belongs to. Is it possible for join to bring together data from two databases?

 

[jfquestiaux]

Unfortunately, no. At this point, it's a Fabrik limitation: you can't join data tables belonging to different databases.
I guess a solution would be to put a replication process in place that would sync the concerned tables between the 2 databases, but i never tried to implement this.

 

[talkinggoat]

Thank you.

 

[Sophist]

The constraint JF refers to is that Fabrik relies on SQL JOIN to join tables and has no functionality to run two or more queries and then merge the results if the tables to be joined are in separate databases.

In this case, you may be able to avoid SQL joins by using a dropdown element (not databasejoin) with an Eval Populate to get the list of users.

I haven't tried this, but since it doesn't know what is in the eval, I can't see how it can know a join would be needed - so it might well work.