Newbies haironfire Posted November 29, 2002 Newbies Share Posted November 29, 2002 Basic question. Have a list of taxlot acreages for many cities and counties. Want the top 10 records sorted descending order for all jurisdictions. Can't figure out how to start this. Help. Link to comment Share on other sites More sharing options...
Newbies JennyAnders Posted November 30, 2002 Newbies Share Posted November 30, 2002 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 More sharing options...
Newbies Camden Posted November 30, 2002 Newbies Share Posted November 30, 2002 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. Link to comment Share on other sites More sharing options...
Newbies haironfire Posted November 30, 2002 Author Newbies Share Posted November 30, 2002 Thanks for the tips. A script, huh? OK, looks pretty easy, but it is new territory to me. BTW, I am sorting by daily vehicle trips. Link to comment Share on other sites More sharing options...
Newbies haironfire Posted November 30, 2002 Author Newbies Share Posted November 30, 2002 This looks more like what I had in mind. So, if I read this right, the descending sort is defined as part of the relationship? Hmm..never tried that before. Thanks for the help. Link to comment Share on other sites More sharing options...
Newbies haironfire Posted November 30, 2002 Author Newbies Share Posted November 30, 2002 Well, I guess I need to learn more about portlals. Right now, it just shows 10 versions of the same record. Link to comment Share on other sites More sharing options...
Vaughan Posted December 1, 2002 Share Posted December 1, 2002 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 More sharing options...
Vaughan Posted December 1, 2002 Share Posted December 1, 2002 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 More sharing options...
Recommended Posts
This topic is 7909 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 accountSign in
Already have an account? Sign in here.
Sign In Now