Portal Limiting

[Jon Crain]

I have a portal in a layout which pulls events from our calendar database. I want to be able to limit the portal to only pull the next 5 events listed. I have the portal setup to filter only events from today's date onward and can set it up so that I can get the next ten days, but I think only seeing the next five events would be clearer for users. I know I can setup the portal so you only see five rows and hide the scroll bar, but I'm setting it up for custom web publishing which ignores the portal viewing settings and displays all the records. Any help would be appreciated.

jon

[Ocean West]

using your existing relationship create a calc (or global) field using List function to get a list of the parent key of the related data, then using MiddleValues you could isolate the the five records you wish (first five) with this return separated list.

Base a new relationship on this field and the primary key of the related data. us this as a basis for a portal on your layout.

With some scripting you could actually paginate the portal moving ±5 in either direction.