-
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 limit number of output in list view when use group by?
- Thread starter samani
- Start date
Sophist
Guest
How do you decide which ones you want to show?
Fabrik has filters which the user can set - but also List / Data / Pre-Filters which you can define for everyone.
So as long as you can define which records you want shown by the value(s) of a database field, Fabrik can do this for you.
Fabrik has filters which the user can set - but also List / Data / Pre-Filters which you can define for everyone.
So as long as you can define which records you want shown by the value(s) of a database field, Fabrik can do this for you.
samani
Member
thank you but it is not work...
i want show 4 greatest Score for each group.for that i sort by Score and group by name...but only thing that i want now, show 4 of each...
Sophist
Guest
OK - here is how I would do it.
I would create a hidden top4 field.
Then I would add a PHP Events List Plugin to the list, and write some php which will update all the rows and set the top4 field to 1 if it is in the top 4 and 0 if it isn't. This is probably quite complicated. You might be able to do it with a single SQL UPDATE STATEMENT or you might need to get the list of groups from an SQL statement and then iterate through the groups running an UPDATE statement for each group. The UPDATE statements are likely to have joins and / or subqueries and be quite complicated.
Then you would set up a pre-filter for top4 = 1.
But it is definitely possible.
I would create a hidden top4 field.
Then I would add a PHP Events List Plugin to the list, and write some php which will update all the rows and set the top4 field to 1 if it is in the top 4 and 0 if it isn't. This is probably quite complicated. You might be able to do it with a single SQL UPDATE STATEMENT or you might need to get the list of groups from an SQL statement and then iterate through the groups running an UPDATE statement for each group. The UPDATE statements are likely to have joins and / or subqueries and be quite complicated.
Then you would set up a pre-filter for top4 = 1.
But it is definitely possible.