Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

Userlist Filter Question

11 years 8 months ago #220192 by mccormackdave
Userlist Filter Question was created by mccormackdave
In my Fields on CB Conditional we have the option for Does Contain, Does not Contain.

Is this possible to put in the user list filter?

My Problem


In my userlist creation i wish to have a user show if they fix boat engines.
in the field on registration they can choose other check box like below
choose the services you provide
[]Boat Engine Repair, []fibreglass repair, []wooden boat repair......

my problem is
when i try to create userlist for people who only fix boat engines

if they do not fix boat engines but do "fiberglass Repair" then they are still showing up on the user list for "Boat Engine Repair"

I have Tried all combinations of the existing filter choices

`cb_boatmarineservices` >='Boat Engine Repair'
..... shows users who do not provide boat engine repair if they do provide other service

`cb_boatmarineservices` >'Boat Engine Repair'
....... shows users who do not provide boat engine repair if they do provide other service

`cb_boatmarineservices` <'Boat Engine Repair'
......Shows no users

`cb_boatmarineservices` <='Boat Engine Repair'
......Shows no users

`cb_boatmarineservices` ='Boat Engine Repair'
......Shows no users

`cb_boatmarineservices` LIKE'Boat Engine Repair'
........also shows no users

Is there and advanced code i can put in which will eliminate users from list if they do not provide Boat engine repair.



Sorry im relatively new at CB

Kindest regards
Dave

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48454
  • Thanks: 8280
  • Karma: 1443
11 years 8 months ago #220228 by krileon
Replied by krileon on topic Userlist Filter Question
Below should work, you were just missing the wildcards.

`cb_boatmarineservices` LIKE '%Boat Engine Repair%'

Suggest reviewing the below SQL tutorials for further usage information as filters are simply adding to the WHERE statement of the userlist query.

www.w3schools.com/sql/sql_quickref.asp


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.

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

Moderators: beatnantkrileon
Powered by Kunena Forum