Pods - Customize the WHERE lookup for a specific pod and relationship field (for relationship lookups and more)

pods-customized-where-lookup.php

<?php

/**
 * Customize the WHERE lookup for a specific pod and relationship field.
 *
 * @param array                     $lookup_where The WHERE conditions for the lookup keyed by column name.
 * @param string                    $query        The search query being used.
 * @param string                    $name         The name of the field.
 * @param string                    $value        The current value of the field.
 * @param array|\Pods\Whatsit\Field $options      The field data.
 * @param array|\Pods\Whatsit\Pod   $pod          The pod data.
 *
 * @return array The WHERE conditions for the lookup keyed by column name.
 */
function my_customized_where_lookup_for_pods_relationship_field( $lookup_where, $query, $name, $value, $options, $pod ) {
	// Only lookup post_title so we will remove the post_name, post_content, and post_excerpt references.
	if ( 'your_pod' === $pod['name'] && 'your_relationship_field_name' === $name ) {
		unset( $lookup_where['post_name'], $lookup_where['post_content'], $lookup_where['post_excerpt'] );
	}

	return $lookup_where;
}
add_filter( 'pods_form_ui_field_pick_autocomplete_lookup', 'my_customized_where_lookup_for_pods_relationship_field', 10, 6 );