I'm using tables for a portal I'm building where users are only allowed to see their own data. I am also using foreign keys to display data from one table as a selectbox on another table on the next page. However, in the table that contains the foreign key, users can select data from the whole table, not just the data that they can see based on their user ID. Is there a way to display only the data that's tied to their user ID in the second table?
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also send me a link of page that you have this issue and point me to the table id which you use there, so i can investigate.
Hi, friend of Bryan here. I'd like to back up everything he's saying. We have spent several hours today trying to resolve this issue. To reiterate: in tables with ids 8, 9, and 10 all have the setting "user can see and edit their own data" turned on. The column with a foreign key relation in tables 9 and 10 still is bringing in all the data from table 8 and not just the data associated with that user. Whatever SQL query is used to bring in the data from table 8 is not taking into account the current user, but rather is bringing in all unique values from that table. We have tried this in the site without the use of wp-client and having the same issues. Please advise.
In all tables "Users see and edit only own data" is turn on and the "User ID column" is set to userid.
When you're logged in with user marissa, userid for that is 1, so you only see rows with that value. I add two more rows with same userid and you can check all rows with userid=1 are shown. (attachment 1)
When you're logged in with user bloomis47, userid for that is 2, so you only see rows with that value. You can check that on portal. (attachment 2)
The problem isn't with the rows that are displaying, but rather that the column with a foreign key relation in tables 9 and 10 (column called vehicleownername) still is bringing in all the data from table 8 and not just the data associated with that user. Whatever SQL query is used to bring in the data from table 8 is not taking into account the current user, but rather is bringing in all unique values from that table.
"Whatever SQL query is used to bring in the data from table 8 is not taking into account the current user, but rather is bringing in all unique values from that table."
- Soory can you explain this with some screenshots of that what you mean?
Yes, that attachment is exactly what I'm talking about. It's bringing in all the values (Pat Johnson Trucking, Jeffries Service Fleet, Arnold & Co, etc) from table 8 as shown in your screenshot below, but it should only bring in values that are assigned a user id of 1, which in table 8 is "Pat Johnson Trucking" only. I've attached a screenshot that shows table 8 and the vehicle owners with their user ids. So to summarize, tables 9 and 10 are displaying all values in the selectbox when a foriegn key relationship is used, not just the values associated with that user. Make sense?
I'd like to get this resolved today - I don't want this to keep dragging on for weeks. Is there anyone I could speak to on the phone today to work on this with?
Sorry for misunderstanding all these days,we finally figure out what's bothering you. That is not possible with build in features of plugin. When you use foreign key in table on some column and choose filter to select box for that column it will be return all the unique data form first table which you want to connect, no matter if you use Users see and edit only own data or not. I will forward this to my team to consider this like feature in next major update.
That's unacceptable - I bought this plugin for these features, and I expect them to be compatible with each other. Who else can I speak to about getting this functionality working as soon as possible?
I'm using tables for a portal I'm building where users are only allowed to see their own data. I am also using foreign keys to display data from one table as a selectbox on another table on the next page. However, in the table that contains the foreign key, users can select data from the whole table, not just the data that they can see based on their user ID. Is there a way to display only the data that's tied to their user ID in the second table?
Hi Bryan,
Thank you for your purchase.
Can you check in the table with foreign keys is ti turn on "Users see and edit only own data" in EDITING tab in table settings?
Thank you
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
Yes, both tables have that setting turned on.
Hi Bryan,
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also send me a link of page that you have this issue and point me to the table id which you use there, so i can investigate.
Thank you
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 Bryan,
I can see in the table with id =10 you don't have turn on "Users see and edit only own data".
Can you change this and tell me is it working.
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
Okay, I've change table id=10 to allow users to only see and edit their own data, but it's still not working.
Hi Bryan,
Can you please try to make these tables on page or post without using wp-client plugin and see is it working?
I think that you have these issue because of the conflict with that plugin.
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
I gave it a try on the main site without using the wp-client plugin and had the same result.
Hi, friend of Bryan here. I'd like to back up everything he's saying. We have spent several hours today trying to resolve this issue. To reiterate: in tables with ids 8, 9, and 10 all have the setting "user can see and edit their own data" turned on. The column with a foreign key relation in tables 9 and 10 still is bringing in all the data from table 8 and not just the data associated with that user. Whatever SQL query is used to bring in the data from table 8 is not taking into account the current user, but rather is bringing in all unique values from that table. We have tried this in the site without the use of wp-client and having the same issues. Please advise.
Hi Bryan,
In all tables "Users see and edit only own data" is turn on and the "User ID column" is set to userid.
When you're logged in with user marissa, userid for that is 1, so you only see rows with that value. I add two more rows with same userid and you can check all rows with userid=1 are shown. (attachment 1)
When you're logged in with user bloomis47, userid for that is 2, so you only see rows with that value. You can check that on portal. (attachment 2)
Please tell me is this what are you looking for.
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
The problem isn't with the rows that are displaying, but rather that the column with a foreign key relation in tables 9 and 10 (column called vehicleownername) still is bringing in all the data from table 8 and not just the data associated with that user. Whatever SQL query is used to bring in the data from table 8 is not taking into account the current user, but rather is bringing in all unique values from that table.
Hi Brayan,
"Whatever SQL query is used to bring in the data from table 8 is not taking into account the current user, but rather is bringing in all unique values from that table."
- Soory can you explain this with some screenshots of that what you mean?
Did you mean in value from filter? (attachment)
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
Yes, that attachment is exactly what I'm talking about. It's bringing in all the values (Pat Johnson Trucking, Jeffries Service Fleet, Arnold & Co, etc) from table 8 as shown in your screenshot below, but it should only bring in values that are assigned a user id of 1, which in table 8 is "Pat Johnson Trucking" only. I've attached a screenshot that shows table 8 and the vehicle owners with their user ids. So to summarize, tables 9 and 10 are displaying all values in the selectbox when a foriegn key relationship is used, not just the values associated with that user. Make sense?
I'd like to get this resolved today - I don't want this to keep dragging on for weeks. Is there anyone I could speak to on the phone today to work on this with?
Hi Bryan,
Sorry for misunderstanding all these days,we finally figure out what's bothering you. That is not possible with build in features of plugin. When you use foreign key in table on some column and choose filter to select box for that column it will be return all the unique data form first table which you want to connect, no matter if you use Users see and edit only own data or not. I will forward this to my team to consider this like feature in next major update.
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
That's unacceptable - I bought this plugin for these features, and I expect them to be compatible with each other. Who else can I speak to about getting this functionality working as soon as possible?
Hi Bryan,
Sorry for late response. I forward this issue to my team to be a priority and they working on it.
We understand that you are in a hurry so it will be as soon as possible.
Thank you for your patience.
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