1. - We exported an example from your site as CSV file, and made a test Word Press page, to see if we can replicate what you need.
- Could you try to add this key after the URL :
?wdt_column_filter[userid]=1.441.881.735.843.104
( The URL key that will be parsed by the wpDataTables is “wdtColumnFilter[KEY]” where the KEY inside the square brackets is either a zero-based numerical index of the column you want to filter or an initial header of the column (or MySQL column header)) ;
Here are screenshots of how we successfully made a test page with URL filter, we just edited the values a bit, to have a different User ID to work with, as you can see.
On the first image, there is just the regular page with all the data.
And here we used the URL filter key for the column "userid" , with value of 1.441.881.735.843.102 , as you can see.
- Try our suggestion, see if it works.
Contact us if still not resolved, or if this is not what you intended to achieve.
2.
To remove the SUM/Total symbol, you need to open and edit a little bit of code from three files, using any text editor of your choice, find them inside your WordPress folder :
Hello, I have two questions:
1 - I would like to use the URL to filter the contents of the table and only include the data for the specified UserID. I created this URL:
https://worldofwalt.com/wowfun-my-points.html?wdt_Column_Filter[UserID]=1441881735843105
The table displays data from all UserIDs. Can you let me know how to format the URL to display only data for UserIDs specified in the URL parameter?
2 - I included the short code to provide a total of points.
Your total points: [wpdatatable_sum table_id=3 col_id=28]The calculation appears to work correctly, but displays as:
YOUR TOTAL POINTS:∑ = 7Is there a way to delete this part:
∑ =Thank you!
Herb
Hi, Herb
Thank you for your purchase.
1. - We exported an example from your site as CSV file, and made a test Word Press page, to see if we can replicate what you need.
- Could you try to add this key after the URL :
( The URL key that will be parsed by the wpDataTables is “wdtColumnFilter[KEY]” where the KEY inside the square brackets is either a zero-based numerical index of the column you want to filter or an initial header of the column (or MySQL column header)) ;
- I suppose all of the values in your UserID column have this format, with "dots and numbers", so let's say you have a value like 1441881735843105 , maybe try like this for the full URL - https://worldofwalt.com/wowfun-my-points.html?wdt_column_filter[userid]=1.441.881.735.843.105
Here are screenshots of how we successfully made a test page with URL filter, we just edited the values a bit, to have a different User ID to work with, as you can see.
On the first image, there is just the regular page with all the data.
And here we used the URL filter key for the column "userid" , with value of 1.441.881.735.843.102 , as you can see.
- Try our suggestion, see if it works.
Contact us if still not resolved, or if this is not what you intended to achieve.
2.
To remove the SUM/Total symbol, you need to open and edit a little bit of code from three files, using any text editor of your choice, find them inside your WordPress folder :
- The PHP file :
../wp-content/plugins/wpdatatables/controllers/wdt_functions.php
use "CTRL+F" in the editor, to search for this : " #8721 "
You will find part of a line that looks like this :
- Just remove "& #8721; = " from the end, so it looks like this:
- Do the same for this Javascript file,
which is located here :
/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wpdatatables.js
you will find something like this :
Once "& #8721; = " is removed, should look like this :
- Same with this PHP file :
wp-content/plugins/wpdatatables/templates/frontend/table_footer.inc.php
;
Once you are finished, the SUM/Total symbol should be gone from the Front End.
Also, make sure to disable "Use minified wpDataTables Javascript" slider in wpDataTables settings/Custom JS and CSS tab, as on this screenshot :
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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