-
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
Trying to Limit Subform to the last 3 records
- Thread starter eugenecjr
- Start date
juuser
Well-Known Member
http://www.fabrikar.com/forums/index.php?wiki/list-pre-filters/
With that little information it's impossible to give more advise.
With that little information it's impossible to give more advise.
juuser
Well-Known Member
Ok, I seemed to miss the thread header and went straight to content 
Cannot test, but something like:
field: id
condition: GREATER THAN
value: SELECT MAX(id) - 4 FROM yourtable
type: query
Or, if there can be deleted rows (missing id-s in between), then:
field: id
condition: IN
value: SELECT id FROM yourtable ORDER BY id DESC LIMIT 3
type: query
Cannot test, but something like:
field: id
condition: GREATER THAN
value: SELECT MAX(id) - 4 FROM yourtable
type: query
Or, if there can be deleted rows (missing id-s in between), then:
field: id
condition: IN
value: SELECT id FROM yourtable ORDER BY id DESC LIMIT 3
type: query
Last edited:
Jusser,
I was able to put in ‘the second option’ exactly as indicated with the appropriate table. Tested the SQL statement to verify before placing in Fabrik, and after saving the list does. It open Indicating an error with the statement.
I am wondering if this has to do with the other two pre-filters I have set. One is similar the this one with a different purpose of loading the list with specific records. This is working without issue. The pre-filter I am looking for is on the child records. Present after you open one of the parents.
In effect the purpose is to limit the number of records such to improve loading time.
The purpose of this form is to present records to the user that need to be inventoried. When they open each record a short list of the last few child records is shown for the last few inventory entries for the opened item. In the past I have tried using a filter the only show the last 2-3 weeks. The issue is for items that are missed for 2-3 weeks won’t have any records and therefore are removed from the list of items to be I be inventoried.
My main issue is performance.
I hope this helps shed a little light.
-Eugene
Sent from my iPhone using Tapatalk
I was able to put in ‘the second option’ exactly as indicated with the appropriate table. Tested the SQL statement to verify before placing in Fabrik, and after saving the list does. It open Indicating an error with the statement.
I am wondering if this has to do with the other two pre-filters I have set. One is similar the this one with a different purpose of loading the list with specific records. This is working without issue. The pre-filter I am looking for is on the child records. Present after you open one of the parents.
In effect the purpose is to limit the number of records such to improve loading time.
The purpose of this form is to present records to the user that need to be inventoried. When they open each record a short list of the last few child records is shown for the last few inventory entries for the opened item. In the past I have tried using a filter the only show the last 2-3 weeks. The issue is for items that are missed for 2-3 weeks won’t have any records and therefore are removed from the list of items to be I be inventoried.
My main issue is performance.
I hope this helps shed a little light.
-Eugene
Sent from my iPhone using Tapatalk