-
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
How to use form element in a 'Data - where' clause
- Thread starter linque
- Start date
http://fabrikar.com/forums/index.php?wiki/database-join-element/#data-where
It's SQL not php, you can use column names and/or Fabrik placeholders
It's SQL not php, you can use column names and/or Fabrik placeholders
Not sure what you are trying, you are showing a list's filter block, not a form.
Do you want to "preset" the filter? Changeable by the user (e.g. via URL filter) or "fix" (Pre-filter)?
http://fabrikar.com/forums/index.php?wiki/filtering-lists-tables/
The syntax for element placeholders (element value in the record you are just on) is {your-full-element-name}, but it doesn't make sense to set the Data-where to do filtering. You may use "Filter where" (but no element placeholder here), see the tooltips.
http://fabrikar.com/forums/index.php?wiki/placeholders/
Do you want to "preset" the filter? Changeable by the user (e.g. via URL filter) or "fix" (Pre-filter)?
http://fabrikar.com/forums/index.php?wiki/filtering-lists-tables/
The syntax for element placeholders (element value in the record you are just on) is {your-full-element-name}, but it doesn't make sense to set the Data-where to do filtering. You may use "Filter where" (but no element placeholder here), see the tooltips.
http://fabrikar.com/forums/index.php?wiki/placeholders/
sorry, I understand nothing.
what solution do you propose ?
For 'champ ed' depending on 'champid', I use 'cascadingdropdown' and it works well.
For 'champ edcat' depending on 'champid' and 'champ ed', what do you propose ?
I've tried several things like an other 'cascadingdropdown' or this :
or other things but nothing is working.
Do you have an idea ?
what solution do you propose ?
For 'champ ed' depending on 'champid', I use 'cascadingdropdown' and it works well.
For 'champ edcat' depending on 'champid' and 'champ ed', what do you propose ?
I've tried several things like an other 'cascadingdropdown' or this :
or other things but nothing is working.
Do you have an idea ?
Cascading dropdown element doesn't have a Data- where.
Databasejoin's Data-where needs SQL, not php (but not needed here at all, it's only to restrict the dbjoin options).
If you want your filter elements to show only options depending on the selection of the "parent" you need
1. champid dbjoin
2. champ_ed CDD watching 1 (so showing only options depending on the selection of champid)
3. champ_edcat CDD watching 2 (so showing only options depending on the selection of champ_ed)
No Data-where etc needed.
Make sure to set up your CDDs correctly.
Databasejoin's Data-where needs SQL, not php (but not needed here at all, it's only to restrict the dbjoin options).
If you want your filter elements to show only options depending on the selection of the "parent" you need
1. champid dbjoin
2. champ_ed CDD watching 1 (so showing only options depending on the selection of champid)
3. champ_edcat CDD watching 2 (so showing only options depending on the selection of champ_ed)
No Data-where etc needed.
Make sure to set up your CDDs correctly.