Assuming applicant_username is a field containing an email, applicant_username.meta_value = "{@user.user_email}" works in testing if you set define( 'PODS_SHORTCODE_ALLOW_EVALUATE_TAGS', true ); in wp-config.php. See https://docs.pods.io/displaying-pods/magic-tags/special-magic-tags/
This type of query may be easier / more efficient if you use either a User Relationship field, which stores an associated user by User ID, or the built-in post_author field.
- This reply was modified 4 minutes ago by .
To be a bit more thorough, to test this, I created a Pod called test and added a post with an email address of the currently logged in user in an email field called applicant_username. On a Page, I then inserted a Pods Item List block with the following values:
- Pod Name:
test - Custom Template:
<tr><td><a href="https://projectdmc.org/support/topic/where-clause-with-user_email/{@permalink}">{@post_title}</a></td></tr> - Content Before List:
<table> - Content After List:
</table> - WHERE:
applicant_username.meta_value = "{@user.user_email}"
…with define( 'PODS_SHORTCODE_ALLOW_EVALUATE_TAGS', true ); set in wp-config.php