Jon Crain Posted October 25, 2007 Share Posted October 25, 2007 I'm working on a database that I already have setup using a filtered portal. I think viewing the data would be better if I could filter again. Basically I'm trying to filter down the number of tracks in a portal first by having the user select a year, and then a group. I have the year part figured out but it gets a little complicated for me to understand the logic in how to filter again. First off is it possible? If not, then I'm just hitting the wind. Secondly, would I use some sort of the same logic as I did for filtering years? I've attached a picture of the portion of the database that I'm talking about. jon Link to comment Share on other sites More sharing options...
FestiveEmbalmer Posted October 26, 2007 Share Posted October 26, 2007 Still pretty new to the concept but I think I know what you mean. Couldn't you create a calc (or autoenter) field that combines the year of each record and the return character and "All" and a similar field that combines the group and the return character and "all" and then create your relationships so that the global match field is by default "All"? The user could then select a year or a group or both, filtering the portal appropriately. I am going to have to do something like this myself in a little bit, so I hope I have the right idea! Link to comment Share on other sites More sharing options...
Fenton Posted October 26, 2007 Share Posted October 26, 2007 There is another approach, by (our own) Søren Dyhr. When there is no selection, it uses ValueListItems to show all values, otherwise uses the selection. Fairly simple to implement. (I took the liberty of adding his name to the file, so I could identify it; apparently PHP doesn't like the ø.) S__ren_Popglobal.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6161 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