According to the documentation I'd expect that I could further refine results within the AMPscript ExecuteFilterOrderedRows() function.
What we want our pages to do is to display the results within a filter and then use a RequestParameter() function to limit those results to those with a matching ID field. I already know the parameter is being captured on the page as it's used to gather additional info (like a product name) and appears correctly within the title tag and an H1 on the page itself.
ExecuteFilterOrderedRows("FILTER-stuff", 0,"Date", "prodID", @PL)
My expectation is that the filter would return a rowset parsed from FILTER-stuff, ALL rows, ordered by date, where the "prodID" matches the @PL requested parameter.
The filter itself looks at all items in the data extension and simply filters for Date > today. It also looks at "prodID" field from the extension to simply verify that prodID > 0 (since prodID is a number field all should be > 0) is "null" > 0? and even if it was I expected the AMPscript to return only results where "prodID" == @PL (always a #).