Creating a search on a Data Source Recordset

(Clementoke) #1

Hi all,

Saddled with 4.6 and unable to climb higher at the moment, I'm trying to search a recordset pulled in from a MySQL database. I've created an asset listing page which lists the shadow assets of the recordset but I can't get them to link to a details page. I made the details page as another listing but just showing one entry at a time so users can use the previous and next buttons to scroll through the records.

I want the user to be able to click on an entry on the listing page and it takes them to the corresponding listing on the detail page.

Can anyone talk me through the Dynamic Input or the Asset Listing variables that might achieve this?

I haven't got the luxury of the Content filter in 4.10.

Cheers,

Clement

 

(Nic Hubbard) #2

You just need to setup the sorting the same for both of the asset listings. In the first asset listing you would create a link to the second asset listing and make sure to specify the asset position as the page number. E.g.:

<p><a href="%globals_asset_url:136735%?result_136735_result_page=%asset_position%">%asset_name%</a></p>

Then just configure the second, single page asset listing however you want.

(Clementoke) #3

Worked a treat! Do you know how I can adapt Nathan's solution http://forums.squizsuite.net/index.php?showtopic=11377&hl=%2Blisting+%2Bdatasource+%2Brecord+%2Bset to allow me to search or filter the listing?

(Nic Hubbard) #4

Worked a treat! Do you know how I can adapt Nathan's solution http://forums.squizsuite.net/index.php?showtopic=11377&hl=%2Blisting+%2Bdatasource+%2Brecord+%2Bset to allow me to search or filter the listing?

 

Have never done that, so not sure at this point...