Filter User Meta with an empty value

  • Resolved ejb

    (@ejb)


    1 year, 2 months ago

    Thank you for this plugin, it’s been very useful for me!

    We are using it to delete users who haven’t logged in before a specific date. I’m able to filter by Wordfence’s Last Login meta key: wfls-last-login, then choose “less than (date)” and then put a Unix timestamp in the meta value field. It works great for this!

    However, if a user has never logged in, then the wfls-last-login field will contain an empty value. And I can’t figure out how to show results for an empty value. All the conditional operators produce the same result: “no users found with the given filters”, or sometimes I see “at least one required field”. I feel like there should be an option for “is empty”, “is null” or “not exists”.

    I was wondering if you have any insights into how to get this to work.

    Thanks!
    Eric

    • This topic was modified 1 year, 2 months ago by ejb.
    • This topic was modified 1 year, 2 months ago by ejb.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author maksymvasylchuk

    (@maksymvasylchuk)

    1 year, 2 months ago

    Hi Eric,

    Thank you so much for your kind words — we’re really glad to hear the plugin has been helpful for you!

    Regarding your question: at the moment, we don’t have support for filtering by an empty, null, or non-existent meta value like wfls-last-login. We completely understand how useful an “is empty” or “not exists” condition would be for cases like yours.

    We’re going to count this as a feature request, and it’s definitely something we’ll consider adding in a future update or release. Your use case makes perfect sense, and we’ll keep it in mind as we continue improving the plugin.

    Thanks again for the feedback!

    Best regards,
    Maksym Vasylchuk

    Plugin Author maksymvasylchuk

    (@maksymvasylchuk)

    1 year, 1 month ago

    Hi Eric,

    Thank you and sorry it took a while — but we’ve been working on your feedback.

    Great news: based on your feedback, we’ve just added new options that allow you to filter users by user meta that is either empty or does not exist. This means you can now accurately target users who have never logged in by checking the wfls-last-login meta key and selecting either:

    1. “Meta does not exist” — for users who don’t have the key at all
    2. “Meta is empty” — for users where the key exists but has no value

    This feature is now available in the latest version — no upgrade steps required.

    Thanks again for the great suggestion, and feel free to reach out if you have any other ideas or questions!

    If the plugin has been useful to you, we’d really appreciate it if you could take a moment to leave a quick rating or review — it helps us a lot and keeps the project going ❤️

    Best regards,
    Maksym Vasylchuk

    Plugin Author maksymvasylchuk

    (@maksymvasylchuk)

    1 year, 1 month ago

    Hi Eric,

    Just checking in — we haven’t heard back in a while, so we’ll go ahead and close this support topic for now.

    If you run into any issues with the new filters or have more questions down the road, feel free to open a new ticket anytime. We’re always happy to help!

    Thanks again for your valuable feedback and for using the plugin!

    Best regards,
    Maksym Vasylchuk

    Thread Starter ejb

    (@ejb)

    1 year, 1 month ago

    I’m sorry, I missed your earlier reply. Thanks for working on this. I’m excited to try it. I’ll take a look at it in the next few days.

    Thread Starter ejb

    (@ejb)

    1 year, 1 month ago

    I was able to test the new changes and it works perfectly. Thank you so much! This is so useful for sites with huge userbases.

    All the best to you!
    Eric

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Filter User Meta with an empty value’ is closed to new replies.