1. Fabrik 3.8.1 has been released. It is mostly bug fixes and feature enhancements, but does include two new plugins (push notifications, and the sequence element). As usual we strongly recommend testing the new release on a sandbox if your application is mission critical, and always do an Akeeba backup before updating.

New List Doesn't Show Site Database Tables

Discussion in 'Community' started by talkinggoat, Apr 13, 2018.

  1. talkinggoat

    talkinggoat Member

    Level: Supporter
    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?
     
    Last edited: Apr 13, 2018
  2. jfquestiaux

    jfquestiaux Well-Known Member

    Level: Professional
    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.
     
  3. talkinggoat

    talkinggoat Member

    Level: Supporter
  4. Sophist

    Sophist Well-Known Member

    Level: Community
    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.
     

Share This Page