Type in your suggestion - new feature or improvement idea

Search criteria - NOT

We are a new user and have uploaded the member lists from data in our desktop database. Now we need to be sure that all our users have reset their passwords (senior group, some with limited computer skills).

We did find a way to see everyone who had logged in at least once. Admin area > Members > Advanced Search criteria: Last login date. This suited our situation because if they were able to login, that meant they had reset their passwords.

What we couldn’t get, however, was a search list of those who had never logged in. We worked around it by creating a Logged In = Yes or No field and populated it with yes for those who had logged in, then created search on No to find the others. Doable, but requires manual manipulation to keep it up to date.

One solution is to have 'Never logged in’ and ‘Not logged in as of <date>’ in the search criteria choices.

Even better would be a general search feature that excludes the searched records. You have AND & OR - it would be nice to have NOT for all searches.

9 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Susan BushSusan Bush shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    14 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • TorieTorie commented  ·   ·  Flag as inappropriate

        I'm not sure if this is the same problem. I have a drop-down menu field that I want to make sure is not left empty. It is admin only. I had to save a search where I put each of six menu items with IS NOT in them to find the blanks. Luckily there were only six choices and I can save the search so I don't have to recreate it. However, I am used to being able to search for a blank field.

        Thanks.

      • factivationfactivation commented  ·   ·  Flag as inappropriate

        I know this is an old thread so I'm hoping there is now a solution to this. I moved to WA from another member website with about 650 members. I know that MANY of them have never logged in on the WA site and I would like to contact these members to make sure they know how and that the site has, in fact, moved. Can I search for last login:never?

      • Evgeny aka Apricot KernelAdminEvgeny aka Apricot Kernel (Product Manager, Wild Apricot) commented  ·   ·  Flag as inappropriate

        The problem is not in SQL but how to present search to a non-developer in way that is clear to use. Introducing AND and OR also means making grouping of conditions (which part is for OR and which is for AND) and overall UI will be very complicated.

        But I agree that this is a very nice to have ability to make sophisticated searches that gives a way to use AND, OR and NOT.

      • John DandurandJohn Dandurand commented  ·   ·  Flag as inappropriate

        This is a common search scenario. WA needs Boolean logic capabilities for its searches. It is an SQL database, so such functionality should be available to the developers.

      • Kim SkimmonsKim Skimmons commented  ·   ·  Flag as inappropriate

        In this case they are searching a membership directory and want to be able to search for members who represent fiction writers but NOT children's fiction. They have a database field called "Categories" that is a long list of checkboxes they can choose from. The directory includes this field in the display, so it's searchable using a keyword search. Among the categories are "fiction" and "children's fiction". So typing fiction into the keyword search would return both 'fiction' and 'children's fiction' in the results. If they could type fiction -children in the search field, that would work.

      • Kim SkimmonsKim Skimmons commented  ·   ·  Flag as inappropriate

        [quote user="Chief_Apricot"]

        Has anyone else come across other situations when NOT would be useful?

        [/quote]

        I have a client asking me today for a NOT option in Keyword Search. FWIW, I like how Google uses the hyphen prefix for NOT (e.g., dog NOT cat is: dog -cat ).

      • ddeanddean commented  ·   ·  Flag as inappropriate

        yep, i realize. but i thought this might be a way to add this functioanlity to the search using the existing UI

      • Dmitry ButerinDmitry Buterin commented  ·   ·  Flag as inappropriate

        Sorry about the UI - might be a bit misleading. <No date> means that date to match to has not been defined, it does not mean date=empty

        At the moment there is no way to do advanced search for records with empty login date.

      • ddeanddean commented  ·   ·  Flag as inappropriate

        yes I ran into this problem today when adding new members via upload also. I wanted to email them to tell them how to login the first time. The search criteria already has a way to specify:

        Last Login Date Is <No date>

        but it doesn't do what i'd expect. it seems to return every member.

      • Kim SkimmonsKim Skimmons commented  ·   ·  Flag as inappropriate

        Not specifically yet, but I can easily imagine scenarios where it would be useful. Every Boolean search has a NOT option.

      Feedback and Knowledge Base

      Wild Apricot Inc. 144 Front Street West Suite 725, Toronto, Ontario, Canada M5J 2L7