Jump to content

Filtering Portal Results


Sammy

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

Recommended Posts

I call a set of records in a portal by defining the rel Date::Date , having a global that allows me to enter any date I want.

Here's my problem: Once I have all of the records defined, I would like to filter more specifically, and to perform some calculations off of the displayed records. For instance, I would like to display in my portal records that are from one day (Date::Date), but filter those to show only the records that are in a specific facility (Location::Location). Is there any way I can use multiple relationships to do that?

Link to comment
Share on other sites

In main file:

2 globals: gDate and gLocation

1 calculation: cFilter = DateToText (gDate) & " " & gLocation

In related file:

1 calculation: cMultikey =

Location & "<paragraph symbol>" &

DateToText (Date) & "<paragraph symbol>" &

DateToText (Date) & " " & Location

Setup your relationship as cFilter::cMultikey.

This way what you type into either or both fields will filter the portal.

Link to comment
Share on other sites

Okay, I set that up, but I'm having trouble making it work. What I get is the portal displays only one entry via the relationship, it is not a record that should be displayed (ie the record's date matches, but the facility is incorrect), and it repeats this record 50-60 times inside the portal. If I take out the facility and leave just the date, it still displays that same record, but shows only 10 or so repeats.

Any thoughts?

Link to comment
Share on other sites

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