Ask yourself - - > what exactly is a - - > DYNAMIC-PAGE ?
You know it?
Your answer is —> it is just a data-row inside your database?
Yes, you are right!
So if it is just a data-row inside of your database, how does it work ?
At least you will have one pseudo-page (mask-page) which will have all needed control-elements, like buttons, texts, dropdowns, repeaters and so on.
This page is connected directly to your database, either by a → DATASET <–, or by → CODE <–.
If you create your dynamic page by a (dynamic-) DATASET, you will get inside of your connected DATABASE a “greyed-out” DB-Field. This data-field is a dynamic one, which should be the key to your solution.
If you do it only by code, you will have to use Wix-Data and generating some filtering-function, to get the result you are searching for (and again → out of your database) but this time directly by code.