is it possible add more operator to user managment search?

saman2
OFFLINE
Posts: 408
Thanks: 7
Karma: -1

1 year 1 month ago #335818 by saman2

is it possible add more operator to user managment search? was created by saman2

hi
is it possible add not empty, empty, null and more other important operator?

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48616
Thanks: 8302
Karma: 1446

1 year 1 month ago #335819 by krileon

Replied by krileon on topic is it possible add more operator to user managment search?

Searching with "Not equal to" operator and leaving the value input empty will search for empty string and NULL values. All of the "not" operators include checking NULL (Not equal to, Is not REGEXP, Does not contain, and Is not one of). There's no functionality for explicitly searching for NULL though.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

The following user(s) said Thank You: saman2

Please Log in or Create an account to join the conversation.

saman2
OFFLINE
Posts: 408
Thanks: 7
Karma: -1

1 year 3 weeks ago #336113 by saman2

Replied by saman2 on topic is it possible add more operator to user managment search?

how to find "not empty" with those operator?

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48616
Thanks: 8302
Karma: 1446

1 year 3 weeks ago #336124 by krileon

Replied by krileon on topic is it possible add more operator to user managment search?

Set operator to "Not equal to" and leave the value input empty.

Please Log in or Create an account to join the conversation.

saman2
OFFLINE
Posts: 408
Thanks: 7
Karma: -1

4 months 3 weeks ago #338701 by saman2

Replied by saman2 on topic is it possible add more operator to user managment search?

hi
I still think options like is empty are needed... similar to the condition tab in the auto action plugin
Since this topic is rarely used, I occasionally come back here and review the content

Please Log in or Create an account to join the conversation.

saman2
OFFLINE
Posts: 408
Thanks: 7
Karma: -1

4 months 1 week ago - 4 months 1 week ago #338930 by saman2

Replied by saman2 on topic is it possible add more operator to user managment search?

krileon wrote:
Set operator to "Not equal to" and leave the value input empty.

are you sure that is work?
can you test it?
i use phpmyadmin but it is hard to do that every time. i get different users when use your solution and when use CB search tools. look at attached pics.

Last edit: 4 months 1 week ago by saman2.

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon