Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Limiting the number of records in a portal


This topic is 6857 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hello,

I want a portal that shows our most recent 5 orders. The problem is, it takes forever to sort all 20,000 orders by the sort criteria I have on the portal. My portal only shows five rows and doesn't have a scroll bar... any faster way to do this?

Thanks,

Andrew

Sorry if this has been covered before -- I didn't see it anywhere.

Posted

look up "portal filtering"

Basically you add another set of criteria to the portal relationship that will reduce the number of related records.

For instance, if you have a relationship that says invoices::id=lineitems::fk_invoice_id, the portal will show all the line items for the invoice in the portal.

If you have the following constraint added:

invoices::gMonth=lineitems::lineitem_month

Then the portal will only show lineitems having the month value specified in gMonth.

This topic is 6857 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.