Hi, sorry if this question has been asked before I couldn't find a related ticket.
I'm trying to use %CURRENT_USER_LOGIN% in the sql query so that the table will only show said user's data in the table. The values of the column "PRODUCTOR" are the same as the user login.
is not something more complex than that, but it gives me this warning
Previously I was trying to use the placeholder option, where I defined the "Predefined Values" cell as %CURRENT_USER_LOGIN% and it works so long as nobody uses the "clean the filters" option, then this value dissapears and all the table values are shown.
It is important that users dont see other users data.
If you can help me with the correct syntax, I would appreciate it
It might be tricky to determine exactly the issue with this SQL Query,
i will ask for help from our 2nd level Team if needed;
but it will be much easier, if we go back to using the filter, as before - but i can help you hide the "Clear Filter" , or i can help you hide the filter, for a specific column, with CSS, if you wish ?
Then users won't be able to use it.
Let me know if that can be a solution ?
Could you also show me a screenshot or a video of how the tables looks - and elaborate a bit more on what kind of a filter setup you need;
do you need some filters to be available, along with "clear filters", if that is crucial? Thank you
Hi, sorry if this question has been asked before I couldn't find a related ticket.
I'm trying to use %CURRENT_USER_LOGIN% in the sql query so that the table will only show said user's data in the table. The values of the column "PRODUCTOR" are the same as the user login.
is not something more complex than that, but it gives me this warning
Previously I was trying to use the placeholder option, where I defined the "Predefined Values" cell as %CURRENT_USER_LOGIN% and it works so long as nobody uses the "clean the filters" option, then this value dissapears and all the table values are shown.
It is important that users dont see other users data.
If you can help me with the correct syntax, I would appreciate it
Best Regards
Augusto
Hi, Augusto
Sorry for the delay
It might be tricky to determine exactly the issue with this SQL Query,
i will ask for help from our 2nd level Team if needed;
but it will be much easier, if we go back to using the filter, as before - but i can help you hide the "Clear Filter" , or i can help you hide the filter, for a specific column, with CSS, if you wish ?
Then users won't be able to use it.![smile.png](https://assets.ticksy.com/app/_theme/shared_assets/redactor2/emoticons/emoticons/smile.png)
Let me know if that can be a solution ?
Could you also show me a screenshot or a video of how the tables looks - and elaborate a bit more on what kind of a filter setup you need;
do you need some filters to be available, along with "clear filters", if that is crucial? Thank you
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