This thread is resolved. Here is a description of the problem and solution.
Problem:
How to setup SQL query to query many2many relationships that has an intermediary with fields.
Solution:
We don't provide the customize SQL query support, but you can still get the detail SQL query by these:
1) Create many-to-many relationship between two post types
2) Create a view to retrieve the related posts
https://toolset.com/documentation/post-relationships/how-to-display-related-posts-with-toolset/#displaying-many-related-items
OR Use Post relationship API to retrieve the related posts in your website
https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_get_related_post_types
3) Dashboard-> Toolset-> Settings-> Front-end Content
Enable option "Enable Views debug mode", and option "Full debug mode",
Run those page/post of step2), then you will be able to get those SQL query in details.
And you can also install other plugins to get the SQL query details, for example:
https://wordpress.org/plugins/search/query+monitor/
Relevant Documentation:
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| - | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | - |
| - | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | - |
Supporter timezone: Asia/Hong_Kong (GMT+08:00)
This topic contains 2 replies, has 2 voices.
Last updated by 6 years, 4 months ago.
Assisted by: Luo Yang.
