djie
New Member
After my upgrade from Joomla 2.5 tot Joomla 3.3 and applying the latest fabrik build from Github (28-5) the pre filter I have does not work anymore.
The challenge: show only the lowest value per user in the list.
This Pre filter worked before the update:
Join: Where
Field: id
Condition: in
Value:
Type: Query
Apply to: Guest
Hopefully this is just a syntax thing and I am forgetting some ' or `....but it worked before the update :S
The challenge: show only the lowest value per user in the list.
This Pre filter worked before the update:
Join: Where
Field: id
Condition: in
Value:
Code:
select b.id from (select event, userid, min(time_calc) as fastest_time from db_results group by event, userid) as fastest_times, db_results b
where fastest_times.event = b.event and fastest_times.userid = b.userid and fastest_times.fastest_time = b.time_calc
Apply to: Guest
Hopefully this is just a syntax thing and I am forgetting some ' or `....but it worked before the update :S