I need to sort Ascending (oldest date at the top) but I only want to show the 5 most recent entries. I want new entries to filter up from the bottom, and the oldest one to pop off the top.
I'm using this to create a very simple schedule. One person per week, only displaying 5 records at a time.
I put a filter on the Table View rendering the form. Any date less than today gets filtered out, limit of 5, and sort by date ASC!
You can sort like this
created DESC LIMIT 5
That is to set in a TableView's
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The dates are being submitted in chronological order, for an upcoming schedule, so this puts farthest date out at the top. I want the oldest date at the top.
I want to sort, limit, then re-sort.
I'll try ordering by created desc, then date Asc... not sure if that's going to be helpful, but it's something.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As a workaround, I'm hiding the registration form to add new entries and leveraging the in-line edits feature.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.