Community Builder 2.0 Released
- GUEST
Please provide screenshot with your advance filter settings that are not working.
See attached screeshot.
(The filter is fine, but at Parameters->Display I have the following settings:
Show Blocked - No
Show Banned - No
Show Unapproved- No
Show Unconfirmed -No
Still a user who is blocked and banned displays in the list.)
Please Log in to join the conversation.
nant
Team Member- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
martinmg wrote:
Please provide screenshot with your advance filter settings that are not working.
See attached screeshot.
(The filter is fine, but at Parameters->Display I have the following settings:
Show Blocked - No
Show Banned - No
Show Unapproved- No
Show Unconfirmed -No
Still a user who is blocked and banned displays in the list.)
I am guessing (Kyle will follow-up) that those settings will only work with simple filtering because advanced filtering is really meant to replace the entire WHERE clause.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
- GUEST
I am guessing (Kyle will follow-up) that those settings will only work with simple filtering because advanced filtering is really meant to replace the entire WHERE clause.
ok, but I cannot create a basic filter with multiple criterias if I need a query with "OR". The only option today using basic filter is "AND" if i add another criteria. Perhaps it should be possible to choose between "AND" and "OR" when adding the criteria?
Please Log in to join the conversation.
- krileon
Team Member- ONLINE
- Posts: 68524
- Thanks: 9091
- Karma: 1434
Was able to confirm your issue. Looks like those WHERE values aren't being added when advanced filtering is used. This is due to the OR in your filtering and the advanced filtering output missing its (). Add ( and ) brackets around your filtering and that should fix it. Alternatively you can apply the below quickfix.See attached screeshot.
(The filter is fine, but at Parameters->Display I have the following settings:
Show Blocked - No
Show Banned - No
Show Unapproved- No
Show Unconfirmed -No
Still a user who is blocked and banned displays in the list.)
IN: libraries/CBLib/CB/Legacy/cbUsersList.php
ON: Line 593
FROM:
$filterBy = ' AND ' . $cbUser->replaceUserVars( $filtering, array( $_CB_database, 'getEscaped' ), false );$filterBy = ' AND ( ' . $cbUser->replaceUserVars( $filtering, array( $_CB_database, 'getEscaped' ), false ) . ' )';Basic filters are just that; basic. Adding AND/OR scenario to them would complicate the configuration and likely cause confusion with how they should behavior. For example is the OR an OR to the value previous to it or to all the other filters? For those usages I suggest using Advanced.ok, but I cannot create a basic filter with multiple criterias if I need a query with "OR". The only option today using basic filter is "AND" if i add another criteria. Perhaps it should be possible to choose between "AND" and "OR" when adding the criteria?
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 to join the conversation.
- GUEST
Add ( and ) brackets around your filtering and that should fix it.
Confirmed. Brackets around the filter works!
Please Log in to join the conversation.
- jeronimodynamo
- OFFLINE
-
New Member
- Posts: 4
- Thanks: 0
- Karma: 0
Thanks!
Please Log in to join the conversation.
-
You are here:
- Home
- Forums
- About Joomlapolis
- News and Publicity
- Community Builder 2.0 Released