-
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
-
Donation Update and Moving Forward
Please see our announcement here.
Custom query for filters
- Thread starter mkainz
- Start date
cheesegrits
Support Gopher
Are you talking about pre-filters?
You cna usually fo "from X to Y" with two pre-filters, a "greater than X" and a "less than Y", joined with "AND" (first column of prefilter options).
If for some reason you can't, you can create more complex filters using the "query" type. So your filter would look like:
WHERE
Field: id
Condition: IN
Value: SELECT id FROM yourtable WHERE ... your complex where clause here ...
Type: query
The value can then be any valid query which returns a result set of ids from the table.
-- hugh
You cna usually fo "from X to Y" with two pre-filters, a "greater than X" and a "less than Y", joined with "AND" (first column of prefilter options).
If for some reason you can't, you can create more complex filters using the "query" type. So your filter would look like:
WHERE
Field: id
Condition: IN
Value: SELECT id FROM yourtable WHERE ... your complex where clause here ...
Type: query
The value can then be any valid query which returns a result set of ids from the table.
-- hugh