Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Friday 1:32 am
Add a reply View Replies (3)

Resolved Find fields that are emty

  1. jotun
    jotun
  2. General
  3. Monday, May 11 2015, 12:01 PM
Hi.
I have a menu item user list. I make a field searchable and I want to list all users with emty field. How can I do this?

Search for other values works just fine, just don't know how to find emty fields....
Responses (3)
admin
admin Accepted Answer
Admin
Hi,
sorry this is not possible, Easy Profile is a Profiler component (not directory) so search functions are limitated.

You can create a list of user with a empty field with a Custom SQL Where paramter (examples here: https://www.easy-profile.com/docs/69-sql-custom-where-list-and-module.html ), but is not possible to search empty results with form :(
  1. more than a month ago
  2. General
  3. # 1
jotun
jotun Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. General
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
you can create a menu item with only users with this field empty. for example if your field have alias like "test_field" you can put this into Custom SQL Where parameter in menu item options:
test_field=''


Strange that you can search on any letter in or parts of words, but not empty field.
This is a only way, for example if I have a form with Name and City then I can search for Name,City,Name and City. If you not fill search criteria the system ignore this field.
  1. more than a month ago
  2. General
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.