1. Forums
  3. Archive
  5. CB
  7. CB 1.2.3
  9. CB 1.2.3 Usability
  11. [SOLVED] CB list to display only fields with data

[SOLVED] CB list to display only fields with data

13 years 4 months ago #147086 by luzmpayne
[SOLVED] CB list to display only fields with data was created by luzmpayne
Hi, I created a list but only want to display users who have information in a specific field. I have tried the filters "is not null" and "not equal to", but they don't seem to work. Can somebody help me with this please?

Thanks,

Post edited by: krileon, at: 2010/11/29 20:01

Please Log in to join the conversation.

13 years 4 months ago #147156 by krileon
Replied by krileon on topic Re:CB list to display only fields with data
The type of filter you need is dependent on the type of field. Typically NULL isn't the best approach, but rather to check if the field is blank or not. Try using the following filter structure.

Basic:
FIELD "Is Not Empty"

Advanced:
`FIELD` != ''

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.

13 years 4 months ago #147162 by luzmpayne
Replied by luzmpayne on topic Re:CB list to display only fields with data
Thank you. Somehow the filter was not working with 1.2.2 version, but when I upgraded to the 1.2.3 version, the advanced filter worked.

Please Log in to join the conversation.

13 years 4 months ago #147202 by krileon
Replied by krileon on topic Re:CB list to display only fields with data
luzmpayne wrote:

Thank you. Somehow the filter was not working with 1.2.2 version, but when I upgraded to the 1.2.3 version, the advanced filter worked.

You should upgrade to CB 1.3, which is the latest.

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.

Moderators: beat, nant, krileon
  1. Forums
  3. Archive
  5. CB
  7. CB 1.2.3
  9. CB 1.2.3 Usability
  11. [SOLVED] CB list to display only fields with data
Time to create page: 0.170 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Archive
  4. CB
  5. CB 1.2.3
  6. CB 1.2.3 Usability
  7. [SOLVED] CB list to display only fields with data

Search

Login / Logout

User Menu