Jump to content

Sorting Portals


BlackPelican

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

Recommended Posts

Hello

I haven't been able to figure out sorting records in a portal based on a value list when defining the relationship. I want to sort the records in the portal on any field in the portal. Is that that what a value list is used for in that situation? If I don't specify which field to sort related records on, the portal always displays them in serial record order. I want them sorted by DueDate, CustomerName or DocketNumber. As well I would like to filter them based on the contents of one field.

I am completely lost on this one.

Thanks for your help.

Link to comment
Share on other sites

To "re-sort" a portal, you have two basic choices. Use one relationship for each sort order desired and have a separate, but identical looking, layout and portal for each sort order. Change the contents of the field (in the related file) that the sort is based upon. This can be done with a sort and a replace (with serial numbers) in the related file.

To filter a portal, you must change the contents of the field (key) on either the left side or right side of the relationship. Most often this is done by using a relationship in which the left side field (in the definition) is a global text field and uses a multi-key. A multi-key is a field in a relationship that contains more than one value separated by a carriage return.

Say you have a related file called "Animals". The right side key (in the related file) is animal type. The left side key is a global text field. If you want the portal in your main file to display dogs, cats, and fish, you would set the global field (let's call it "gType") to:

dog <cr>

cat <cr>

fish

Another example. If you want to display a range of due dates in a portal (say March 5 thru March 9 of this year. Create a relationship with "gDate" (global text field) matching "DueDate" in your related file. The values in gDate would then be:

3/5/2002 <cr>

3/6/2002 <cr>

3/7/2002 <cr>

3/8/2002 <cr>

3/9/2002 <cr>

The <cr>'s just indicate that the values are on separate lines (separated by a carriage return in the global field).

-bd

Link to comment
Share on other sites

quote:

Originally posted by BlackPelican:

Hello

I haven't been able to figure out sorting records in a portal based on a value list when defining the relationship. I want to sort the records in the portal on any field in the portal. Is that that what a value list is used for in that situation? If I don't specify which field to sort related records on, the portal always displays them in serial record order. I want them sorted by DueDate, CustomerName or DocketNumber. As well I would like to filter them based on the contents of one field.

I am completely lost on this one.

Thanks for your help.

I don't understand this part - "This can be done with a sort and a replace (with serial numbers) in the related file." Isn't a relationship with different fields all I need to do?

Thanks

Link to comment
Share on other sites

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