Jump to content

Top 10 List


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

Recommended Posts

  • Newbies

You haven't said what you want them sorted descending by. Descending order by property value? Descending order by acreage? Descending order by zip code?

Once you figure that out the rest is easy. First sort, selecting the file that matches what you want the the descending order by, once it is in the list at the right, select it and then choose the 'descending' option at the bottom of the dialog.

Then set yourself up a script that goes like this

show all records

sort

omit multiple (set for ten records, without dialog)

show omitted

The sort order that you created before the script gets saved with the script, so every time you run the script it will give you the top ten.

Link to comment
Share on other sites

  • Newbies

Yea cool Jenny

You could also do a self-join relationship with a constant calculation ( calc = 1 ) matched to itself, set the relationship up with the descending sort on whatever, and put a portal on yer layout with ten rows.

Portal will always show the current top ten. cool.gif

Link to comment
Share on other sites

Off topic: you don't know how groovy it is seeing Americans posting images of Australian actors! Can't wait for Matrix 2.

For those who like Hugo Weaving (aka Agent Smith) and want to see more, go see "Priscilla, Queen of the Desert."

Link to comment
Share on other sites

Ooops forgot to answer you're question...

If you're getting the same value repeating in your portal it could mean:

1) each related record really does have the same value.

2) the field in the portal isn't through the same relationship as the portal.

I'd say the problem is 2. You probably have a "local file" field in the portal.

Link to comment
Share on other sites

This topic is 7815 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.