Database RG Question with Slug?

I have a database like this.

Products

  • Product name
  • Product price
  • Shops

Shop

  • Shop name
  • Slug (eg Shop1)
  • Users

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.
Thank you…

Just made a video explanation as it was easier to give a full on response with 3 different approaches

Learn More

Boston85719 is an expert Bubbler with a decade experience as an educator. Real name Matthew, he has been actively building SaaS apps, marketplace apps, scheduling apps and more for clients, himself and for sale as templates.

As an official Bubble Bootcamp Instructor, he leads Bubble Bootcamps on a regular basis.

Always willing to offer advice via the Bubble Forum, Matthew also offers Private Personal and Group Training Sessions.

Through his site, NoCodeTrainer, Matthew provides a range of tutorials with editor access to help you jumpstart your Bubble development.

Always accessible you can send Matthew a private message via the forum or send an email directly with your requests.

Be sure to checkout the Stripe Integration Course when you are ready to integrate Stripe payments to start monetizing your application via product sales or subscriptions.

Stripe Integration Course

NoCodeTrainer.com

2 Likes

Hi @boston85719,
I just tried and yes it works. Thank you for the help with the video. :slightly_smiling_face:

1 Like