Hey everyone!
With the holiday season upon us, we want to share our upcoming working hours:
- New Year: Our team will be off on January 1st and 2nd. We’ll be back on Friday, January 3rd, to respond to any messages received during this time.
- Weekend: As usual, we don’t work on weekends, so January 4th and 5th will also be non-working days.
- Orthodox Christmas: Our office will be closed on Monday and Tuesday, January 6th and 7th for the holiday.
After that, we’ll return to our regular schedule and assist you as quickly as possible.
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.
Thanks a bunch for your understanding and support!
Warm regards and happy holidays!
TMS
My database has records in it that are both "active" and "inactive". I want to be able to show, on the front end, only the "active" records. I can accomplish this with the filters; however, I do not want the filter for that column shown on the front end. Is there any way to hide this filter, or is there another way to only display the "active" records? I don't want people being able to look at inactive records, and at times, they may become active again and then would show on the page when necessary.
Hi Kevin,
Yes, there can be two ways to do this.
1. You can hide a specific Column Filter from the front-end with some custom CSS added in the "Customize" section of the main table settings.
- It should be easy to do, depending on your knowledge of HTML and CSS.
You have to find the correct selector using the browser inspector tool, add the style "display:none" property to it, and it will disappear from the front-end.
On our example table, the custom CSS is :
- Now, the user_ID filter is gone from the front-end.
On your Table, if that will be the first Column Filter, then you can try this :
I tried it now, and it has hidden your "A-Z index" filter since that one is currently the first on the Page.
So basically, all these class names for the filters start as :
#table_1_1_filter_sections
#table_1_2_filter_sections
#table_1_3_filter_sections
and so on... So you just need to 'pick out' the right one for the CSS selector.
Now you can just add the CSS in the Table's Customize/Custom CSS and it should work.
2. Another way, if you use an SQL Query based Table,
you could make an additional SQL Table which will just serve for this Page to filter it before load,
then add a "WHERE" statement to your Query, for example :
Of course, if you need all columns, just do "SELECT * FROM" instead of naming each Column,
and check what is the Origin Header Name for the Column that holds your 'active' and 'inactive' values.
This way the SQL Table will just load the active values during load and there is no way for any user to change it on any filter.
So you can even disable the filter on that Column for front-end because the SQL Query will already just pull the ones you need.
I hope that helps.
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
That worked beautifully!! Thank you very much!
Hi Kevin,
Just following up.
I am delighted to hear that this has been resolved. Thank you for letting us know.
Apologies for the waiting time on your other remaining ticket, we will get to it as quickly as possible.
And of course, if anything else comes up, please don't hesitate to open new additional tickets as well.
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