TOPIC:

Content builder limit results in list view 2 years 6 months ago #247699

  • Topic Author
  • anthi
  • Offline
  • New Member
  • New Member
  • Registered
  • Posts: 6
  • Thanks: 0
Hello everyone,

I was wondering if it's possible to limit the results in content builder list view.
We have a breezing form associated with the view and we need the view to display the last 20 entries of the form. I have already tried by creating an override but I can only manipulate the results per page and not the total results.

So for example if there are in DB 100 records we want only to bring the last 20. Is that possible?

Thanks in advance!

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

Content builder limit results in list view 2 years 6 months ago #247742

  • TheMuffinMan's Avatar
  • TheMuffinMan
  • Offline
  • Administrator
  • Administrator
  • Super Users
  • Posts: 10544
  • Thanks: 859
Hi,

without hacking I would suggest using overrides and remove the pagination and max record selection.

By default it will sort by ID, descending and show the last 20 entries (please see view => advanced options => sorting settings).

Regards,
Markus

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

Content builder limit results in list view 2 years 6 months ago #247756

  • Topic Author
  • anthi
  • Offline
  • New Member
  • New Member
  • Registered
  • Posts: 6
  • Thanks: 0
Hello and thank you for your quick reply!

I can see the pagination but I can not see the max record selection :)(Not so Php familiar)
Do you mean the row
$n = count( $this->items );


And also the records we have are about 100, and the performance is very slow (about 20sec) do you think if we limit the results will solve also the performance problem? In the future the results would be a lot more that's why we needed to limit the results.

Thanks in advance!

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

Content builder limit results in list view 2 years 6 months ago #247796

  • TheMuffinMan's Avatar
  • TheMuffinMan
  • Offline
  • Administrator
  • Administrator
  • Super Users
  • Posts: 10544
  • Thanks: 859
Hi,

this is even with 100 records way way too slow.
Please install the component attached over your existing installation.
It includes some performance improvements that hopefully affect yours positively, too.

The per-page dropdown is basically included in the whole block that deals with pagination at the bottom of the template file.

Regards,
Markus

File Attachment:

File Name: com_conten...9-04.zip
File Size:1,730 KB
Attachments:

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

  • Page:
  • 1
Time to create page: 0.051 seconds

Support Chat

Join our Discord chat and enter the Crosstec channels for live-support, chat forums and interact directly with the community!

After joining, please enter the Crosstec Area and use the #crosstec-support or #crosstec-general channels.

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Subscribe to news and updates!

Special Offer

Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

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 and enter the Crosstec channels to receive live support and talk directly to the team!