As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
I'm using wpDataTables to display the scores for the upcoming college wrestling season
(seen here: http://www.mattalkonline.com/2016-17-college-dual-meet-scores/)
What I want to do with this data is to create standings (or sports tables) that display the total wins and losses of each team. I did this last year on my site using an embed of a google spreadsheet, but I believe a database would be more flexible.
Are there queries out there that will total the wins and losses by team (or total up each name in each field and total it and display like a win-loss record?)
Here is last year's embed. http://www.mattalkonline.com/college-wrestling-standings-15-16/
My sheet last year was in Google Sheets, so I ran formulas to tabulate them. Is anyone here familiar on how to do that or if wpDataTables can handle it?
If wpDataTables can't handle it, I might just be better off doing it the old way. I love this plugin, and I'm a novice with MySQL though, so the learning curve has been tough. Appreciate any input.
Hi Jason,
Our plugin are capable of showing most of the results that you can get in database management software like phpMyAdmin or Workbench.
MySQL is supporting some of mathematical operations as well as aggregate functions but please keep in mind that if you are using functions in your queries we are strongly suggesting you to use MySQL VIEW.
You should be able to find appropriate queries or at least parts of it on web and if can't manage it yourself we can offer you to hire one of our developers to help you with it as paid customization service.