Filtering question

10 posts by 2 authors in: Forums > CMS Builder
Last Post: January 27, 2009   (RSS)

By s2smedia - January 23, 2009

I have a list manager for Schedule postings

In this list manager the first option is to select what "Location" the schedule posting is for.

I have another list manager for the "Locations" within my cms so Im using a drop down list pulling in from this manager.

Is there a way to filter on certain pages to only show the schedule postings for the location that is selected?

Heres the locations page:
http://apexfinal.highviews.co.cc/locations.php

When you select a location you will see the Schedule... but right nw its showing all listings

Re: [s2smedia] Filtering question

By Dave - January 23, 2009

Hi s2smedia,

Yes, you can hardcode that in the "where" option in the viewer page code or specify it in the url like this:

http://apexfinal.highviews.co.cc/locations.php?location=cary,+nc

Note that you'll need to have the same values for locations. Currently you have "Cary" and "Cary, NC".

You can learn more about the automated searching here: http://www.interactivetools.com/docs/cmsbuilder/viewer_search.html

Hope that helps!
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] Filtering question

By s2smedia - January 23, 2009

Right but thats the issue... these locations will be changing, and adding new ones down the road via the CMS. So i cant hard code Cary, NC because that isnt always going to be there.

Re: [s2smedia] Filtering question

By Dave - January 23, 2009

Well how would you like the filtering to work?

If the locations are a pulldown with the values pulled from another section can't you just have one entry for Cary, NC?
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] Filtering question

By s2smedia - January 23, 2009

Ok Ill try to go step by step on how the process works

1. Add a new Location (there is a tab in CMS called locations... multi record manager)

2. Schedule a Session for that location... go to Schedule tab in CMS (multi record manager)
the first field is a list.. that pulls in all locations that have been created.
You would first select the location you are creating a "session date" in the schedule for... then you chose the date, time etc..

Now when you go to that location page.. there is a box thats called Session Schedule... I only want the sessions scheduled for that particular location.

Let me know if that makes sense..

Thanks!

Re: [s2smedia] Filtering question

By Dave - January 26, 2009

Glad to hear it's working! Let us know if you need help with anything else. :)
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] Filtering question

By s2smedia - January 26, 2009

I think i need to adjust the code now... similar to how you helped in my other Forum Post....

Re: [s2smedia] Filtering question

By s2smedia - January 26, 2009

<?php if ($record['futsal_location'] != $winter_academy_locationsRecord['location']) { continue; } ?>

Re: [s2smedia] Filtering question

By Dave - January 27, 2009

Let's continue in this other post:

http://www.interactivetools.com/forum/gforum.cgi?post=68825#68825
Dave Edis - Senior Developer
interactivetools.com