Ian Sadovy

Glad to hear it works.
Actually, $user_id is replaced with current WP User ID (get_current_user_id). From your table I see that id is a primary key for wpje_give_donors table (not a user id). And user key associated with this record is user_id. So, changing your query as following may help:
... WHERE user_id = $user_id

Hope it helps.

Regards,
Ian

Simphiwe,

Thank you for the answer and sorry for the trouble.
Seems I have finally found the error and already published a fix.
Please update WPTables to 1.3.8 and let me know if it works well now.

Regards,
Ian

Thanks for the video.
Looks really strange. Could you please try this simple query?
SELECT * FROM wpje_give_donors WHERE id = $user_id
Maybe there is some conflict with user_id field in the SELECT.

Look forward to hearing from you.

Ian

Hello Simphiwe,

Have you updated the WPTables to the latest version?
Here is how I do this with my setup – https://take.ms/CeKoq

Please let me know if it works for you.

Regards,
Ian

Hello @skylined87,

Thank you for the question.
As an option, you can set a fixed width to the Review column (https://take.ms/xyDJQ), so other columns will have more space and will adjust automatically. But, please note that it may not work with width: auto !important style, so try removing !important.

Hope it helps.

Regards,
Ian

Hello Simphiwe,

Thank you for the question.
I see that this feature is quite needed, so I just have added it to the WPTables 1.3.7.
Please update and try predefined variable $user_id as following:
SELECT * FROM users WHERE ID = $user_id
Also, you can use wptables_mysql_query filter to modify MySQL query in your own way using PHP.

Please let me know if it helps you.

Regards,
Ian

Hello @quazy,

I just have published WPTables 1.3.7 with support for MySQL variables.
Please update and try predefined variable $user_id as following:
SELECT * FROM users WHERE ID = $user_id
Also, you can use wptables_mysql_query filter to modify MySQL query in your own way using PHP.

Please let me know if it works for you.

Regards,
Ian

Hello @rachelleanita,

Thank you for the request.
Editors access to WPTables sounds reasonable, so I have published an update that allows doing so by default. You are welcome to update.

Please let me know if it works well for you.

Regards,
Ian

Hello @lighterv,

Thank you for the question.
Please use the following CSS to hide scrollbards:

.jsgrid-grid-body { overflow-x: hidden; overflow-y: hidden; }
.jsgrid-grid-header { overflow-x: hidden; overflow-y: hidden; }

Hope it helps.

Regards,
Ian

Hello @wahlborg,

Thank you for the request.
It seems that WPTables is installed correctly, but there is a compatibility issue with other plugins you may have installed. You can try to disable all plugins and then check if the WPTables works well. Then, you can enable plugins one by one to find what is causing the issue. It can help to reproduce and resolve compatibility problem.
Hope it helps.

Regards,
Ian

Hello @quazy,

Sorry for the late reply.
Currently, there is no such option, you can use only pure SQL.
But it sounds like a good idea for improvement. I will add this to my backlog.

Hope it helps.

Regards,
Ian

Thanks for the feedback!
Regarding scrollbars, please add the following CSS to hide scrollbards:

.jsgrid-grid-body { overflow-x: hidden; overflow-y: hidden; }
.jsgrid-grid-header { overflow-x: hidden; overflow-y: hidden; }

Hope it helps.

Hello @imranvirk,

Thank you for the question.
I guess Allow Selecting and Show Header options will do the trick for you – https://take.ms/8Rrvi

Please let me know if it works.

Regards,
Ian

Phelan,

Thanks, I will take a look at it.

Hello @abdada,

Thank you for the feedback.
As for the calculated columns, it sounds interesting. I will add this to my backlog for further investigation.

BTW, since you are using MySQL, have you looked at the option of Generated Columns?

Regards,
Ian