I just saw the ticket, so you can disregard my comment in the other ticket.
Yeah, I imagined there was a statement limiting the query. What I don't understand is that this is simply a grouping clause, and it shouldn't affect the amount of data being displayed in the table.
I was searching for a record I knew was in the data and nothing was coming up. Then I noticed this:
Showing 11,251 to 11,266 of 11,266 entries (filtered from 168,268 total entries)
I don't have any filters applied.
The record is in my database, I just can't access it from WPDataTables.
I need to be able to search and filter from the whole database from WPDT. What is this limitation and how can I get around it?
The limit disappears when I removed this line from the SQL Select Statement
___________
GROUP BY wp_foundationdetail.`EIN`
_____________
Hello wiredlisa.
I just saw the ticket, so you can disregard my comment in the other ticket.
Yeah, I imagined there was a statement limiting the query. What I don't understand is that this is simply a grouping clause, and it shouldn't affect the amount of data being displayed in the table.
Can you, please show me the whole query?
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables