joshblevins
Member
I have a encrypted field that I need the label to show the actual value of the encrypted data. When the encrypted value is selected it displays blank options in the dropdown.
-
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
encrypted field in database join
- Thread starter joshblevins
- Start date
cheesegrits
Support Gopher
You'll need to decrypt it yourself, using a CONCAT, something like ...
You may need to put parens round the whole expression, I forget. The only thing you need to change in that is "your_encrypted_field".
The reason we don't do that automatically is that the join element settings let you join to MySQL tables, not Fabrik Lists (so you can join to tables which don't exist as lists). Which means that we don't automatically know that you are joining to something which is actually a list, from which we could then derive the element settings and know which elements are encrypted.
At some point I may add some code to work round that, but for the moment ... it's DIY.
-- hugh
Code:
AES_DECRYPT({thistable}.your_encrypted_field, '{$jConfig_secret}')You may need to put parens round the whole expression, I forget. The only thing you need to change in that is "your_encrypted_field".
The reason we don't do that automatically is that the join element settings let you join to MySQL tables, not Fabrik Lists (so you can join to tables which don't exist as lists). Which means that we don't automatically know that you are joining to something which is actually a list, from which we could then derive the element settings and know which elements are encrypted.
At some point I may add some code to work round that, but for the moment ... it's DIY.
-- hugh