[SOLVED] List filters and empty or null fields

9 years 5 months ago #252859 by krileon
Replied by krileon on topic List filters and empty or null fields
Please PM backend super administrator login credentials and provide a username of a user that is supposed to be displaying, but isn't so I can compare with a user that is displaying to see what could be wrong.


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.

9 years 5 months ago #252995 by Smooth2SITF
Replied by Smooth2SITF on topic List filters and empty or null fields
I sent you the required info yesterday

Please Log in to join the conversation.

9 years 5 months ago #253130 by krileon
Replied by krileon on topic List filters and empty or null fields
Have reviewed your install and it's purely a configuration problem. You've set your userlist to show users from the "Registered" usergroup and nothing else. The user that you want to display that isn't is in the "Expired" usergroup. It only shows users that are specifically in the usergroups selected. The parameter specifically states this. Please edit your userlist and adjust "Usergroups" parameter as needed (e.g. add the Expired usergroup to it).


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: nant

Please Log in to join the conversation.

9 years 5 months ago #253237 by Smooth2SITF
Replied by Smooth2SITF on topic List filters and empty or null fields
I had already realized that part... I was changing that back and forth to test it out....

If left blank, doesn't it suppose to show all groups, regardless of assignment if the field is populated?

That was what I was trying to figure out...

Please Log in to join the conversation.

9 years 5 months ago #253246 by Smooth2SITF
Replied by Smooth2SITF on topic List filters and empty or null fields
Ok, so I made some adjustments.

I added ALL fields and I added a filter for In-Bound Transferred list that is Filter: Transferred from, Value: <> and then for Out-Bound Transferred list that is Filter: Transferred to, Value: <>.

So I went to the list, and it is now showing members with empty fields. I didn't want the list to do that, I want it to only show members where the field is populated, regardless of what group they are in.

Any insight?

Please Log in to join the conversation.

9 years 5 months ago - 9 years 5 months ago #253344 by krileon
Replied by krileon on topic List filters and empty or null fields

If left blank, doesn't it suppose to show all groups, regardless of assignment if the field is populated?

No, you need to specifically select what usergroups you want to be visible on your userlist. It has always functioned this way.

So I went to the list, and it is now showing members with empty fields. I didn't want the list to do that, I want it to only show members where the field is populated, regardless of what group they are in.

They probably have a NULL value. Add an advanced filter of the following.

( c.`FIELD_NAME` != '' AND c.`FIELD_NAME` IS NOT NULL )

We'll need to improve the <> blank usage to automatically add the null for a later release.

forge.joomlapolis.com/issues/4883


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: beatnantkrileon
Time to create page: 0.244 seconds

Facebook Twitter LinkedIn