-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
User Databasejoin element showing ID, not label
- Thread starter emcguire
- Start date
cheesegrits
Support Gopher
Is your data table on the same database connection as Joomla?
-- hugh
-- hugh
cheesegrits
Support Gopher
I can't replicate this.
The only situation in which the user plugin would ignore the "show" setting is if it thinks it is not on the default J! database.
One other thing - have you recently restored this site from another machine, or copied the Fabrik metadata tables (#__fabrik_forms, etc) over?
Check your Fabrik connections. Edit the 'site default' and see if it complains about not being the same as the J! site connection.
-- hugh
The only situation in which the user plugin would ignore the "show" setting is if it thinks it is not on the default J! database.
One other thing - have you recently restored this site from another machine, or copied the Fabrik metadata tables (#__fabrik_forms, etc) over?
Check your Fabrik connections. Edit the 'site default' and see if it complains about not being the same as the J! site connection.
-- hugh
emcguire
Member
It's def not the site connection, all is good there.
Interesting though, This site was duplicated from another site with fabrik on it, and also this particular list (where the user field is) was an import from a csv (this data was originally a access db). I did successfully convert the userid field in that import field to a legitimate J! user field and connected the users to the corresponding J! user.
I'm wondering now if this might be causing the issue, although I converted everything perfectly. nothing wrong with that list. It displays the name just fine when looking at that list itself. It is when I am using a databasejoin field (to that list) in another form that the issue arrives.
If this was a copy, is it possible something could be wrong with the Fabrik metadata tables?
I think I am going to subscribe to Pro Support. I am way behind on this project and I normally don't have much issue with building with Fabrik, but this particular app has been giving me fits. You guys have been very helpful and I appreciate it, I have a feeling I may have more questions.
Thanks
Interesting though, This site was duplicated from another site with fabrik on it, and also this particular list (where the user field is) was an import from a csv (this data was originally a access db). I did successfully convert the userid field in that import field to a legitimate J! user field and connected the users to the corresponding J! user.
I'm wondering now if this might be causing the issue, although I converted everything perfectly. nothing wrong with that list. It displays the name just fine when looking at that list itself. It is when I am using a databasejoin field (to that list) in another form that the issue arrives.
If this was a copy, is it possible something could be wrong with the Fabrik metadata tables?
I think I am going to subscribe to Pro Support. I am way behind on this project and I normally don't have much issue with building with Fabrik, but this particular app has been giving me fits. You guys have been very helpful and I appreciate it, I have a feeling I may have more questions.
Thanks
cheesegrits
Support Gopher
A pro sub would be appreciated, and of course then I can log in to your site and take a look.
--hugh
--hugh
MeAppBuilder
Member
cheesegrits
Support Gopher
Oh, I misunderstood what you were saying, I thought you meant you had a user element.
OK, that's expected. Because although you've selected "label" as your label, if that field is actually a Fabrik 'user' element, which is just a special case of a join that always stored the 'id' as the FK, then the value in that is going to be a userid. Fabrik is smart, but it's not smart enough to know that the field you select as the label on your join is actually a join to yet another table, and automagically figure out what it's a join to and how to get the label from that join.
What you need to do is create a "CONCAT label", which does ...
Leave that exactly as is, don't change {thistable}.
So you are manually getting the username (or whatever you want, make it name or email or whatever valid fields from the #__users table you want) by selecting it from the users table, using the FK value stored in your 'label' user element (ie the PK id of the users table row).
-- hugh
OK, that's expected. Because although you've selected "label" as your label, if that field is actually a Fabrik 'user' element, which is just a special case of a join that always stored the 'id' as the FK, then the value in that is going to be a userid. Fabrik is smart, but it's not smart enough to know that the field you select as the label on your join is actually a join to yet another table, and automagically figure out what it's a join to and how to get the label from that join.
What you need to do is create a "CONCAT label", which does ...
Code:
(SELECT username FROM #__users WHERE id = '{thistable}.label')Leave that exactly as is, don't change {thistable}.
So you are manually getting the username (or whatever you want, make it name or email or whatever valid fields from the #__users table you want) by selecting it from the users table, using the FK value stored in your 'label' user element (ie the PK id of the users table row).
-- hugh