We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Learn more about funding links in repositories.
Report abuse
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
See https://wordpress.org/support/topic/how-to-use-the-where-in-a-relation-field/#post-18345167
Many magic tags ended up being blank when inspecting the WHERE queries on relationship fields via Query Monitor
3.2.8.1
See WP.org thread and attached config.json
No response
This has happened quite a few times... usually would fall back to filtering the SQL or WHERE via apply_filters and a reserved string / str_replace()
{ "@meta": { "version": "3.2.8.1", "build": 1741236612 }, "settings": { "types_only": "0", "watch_changed_fields": "0", "metadata_integration": "0", "metadata_override_get": "0", "register_meta_integration": "0", "media_modal_fields": "0", "session_auto_start": "0", "dynamic_features_allow": "1", "dynamic_features_enabled": [ "display", "form" ], "show_access_restricted_messages": "0", "show_access_admin_notices": "1", "dynamic_features_allow_sql_clauses": "all", "display_callbacks": "customized", "display_callbacks_allowed": "esc_attr,esc_html,current,item_three", "wisdom_opt_out": "1", "active_components": [ "advanced-content-types", "advanced-relationships", "migrate-packages", "templates" ] }, "pods": [ { "name": "hebr_conjugation", "id": 108, "label": "hebr_conjugation", "description": "", "type": "pod", "storage": "table", "label_singular": "hebr_conjugation", "public": "0", "show_ui": "1", "pod_index": "name", "_migrated_28": "1", "ui_style": "post_type", "show_in_menu": "1", "use_submenu_fallback": "0", "menu_position": "0", "ui_actions_enabled": [ "add", "edit", "duplicate", "delete" ], "ui_reorder_field": "menu_order", "ui_fields_manage": [ "name", "modified", "mainword" ], "ui_filters": [], "hierarchical": "0", "pod_parent": "parent", "dynamic_features_allow": "1", "restrict_dynamic_features": "0", "groups": [ { "name": "details", "id": 109, "label": "Details", "description": "", "weight": 0, "fields": [ { "name": "name", "id": 110, "label": "Name", "description": "", "weight": 0, "type": "text", "required": "1" }, { "name": "created", "id": 111, "label": "Date Created", "description": "", "weight": 1, "type": "datetime", "datetime_format": "ymd_slash", "datetime_time_type": "12", "datetime_time_format": "h_mm_ss_A" }, { "name": "modified", "id": 112, "label": "Date Modified", "description": "", "weight": 2, "type": "datetime", "datetime_format": "ymd_slash", "datetime_time_type": "12", "datetime_time_format": "h_mm_ss_A" }, { "name": "author", "id": 113, "label": "Author", "description": "", "weight": 3, "type": "pick", "pick_object": "user", "pick_format_type": "single", "pick_format_single": "autocomplete", "default_value": "{@user.ID}", "default_evaluate_tags": "1" }, { "name": "permalink", "id": 114, "label": "Permalink", "description": "Leave blank to auto-generate from Name", "weight": 4, "type": "slug" }, { "name": "mainword", "id": 123, "label": "mainword", "description": "", "weight": 5, "type": "pick", "pick_object": "pod", "pick_val": "hebr_word", "pick_format_type": "single", "pick_format_single": "dropdown", "pick_format_multi": "list", "pick_display_format_multi": "default", "pick_display_format_separator": ", ", "pick_allow_add_new": "1", "pick_taggable": "0", "pick_show_icon": "1", "pick_show_edit_link": "1", "pick_show_view_link": "1", "pick_limit": "0", "pick_user_role": "Administrator", "pick_sync_taxonomy": "0", "pick_sync_taxonomy_hide_taxonomy_ui": "0", "pick_post_status": "publish", "pick_post_author": "0", "repeatable": "0", "repeatable_format": "default", "default_evaluate_tags": "0", "default_empty_fields": "0", "roles_allowed": "administrator", "enable_conditional_logic": "0", "required": "0", "unique": "0", "sister_id": "122", "pick_display": "{@name}" } ] } ] }, { "name": "hebr_word", "id": 115, "label": "hebr_word", "description": "", "type": "pod", "storage": "table", "label_singular": "hebr_word", "public": "0", "show_ui": "1", "pod_index": "name", "_migrated_28": "1", "ui_style": "post_type", "show_in_menu": "1", "use_submenu_fallback": "0", "menu_position": "0", "ui_actions_enabled": [ "add", "edit", "duplicate", "delete" ], "ui_reorder_field": "menu_order", "ui_fields_manage": [ "name", "modified", "conjugation" ], "ui_filters": [], "groups": [ { "name": "details", "id": 116, "label": "Details", "description": "", "weight": 0, "fields": [ { "name": "name", "id": 117, "label": "Name", "description": "", "weight": 0, "type": "text", "required": "1", "text_allowed_html_tags": "strong em a ul ol li b i", "text_max_length": "255", "repeatable": "0", "repeatable_format": "default", "default_evaluate_tags": "0", "default_empty_fields": "0", "roles_allowed": "administrator", "enable_conditional_logic": "0", "unique": "0" }, { "name": "created", "id": 118, "label": "Date Created", "description": "", "weight": 1, "type": "datetime", "datetime_format": "ymd_slash", "datetime_time_type": "12", "datetime_time_format": "h_mm_ss_A" }, { "name": "modified", "id": 119, "label": "Date Modified", "description": "", "weight": 2, "type": "datetime", "datetime_format": "ymd_slash", "datetime_time_type": "12", "datetime_time_format": "h_mm_ss_A" }, { "name": "author", "id": 120, "label": "Author", "description": "", "weight": 3, "type": "pick", "pick_object": "user", "pick_format_type": "single", "pick_format_single": "autocomplete", "default_value": "{@user.ID}", "default_evaluate_tags": "1" }, { "name": "permalink", "id": 121, "label": "Permalink", "description": "Leave blank to auto-generate from Name", "weight": 4, "type": "slug" }, { "name": "conjugation", "id": 122, "label": "conjugation", "description": "", "weight": 5, "type": "pick", "pick_object": "pod", "pick_val": "hebr_conjugation", "pick_format_type": "multi", "pick_format_single": "dropdown", "pick_format_multi": "list", "pick_display_format_multi": "default", "pick_display_format_separator": ", ", "pick_allow_add_new": "1", "pick_taggable": "0", "pick_show_icon": "1", "pick_show_edit_link": "1", "pick_show_view_link": "1", "pick_limit": "0", "pick_user_role": "Administrator", "pick_sync_taxonomy": "0", "pick_sync_taxonomy_hide_taxonomy_ui": "0", "pick_post_status": "publish", "pick_post_author": "0", "repeatable": "0", "repeatable_format": "default", "default_evaluate_tags": "0", "default_empty_fields": "0", "roles_allowed": "administrator", "enable_conditional_logic": "0", "required": "0", "unique": "0", "sister_id": "123", "pick_where": "mainword.id = {@id}", "logged_in_only": "0", "admin_only": "0", "restrict_role": "0", "restrict_capability": "0", "hidden": "0", "read_only": "0" } ] } ] }, { "name": "hebrew_conj", "id": 126, "label": "Hebrew Conj", "description": "", "type": "post_type", "storage": "meta", "label_singular": "Hebrew Conj", "public": "1", "show_ui": "1", "publicly_queryable": "1", "dynamic_features_allow": "inherit", "rest_enable": "1", "supports_title": "1", "supports_editor": "1", "_migrated_28": "1", "groups": [ { "name": "more_fields", "id": 127, "label": "More Fields", "description": "", "weight": 0, "fields": [ { "name": "main_word", "id": 128, "label": "Main Word", "description": "", "weight": 0, "type": "pick", "pick_object": "post_type", "pick_val": "hebrew_word", "pick_format_type": "single", "pick_format_single": "dropdown", "pick_format_multi": "list", "pick_display_format_multi": "default", "pick_display_format_separator": ", ", "pick_allow_add_new": "1", "pick_taggable": "0", "pick_show_icon": "1", "pick_show_edit_link": "1", "pick_show_view_link": "1", "pick_limit": "0", "pick_user_role": "Administrator", "pick_sync_taxonomy": "0", "pick_sync_taxonomy_hide_taxonomy_ui": "0", "pick_post_status": "publish", "pick_post_author": "0", "repeatable": "0", "repeatable_format": "default", "default_evaluate_tags": "0", "default_empty_fields": "0", "roles_allowed": "administrator", "revisions_revision_field": "0", "enable_conditional_logic": "0", "rest_pick_response": "array", "rest_pick_depth": "1", "required": "0", "sister_id": "129" } ] } ] }, { "name": "hebrew_word", "id": 124, "label": "Hebrew Word", "description": "", "type": "post_type", "storage": "meta", "label_singular": "Hebrew Word", "public": "1", "show_ui": "1", "publicly_queryable": "1", "dynamic_features_allow": "1", "rest_enable": "0", "supports_title": "1", "supports_editor": "1", "_migrated_28": "1", "show_in_menu": "1", "menu_position": "0", "show_in_nav_menus": "1", "show_in_admin_bar": "1", "supports_quick_edit": "1", "restrict_dynamic_features": "0", "groups": [ { "name": "more_fields", "id": 125, "label": "More Fields", "description": "", "weight": 0, "fields": [ { "name": "conjugations", "id": 129, "label": "Conjugations", "description": "", "weight": 0, "type": "pick", "pick_object": "post_type", "pick_val": "hebrew_conj", "pick_format_type": "multi", "pick_format_single": "dropdown", "pick_format_multi": "list", "pick_display_format_multi": "default", "pick_display_format_separator": ", ", "pick_allow_add_new": "1", "pick_taggable": "0", "pick_show_icon": "1", "pick_show_edit_link": "1", "pick_show_view_link": "1", "pick_limit": "0", "pick_user_role": "Administrator", "pick_sync_taxonomy": "0", "pick_sync_taxonomy_hide_taxonomy_ui": "0", "pick_post_status": "publish", "pick_post_author": "0", "repeatable": "0", "repeatable_format": "default", "default_evaluate_tags": "0", "default_empty_fields": "0", "roles_allowed": "administrator", "revisions_revision_field": "0", "enable_conditional_logic": "0", "rest_pick_response": "array", "rest_pick_depth": "1", "required": "0", "pick_where": "main_word.post_title = {@post_title}", "sister_id": "128" } ] } ] } ] }
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Description
See https://wordpress.org/support/topic/how-to-use-the-where-in-a-relation-field/#post-18345167
Many magic tags ended up being blank when inspecting the WHERE queries on relationship fields via Query Monitor
Version
3.2.8.1
Testing Instructions
See WP.org thread and attached config.json
Screenshots / Screencast
No response
Possible Workaround
This has happened quite a few times... usually would fall back to filtering the SQL or WHERE via apply_filters and a reserved string / str_replace()
Site Health Information
Pods Package
{ "@meta": { "version": "3.2.8.1", "build": 1741236612 }, "settings": { "types_only": "0", "watch_changed_fields": "0", "metadata_integration": "0", "metadata_override_get": "0", "register_meta_integration": "0", "media_modal_fields": "0", "session_auto_start": "0", "dynamic_features_allow": "1", "dynamic_features_enabled": [ "display", "form" ], "show_access_restricted_messages": "0", "show_access_admin_notices": "1", "dynamic_features_allow_sql_clauses": "all", "display_callbacks": "customized", "display_callbacks_allowed": "esc_attr,esc_html,current,item_three", "wisdom_opt_out": "1", "active_components": [ "advanced-content-types", "advanced-relationships", "migrate-packages", "templates" ] }, "pods": [ { "name": "hebr_conjugation", "id": 108, "label": "hebr_conjugation", "description": "", "type": "pod", "storage": "table", "label_singular": "hebr_conjugation", "public": "0", "show_ui": "1", "pod_index": "name", "_migrated_28": "1", "ui_style": "post_type", "show_in_menu": "1", "use_submenu_fallback": "0", "menu_position": "0", "ui_actions_enabled": [ "add", "edit", "duplicate", "delete" ], "ui_reorder_field": "menu_order", "ui_fields_manage": [ "name", "modified", "mainword" ], "ui_filters": [], "hierarchical": "0", "pod_parent": "parent", "dynamic_features_allow": "1", "restrict_dynamic_features": "0", "groups": [ { "name": "details", "id": 109, "label": "Details", "description": "", "weight": 0, "fields": [ { "name": "name", "id": 110, "label": "Name", "description": "", "weight": 0, "type": "text", "required": "1" }, { "name": "created", "id": 111, "label": "Date Created", "description": "", "weight": 1, "type": "datetime", "datetime_format": "ymd_slash", "datetime_time_type": "12", "datetime_time_format": "h_mm_ss_A" }, { "name": "modified", "id": 112, "label": "Date Modified", "description": "", "weight": 2, "type": "datetime", "datetime_format": "ymd_slash", "datetime_time_type": "12", "datetime_time_format": "h_mm_ss_A" }, { "name": "author", "id": 113, "label": "Author", "description": "", "weight": 3, "type": "pick", "pick_object": "user", "pick_format_type": "single", "pick_format_single": "autocomplete", "default_value": "{@user.ID}", "default_evaluate_tags": "1" }, { "name": "permalink", "id": 114, "label": "Permalink", "description": "Leave blank to auto-generate from Name", "weight": 4, "type": "slug" }, { "name": "mainword", "id": 123, "label": "mainword", "description": "", "weight": 5, "type": "pick", "pick_object": "pod", "pick_val": "hebr_word", "pick_format_type": "single", "pick_format_single": "dropdown", "pick_format_multi": "list", "pick_display_format_multi": "default", "pick_display_format_separator": ", ", "pick_allow_add_new": "1", "pick_taggable": "0", "pick_show_icon": "1", "pick_show_edit_link": "1", "pick_show_view_link": "1", "pick_limit": "0", "pick_user_role": "Administrator", "pick_sync_taxonomy": "0", "pick_sync_taxonomy_hide_taxonomy_ui": "0", "pick_post_status": "publish", "pick_post_author": "0", "repeatable": "0", "repeatable_format": "default", "default_evaluate_tags": "0", "default_empty_fields": "0", "roles_allowed": "administrator", "enable_conditional_logic": "0", "required": "0", "unique": "0", "sister_id": "122", "pick_display": "{@name}" } ] } ] }, { "name": "hebr_word", "id": 115, "label": "hebr_word", "description": "", "type": "pod", "storage": "table", "label_singular": "hebr_word", "public": "0", "show_ui": "1", "pod_index": "name", "_migrated_28": "1", "ui_style": "post_type", "show_in_menu": "1", "use_submenu_fallback": "0", "menu_position": "0", "ui_actions_enabled": [ "add", "edit", "duplicate", "delete" ], "ui_reorder_field": "menu_order", "ui_fields_manage": [ "name", "modified", "conjugation" ], "ui_filters": [], "groups": [ { "name": "details", "id": 116, "label": "Details", "description": "", "weight": 0, "fields": [ { "name": "name", "id": 117, "label": "Name", "description": "", "weight": 0, "type": "text", "required": "1", "text_allowed_html_tags": "strong em a ul ol li b i", "text_max_length": "255", "repeatable": "0", "repeatable_format": "default", "default_evaluate_tags": "0", "default_empty_fields": "0", "roles_allowed": "administrator", "enable_conditional_logic": "0", "unique": "0" }, { "name": "created", "id": 118, "label": "Date Created", "description": "", "weight": 1, "type": "datetime", "datetime_format": "ymd_slash", "datetime_time_type": "12", "datetime_time_format": "h_mm_ss_A" }, { "name": "modified", "id": 119, "label": "Date Modified", "description": "", "weight": 2, "type": "datetime", "datetime_format": "ymd_slash", "datetime_time_type": "12", "datetime_time_format": "h_mm_ss_A" }, { "name": "author", "id": 120, "label": "Author", "description": "", "weight": 3, "type": "pick", "pick_object": "user", "pick_format_type": "single", "pick_format_single": "autocomplete", "default_value": "{@user.ID}", "default_evaluate_tags": "1" }, { "name": "permalink", "id": 121, "label": "Permalink", "description": "Leave blank to auto-generate from Name", "weight": 4, "type": "slug" }, { "name": "conjugation", "id": 122, "label": "conjugation", "description": "", "weight": 5, "type": "pick", "pick_object": "pod", "pick_val": "hebr_conjugation", "pick_format_type": "multi", "pick_format_single": "dropdown", "pick_format_multi": "list", "pick_display_format_multi": "default", "pick_display_format_separator": ", ", "pick_allow_add_new": "1", "pick_taggable": "0", "pick_show_icon": "1", "pick_show_edit_link": "1", "pick_show_view_link": "1", "pick_limit": "0", "pick_user_role": "Administrator", "pick_sync_taxonomy": "0", "pick_sync_taxonomy_hide_taxonomy_ui": "0", "pick_post_status": "publish", "pick_post_author": "0", "repeatable": "0", "repeatable_format": "default", "default_evaluate_tags": "0", "default_empty_fields": "0", "roles_allowed": "administrator", "enable_conditional_logic": "0", "required": "0", "unique": "0", "sister_id": "123", "pick_where": "mainword.id = {@id}", "logged_in_only": "0", "admin_only": "0", "restrict_role": "0", "restrict_capability": "0", "hidden": "0", "read_only": "0" } ] } ] }, { "name": "hebrew_conj", "id": 126, "label": "Hebrew Conj", "description": "", "type": "post_type", "storage": "meta", "label_singular": "Hebrew Conj", "public": "1", "show_ui": "1", "publicly_queryable": "1", "dynamic_features_allow": "inherit", "rest_enable": "1", "supports_title": "1", "supports_editor": "1", "_migrated_28": "1", "groups": [ { "name": "more_fields", "id": 127, "label": "More Fields", "description": "", "weight": 0, "fields": [ { "name": "main_word", "id": 128, "label": "Main Word", "description": "", "weight": 0, "type": "pick", "pick_object": "post_type", "pick_val": "hebrew_word", "pick_format_type": "single", "pick_format_single": "dropdown", "pick_format_multi": "list", "pick_display_format_multi": "default", "pick_display_format_separator": ", ", "pick_allow_add_new": "1", "pick_taggable": "0", "pick_show_icon": "1", "pick_show_edit_link": "1", "pick_show_view_link": "1", "pick_limit": "0", "pick_user_role": "Administrator", "pick_sync_taxonomy": "0", "pick_sync_taxonomy_hide_taxonomy_ui": "0", "pick_post_status": "publish", "pick_post_author": "0", "repeatable": "0", "repeatable_format": "default", "default_evaluate_tags": "0", "default_empty_fields": "0", "roles_allowed": "administrator", "revisions_revision_field": "0", "enable_conditional_logic": "0", "rest_pick_response": "array", "rest_pick_depth": "1", "required": "0", "sister_id": "129" } ] } ] }, { "name": "hebrew_word", "id": 124, "label": "Hebrew Word", "description": "", "type": "post_type", "storage": "meta", "label_singular": "Hebrew Word", "public": "1", "show_ui": "1", "publicly_queryable": "1", "dynamic_features_allow": "1", "rest_enable": "0", "supports_title": "1", "supports_editor": "1", "_migrated_28": "1", "show_in_menu": "1", "menu_position": "0", "show_in_nav_menus": "1", "show_in_admin_bar": "1", "supports_quick_edit": "1", "restrict_dynamic_features": "0", "groups": [ { "name": "more_fields", "id": 125, "label": "More Fields", "description": "", "weight": 0, "fields": [ { "name": "conjugations", "id": 129, "label": "Conjugations", "description": "", "weight": 0, "type": "pick", "pick_object": "post_type", "pick_val": "hebrew_conj", "pick_format_type": "multi", "pick_format_single": "dropdown", "pick_format_multi": "list", "pick_display_format_multi": "default", "pick_display_format_separator": ", ", "pick_allow_add_new": "1", "pick_taggable": "0", "pick_show_icon": "1", "pick_show_edit_link": "1", "pick_show_view_link": "1", "pick_limit": "0", "pick_user_role": "Administrator", "pick_sync_taxonomy": "0", "pick_sync_taxonomy_hide_taxonomy_ui": "0", "pick_post_status": "publish", "pick_post_author": "0", "repeatable": "0", "repeatable_format": "default", "default_evaluate_tags": "0", "default_empty_fields": "0", "roles_allowed": "administrator", "revisions_revision_field": "0", "enable_conditional_logic": "0", "rest_pick_response": "array", "rest_pick_depth": "1", "required": "0", "pick_where": "main_word.post_title = {@post_title}", "sister_id": "128" } ] } ] } ] }The text was updated successfully, but these errors were encountered: