I have a database like this.
- Product name
- Product price
- Shop name
- Slug (eg Shop1)
And I have a RG with Content & Datasource to table Products.
But I would like to show the Products data, with Shop slug name = Get Path URL (./shop1)
Because I only want to show data based on the Path of the Shop. (./shop1, ./shop2)
Need help on how can I do that ? in normal SQL i would have to join.