I have a table of customer sales history information and want to pre-filter what the customer can see by their customer number or other associated data, IS this possible and if so in a responsive table design with 2 levels of data would the same filter automatically apply to the 2nd level of data?
If your customers are logging into WordPress, and you have their User ID in that list, you could utilize our feature "Users see and edit only own data", so they can only see and edit the data linked to their User ID. If you don't want the table to be editable, we can help you hide the editing functions.
By 2nd level of data, you mean the Responsiveness feature? Please take a look at the examples in our documentation, and let me know if this is what you had in mind?
If so, then yeah - the collapsed columns can also be filtered. The results would only be visible on click.
Aleksandar our customer would be logging into our site to review their order status, we would have a CustId at the the time of accounts create and would like to filter that they see by their CustId and Facility, just in case we have a need to show Multiple facilities to a customer, But we do not allow edits, it is ready only.
I trust you are being safe and your family is well during these weird times. I am looking at utilizing WPEverest registration plugin on my site for customer registration. We will have a unique numerical field with the customer number, call it AddressBookId. Does your Plugin work with WPEverst in that i can use your plug in over their user management to filter the data that the customer is supposed to see?
Ideally i would like to filter the data from the customer login in by the cust AdressBookId, and use the WPEverest User Management Plugin to register the user unless you can recommend something else.
I am not familiar with this plugin, so I don't know how their data is stored, but if you know your way around MySQL, you will be able to pull the data you need.
Even if you don't know SQL that well, you can try using our query constructor which can help you with this.
Please note that MySQL query constructor is not an ‘ultimate generator’, it should be treated as helper for constructing a suggestion of a query, by trying to ‘guess’ what you want. We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need. Play around with the resulting query to achieve better results.
I have a table of customer sales history information and want to pre-filter what the customer can see by their customer number or other associated data, IS this possible and if so in a responsive table design with 2 levels of data would the same filter automatically apply to the 2nd level of data?
Hello Mark
Thank you for your interest in our plugin.
If your customers are logging into WordPress, and you have their User ID in that list, you could utilize our feature "Users see and edit only own data", so they can only see and edit the data linked to their User ID. If you don't want the table to be editable, we can help you hide the editing functions.
By 2nd level of data, you mean the Responsiveness feature? Please take a look at the examples in our documentation, and let me know if this is what you had in mind?
If so, then yeah - the collapsed columns can also be filtered. The results would only be visible on click.
Kind Regards,
Aleksandar Vuković
[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
Aleksandar our customer would be logging into our site to review their order status, we would have a CustId at the the time of accounts create and would like to filter that they see by their CustId and Facility, just in case we have a need to show Multiple facilities to a customer, But we do not allow edits, it is ready only.
Hi again Mark
If you don't allow editing, you can simply hide the "Add new", "Edit" and "Delete" buttons using custom CSS, which you can see on this link.
Kind Regards,
Aleksandar Vuković
[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
Aleksander hello again,
I trust you are being safe and your family is well during these weird times. I am looking at utilizing WPEverest registration plugin on my site for customer registration. We will have a unique numerical field with the customer number, call it AddressBookId. Does your Plugin work with WPEverst in that i can use your plug in over their user management to filter the data that the customer is supposed to see?
Ideally i would like to filter the data from the customer login in by the cust AdressBookId, and use the WPEverest User Management Plugin to register the user unless you can recommend something else.
thank you.
Hi again Mark
I am not familiar with this plugin, so I don't know how their data is stored, but if you know your way around MySQL, you will be able to pull the data you need.
Even if you don't know SQL that well, you can try using our query constructor which can help you with this.
Please note that MySQL query constructor is not an ‘ultimate generator’, it should be treated as helper for constructing a suggestion of a query, by trying to ‘guess’ what you want. We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need. Play around with the resulting query to achieve better results.
Kind Regards,
Aleksandar Vuković
[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