Data Page Not Filtering Correctly

[rentonsa]

Hi folks

 

New to Caspio, but not to relational databases!

 

I've been setting up a website for my band, and I'm trying to get a gigs archive from which you can drill down to setlist data. I've set up tables Gig, Song and a m2m table between them called GigSong. I've made a view with the song and gigsong data so I don't have to catalogue the name of the song every time I update that table, just an ID.

 

So, the main Gig dataPage is fine, and it drills into a page which has 2 dataPages- one for gigDetails, so you know you're on the right one, and one for setlist. The gigDetails takes the gigId parameter passed fine. The setlist filters, but not dynamically, so I know the parameter filtering is working. Bizarrely, though, on the website, it seems to pick up the value that I've used in the Preview screen when testing it: each one picks up the same data, then if I Preview again with something different, it changes to that.

 

The parameters I'm passing in look like this:

 

On load:

tickedReceive value or parameter:

External Parameters: [@tblGigSong_gigId]

 

 

Could this be because I'm using a view? As you can see above it seems to get the right field.

 

Here's the page- if you click on any of the "See setlist"s you'll see what I mean.

http://theheartbreakdiet.weebly.com/gigs.html

 

Thanks very much
Scott

[Aurora]

Hi Rentosa, 

 

Could you please clarify the name of parameter that you send, like.... &street=[@field:location] and the name of parameter you receive. 

 

 

Aurora