Pulling students’ results from a table

Hi Andrew,

>>> Is it possible to do this with WP data access?

Absolutely!

Let’s say student results are store in table student_results. To link the results to a specific student, add a column – let’s say – student_wp_user_id. Make sure you store the WP User ID of a student in this column and add student_wp_user_id = $$USERID$$ to the default where clause of your publication or project. That’s all! ??

The only limitation is thay every student must have a WordPress user account.

Does this help?
Peter

Thank you so much Peter. That’s exactly what I was looking for. Are there any more $$ variables available from inside WP Data Access?

Cheersw
Andrew

Hi Andrew,

There is a old post which briefly describes available environment variables here:
https://wpdataaccess.com/2021/03/26/environment-variables/

Using these variables in filters is documented here:
https://wpdataaccess.com/docs/documentation/data-projects/adding-filters/

Additional information which might be interesting for your use case can be found here:
https://wpdataaccess.com/docs/documentation/data-projects/user-roles-and-where-clauses/

Let me if you need environment additional variables. I can add them! ??

Best regards,
Peter

Thank you Peter. You are so kind. Actually I am using it in what I hope will be a language learning website. Because of the way the learning tools are constructed and WP and the learning management system I am using are constructed I am not able to pull students’ scores and other information easily out of the WP database and display them. WP Data Access goes a long way toward solving that problem especially with its ability to incorporate sql queries and also javascript (I think- I have not looked in detail). I will happily review the information that you sent me on variables. I know it will be really helpful.

Best to you
Andrew