I WANT TO KNOW IF I CAN QUERY AN UPLOADED XLS SO THAT IT DISPLAYS A SUBSET OF THE ROWS, FILTERED BY A UNIQUE IDENTIFIER, IF FOUND IN A SPECIFIC COLUMN. THE SPECIFIC STRING OR NUMBER IS AN ACCOUNT NUMBER OR WORDPRESS LOGIN ID.
THE USE CASE IS: 1. CUSTOMER LOGS IN WITH THEIR ACCOUNT ID 2. UPON LOGIN, THE CUSTOMER IS TAKEN TO A PAGE THAT DISPLAYS ALL OF THE ROWS IN THE TABLE THAT CONTAIN THEIR ACCOUNT ID
3. CUSTOMER CAN THEN ENTER ADDITIONAL SEARCH CRITERIA TO LOCATE ANY SPECIFIC ROWS THAT CONTAIN THE SEARCH CRITERIA
- The user_ID filter is still visible, which means, if someone changes/deletes this value, they could see the whole table.
We will hide it 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 :
#table_1_5_filter_sections {
display:none; }
- Now, the user_ID filter is gone from the front-end.
- Optionally, you can hide the user_id column from the front-end, if needed, either using the column settings tab or the "column list" button from the back end Admin area.
- If you need more details about this, don't hesitate to contact us further.
Let me know if that helps.
And i just wanted to point out that you can try wpDataTables before purchasing
on our sandbox Demo sites ( you can find links for the main plugin Demo,
as well as add-on Demos, in my signature),
and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)
I WANT TO KNOW IF I CAN QUERY AN UPLOADED XLS SO THAT IT DISPLAYS A SUBSET OF THE ROWS, FILTERED BY A UNIQUE IDENTIFIER, IF FOUND IN A SPECIFIC COLUMN. THE SPECIFIC STRING OR NUMBER IS AN ACCOUNT NUMBER OR WORDPRESS LOGIN ID.
THE USE CASE IS:
1. CUSTOMER LOGS IN WITH THEIR ACCOUNT ID
2. UPON LOGIN, THE CUSTOMER IS TAKEN TO A PAGE THAT DISPLAYS ALL OF THE ROWS IN THE TABLE THAT CONTAIN THEIR ACCOUNT ID
3. CUSTOMER CAN THEN ENTER ADDITIONAL SEARCH CRITERIA TO LOCATE ANY SPECIFIC ROWS THAT CONTAIN THE SEARCH CRITERIA
Hi, DANIEL MEZICK.
Thanks for reaching out to us.
-
Yes, you can use predefined filtering in our tables columns.
For server-side tables/SQL based, like Manual and SQL Query based tables,
we have this user friendly built-in option,
Creating Editable Tables in WordPress where users can see and edit only their own data.
-
For tables which are linked to source data such as XLS, we have a workaround,
to restrict only showing the rows for the currently logged-in user.
I will show you an example.
- First, you would have to add a custom "user_id" column on the source Excel side, which you can hide if needed in our plugin from the front-end.
We will add a predefined filter value to it, using a Place Holder "Current User ID";
- Check that the filter type is set as "Text", as shown on this screenshot.
- Here is how an example table linked to a source file looks before we make any changes, with visible filters above the table.
And now, when we set the pre-filter, with Administrator logged in ( In our case, the user ID is 1), we only see rows matching that user ID.
- (If you need more detailed information about using Place Holders in wpDataTables, here is our documentation about that https://wpdatatables.com/documentation/table-features/using-placeholders/);
- The user_ID filter is still visible, which means, if someone changes/deletes this value, they could see the whole table.
We will hide it 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.
- Optionally, you can hide the user_id column from the front-end, if needed, either using the column settings tab or the "column list" button from the back end Admin area.
- If you need more details about this, don't hesitate to contact us further.
Let me know if that helps.
And i just wanted to point out that you can try wpDataTables before purchasing
on our sandbox Demo sites ( you can find links for the main plugin Demo,
as well as add-on Demos, in my signature),
and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)
Let me know if you have any additional questions.
Kind Regards,
Miloš Jovanović
[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