How to Apply Filters to a CB List View in New Menu Item

  • Chole
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0

Chole created the topic: How to Apply Filters to a CB List View in New Menu Item

Hello,

I am using BF and CB successfully. I have created a new CB View on the Frontend. I need to apply Filters to some of the Elements when building the Joomla New Menu Item. Example: I want to display the record in list view on the Frontend ONLY if "date1" contains data and "date2" is empty. I don't know how to use the Filter syntax to say if the field is empty or not e.g. =Null or <>Null. I hope I am clear? I hope I do not have to use Java to do this?

Thank you.
#235360
  • mihaela
  • Away
  • Administrator
  • Administrator
  • Posts: 2360
  • Karma: 85
  • Thank you received: 316

mihaela replied the topic: How to Apply Filters to a CB List View in New Menu Item

Hello,

Please take a look at this example since here similar issue is addressed crosstec.org/en/forums/1-forums/123275-s...for-view.html#222254 .

So, to filter whether any value was entered in a filed you can use this "trick".
Put the following in Menu Item > List View > Filter > field related to wanted element:
@match/a;b;c;d;e;f;g;h;i;j;k;l;m,n;o;p;q;r;s;t;u;v;w;x;y;z

You can take a look at this examples for searching empty values using Advanced List Filter crosstec.org/en/forums/37-contentbuilder...k-search.html#213288 or this one
crosstec.org/en/forums/37-contentbuilder...ty-value.html#220888 .

Regards,

Mihaela
#235377
  • Chole
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0

Chole replied the topic: [Resolved] How to Apply Filters to a CB List View in New Menu Item

Thank you so much. I've tried your suggestions and have decided to use a separate form field, with a list of values, on which I can filter the required records for the List. It has actually proven to be a better than expected solution.
#235444
  • mihaela
  • Away
  • Administrator
  • Administrator
  • Posts: 2360
  • Karma: 85
  • Thank you received: 316

mihaela replied the topic: [Resolved] How to Apply Filters to a CB List View in New Menu Item

Hello,

Great! I'm glad that you have found a solution that suits your view the most. :)

Regards,

Mihaela
#235471
The following user(s) said Thank You: Chole
Moderators: ForumSupporttomeperica
Time to create page: 0.060 seconds

Live Support Chat Opened!

Join our Discord chat here to receive live support and talk directly to the team!

Summer Sale!

50% discount on all of our extension subscription plans & templates!

Get Your Subscription Here

News and Updates

Get informed about new downloads, updates and more in our News and Updates newsletter.

All Extensions Subscription

Get 1 year access to all of our current and future products and 1 year of professional support -- 99 for just 49! (Summer Sale)

No support per domain or website installation limits! Includes all of our current and future Joomla!® extensions, Joomla!® templates for the duration of your membership. This means, by purchasing an All Extensions Subscription you'll have it all covered!

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!

Live Support Chat Opened!

Join our Discord chat here to receive live support and talk directly to the team!

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here