The Pods Framework is a Content Development Framework for WordPress - It lets you create and extend content types that can be used for any project. Add fields of various types we've built in, or add your own with custom inputs, you have total control.
In the settings of a relationship field connected to Users it is possible to restrict the query to show Users with specific roles. However on opening the pod item with this relationship field connected to multiple users I get errors like these:
Database Error; SQL: SELECT DISTINCT t.ID, t.display_name FROM wpop_users AS t LEFT JOIN wpop_pods_user AS d ON d.id = t.ID WHERE ( wpop_capabilities.meta_value LIKE "%\"mentor\"%" OR wpop_capabilities.meta_value LIKE "%\"contactpersoon\"%" OR wpop_capabilities.meta_value LIKE "%\"administrator\"%" ) ORDER BY t.display_name, t.ID; Response: Unknown column 'wpop_capabilities.meta_value' in 'where clause'
Database Error; SQL: SELECT DISTINCT t.ID, t.display_name FROM wpop_users AS t LEFT JOIN wpop_pods_user AS d ON d.id = t.ID WHERE ( wpop_capabilities.meta_value LIKE "%\"author\"%" ) ORDER BY t.display_name, t.ID LIMIT 0, 30; Response: Unknown column 'wpop_capabilities.meta_value' in 'where clause'
I user the Members plugin to create different roles and to restrict content to different roles. I cannot test this behaviour in my current website. I guess it should be tested in an empty new site.
Version
2.9.9
Testing Instructions
Create a pod with a relationship field to Users
(And create a relationship field in Pods Users to connect with this pod)
Set both to Multiple select
Screenshots / Screencast
Possible Workaround
Don't use the filter, and just use "auto complete" to select users in editor
Description
In the settings of a relationship field connected to Users it is possible to restrict the query to show Users with specific roles. However on opening the pod item with this relationship field connected to multiple users I get errors like these:
Database Error; SQL: SELECT DISTINCT
t
.ID
,t
.display_name
FROMwpop_users
ASt
LEFT JOINwpop_pods_user
ASd
ONd
.id
=t
.ID
WHERE (wpop_capabilities
.meta_value
LIKE "%\"mentor\"%" ORwpop_capabilities
.meta_value
LIKE "%\"contactpersoon\"%" ORwpop_capabilities
.meta_value
LIKE "%\"administrator\"%" ) ORDER BYt
.display_name
,t
.ID
; Response: Unknown column 'wpop_capabilities.meta_value' in 'where clause'Database Error; SQL: SELECT DISTINCT
t
.ID
,t
.display_name
FROMwpop_users
ASt
LEFT JOINwpop_pods_user
ASd
ONd
.id
=t
.ID
WHERE (wpop_capabilities
.meta_value
LIKE "%\"author\"%" ) ORDER BYt
.display_name
,t
.ID
LIMIT 0, 30; Response: Unknown column 'wpop_capabilities.meta_value' in 'where clause'I user the Members plugin to create different roles and to restrict content to different roles. I cannot test this behaviour in my current website. I guess it should be tested in an empty new site.
Version
2.9.9
Testing Instructions
Create a pod with a relationship field to Users (And create a relationship field in Pods Users to connect with this pod) Set both to Multiple select
Screenshots / Screencast
Possible Workaround
Don't use the filter, and just use "auto complete" to select users in editor
Site Health Information
Pods Package
No response