On my site, I want to build the same type of table like in the example url covers.com that displays the odds for different games offered by different sportsbooks. The numbers constantly change even by seconds like stock prices. We database all of the odds now including previous odds and the most recent. Maybe this is a dumb question because I could not find it in the documentation but if I want to create a table to display the most recent odds like covers and after creating it I put the short code in the page will it display the new data on page load?
SELECT *
FROM table_name
WHERE table_name.`name_of_column_that_contain_date` = CURDATE()
Like this will be shown only rows with current day.
If you not use queries, you can also filter the table with Conditional formatting for that column where is available %TODAY% placeholder. You have to set rules like this (image 1) where you will set two rules one that is less than %TODAY% and second that is greater than %TODAY% and set row class for example hide (like in example)
Then you have to make that class in Custom wpDataTables CSS under the "Custom JS AND CSS" in main settings of wpdatatables.(image 2)
Like this will be shown data only for current date.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features and also you can make some dummy database with similar dummy data like in your real tables and then connect with Separate SQL connection and test it.
PLEASE NOTE: when you make connection with your database with our plugin on sandbox, your credentials and also tables that you have in that database can be used by other logged in users at that moment on sandbox.
Thank you. Is it possible to use a sql query to display the most recent odds? Because it might change during the day so we need a way to show most recent. Also we need to display advanced filters that show odds in decimal fractional or american which on covers changes the value in the cells. These are the type of filter options the have: http://take.ms/hfhTf
Is it possible to build the same type of filters that when different options are chosen, the data changes? How does the data need to be structured in the mysql databse to achieve what we need? If I knew that then I can tell a developer how to build the data and what queries we need to put into the plugin.
I already bought the plugin Friday to play around with it and see how it works.
Yes it is possible with query that I provide to you in previous post and also you can set Sorting by that column on load so it will be display like you need.
We don't have such layout of the filters, but you can check all filters types in our documentation on this link.
Please take a look in attachment for detail explanation.
Please note that : Preparing data, writing queries is something that is out of scope of the standard support that we provide.
If you are buy our plugin and if you have issue or questions please open new tickets in wpdatatables category where you will insert your Purchase code for support. This is a Pre-purchase category where users have pre-sales questions and proposals.
Is there any possible way to create a dropdown with options that show: Decimal, Factional, American. Like a filter, when I choose say American, the odds in the table will display the American style odds in it? If not is there a workaround to achieve close to if not the same thing?
This is the last thing that we need to find a way to do with the plugin. The dropdowns (or anything) that can display data differently.
Maybe with a bit of customization I can achieve this. Like is there is a way to load different tables by dropdown? Or organize the data in a certain way that every option in the custom dropdown is linked to a different sql query, therefore when you choose say Amercian odds, the table will display the data according to the sql query thats linked to this select option.
Then I cannot use this plugin. There is no way to combine this plugin with another plugin or use custom javascript within the plugin to achieve what we need?
If you can just point me kind of the in the right direction please. I am also willing purchase support if its offered or have what we need developed. I just need to know what direction to go in (different sql requests made by a button, a button that loads different shortcodes when its clicked on or checked). Im not sure what to combine with the plugin to get it to work or if I need someone to develop my own solution for scratch.
Functionally that you need is not possible to achieve with built features of plugin.
Please note that customization questions like this one are not covered in the included support or in pre-purchase category questions for the plugin. Included support covers help with bugs and general inquiries for the plugin features, but not writing custom code. As you're developing some custom solution if you need our assistance we can offer you our paid customization service.
Unfortunately, at the moment we don't have available developers which can do this customization for you, because there is a lot of priority task that have to be done.
On my site, I want to build the same type of table like in the example url covers.com that displays the odds for different games offered by different sportsbooks. The numbers constantly change even by seconds like stock prices. We database all of the odds now including previous odds and the most recent. Maybe this is a dumb question because I could not find it in the documentation but if I want to create a table to display the most recent odds like covers and after creating it I put the short code in the page will it display the new data on page load?
Hi Mark,
Thank you for your interest in wpdatatables.
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Displaying data like you need depends of data in your database and aslo of CSS that you will need to insert to make this possssible.
Unfortunately at the moment is not possible to set current day in filter predefined value in filters.
You can achieve this with Creating table from SQL query like this if your tables have column that contain dates.
Like this will be shown only rows with current day.
If you not use queries, you can also filter the table with Conditional formatting for that column where is available %TODAY% placeholder. You have to set rules like this (image 1) where you will set two rules one that is less than %TODAY% and second that is greater than %TODAY% and set row class for example hide (like in example)
Then you have to make that class in Custom wpDataTables CSS under the "Custom JS AND CSS" in main settings of wpdatatables.(image 2)
table.wpDataTable tr.hide { display:none !important; }Like this will be shown data only for current date.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features and also you can make some dummy database with similar dummy data like in your real tables and then connect with Separate SQL connection and test it.
PLEASE NOTE: when you make connection with your database with our plugin on sandbox, your credentials and also tables that you have in that database can be used by other logged in users at that moment on sandbox.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan
Thank you. Is it possible to use a sql query to display the most recent odds? Because it might change during the day so we need a way to show most recent. Also we need to display advanced filters that show odds in decimal fractional or american which on covers changes the value in the cells. These are the type of filter options the have: http://take.ms/hfhTf
http://take.ms/RuXos
http://take.ms/A5UiD
from url: https://www.covers.com/Sports/NBA/Odds/INT/SPREAD/competition/Online/UK
Is it possible to build the same type of filters that when different options are chosen, the data changes? How does the data need to be structured in the mysql databse to achieve what we need? If I knew that then I can tell a developer how to build the data and what queries we need to put into the plugin.
I already bought the plugin Friday to play around with it and see how it works.
Hi Mark,
Yes it is possible with query that I provide to you in previous post and also you can set Sorting by that column on load so it will be display like you need.
We don't have such layout of the filters, but you can check all filters types in our documentation on this link.
Please take a look in attachment for detail explanation.
Please note that : Preparing data, writing queries is something that is out of scope of the standard support that we provide.
If you are buy our plugin and if you have issue or questions please open new tickets in wpdatatables category where you will insert your Purchase code for support. This is a Pre-purchase category where users have pre-sales questions and proposals.
Thank you for understanding.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan
Is there any possible way to create a dropdown with options that show: Decimal, Factional, American. Like a filter, when I choose say American, the odds in the table will display the American style odds in it? If not is there a workaround to achieve close to if not the same thing?
This is the last thing that we need to find a way to do with the plugin. The dropdowns (or anything) that can display data differently.
http://take.ms/hfhTf
Maybe with a bit of customization I can achieve this. Like is there is a way to load different tables by dropdown? Or organize the data in a certain way that every option in the custom dropdown is linked to a different sql query, therefore when you choose say Amercian odds, the table will display the data according to the sql query thats linked to this select option.
Hi Mark,
Unfortunately yours two last request are not possible to achieve with built in features of wpdatatables.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan
Then I cannot use this plugin. There is no way to combine this plugin with another plugin or use custom javascript within the plugin to achieve what we need?
If you can just point me kind of the in the right direction please. I am also willing purchase support if its offered or have what we need developed. I just need to know what direction to go in (different sql requests made by a button, a button that loads different shortcodes when its clicked on or checked). Im not sure what to combine with the plugin to get it to work or if I need someone to develop my own solution for scratch.
Hi Mark,
Functionally that you need is not possible to achieve with built features of plugin.
Please note that customization questions like this one are not covered in the included support or in pre-purchase category questions for the plugin. Included support covers help with bugs and general inquiries for the plugin features, but not writing custom code. As you're developing some custom solution if you need our assistance we can offer you our paid customization service.
Unfortunately, at the moment we don't have available developers which can do this customization for you, because there is a lot of priority task that have to be done.
Thank you for understanding.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables