Running a filtered query on a new page

Ask us anything
1

Hi,

I have 2 tables - orders and shipments which are joined by order_id. I have a page which shows the orders and I have created an onclick action that sets a variable to the orderid once the order number has been clicked. The action then navigates to the shipments page which is supposed to list all shipments associated with this order.

I have a collection which pulls the data from the shipments table filtered on the orderid.

image
image938×713 50.9 KB

When I get to the shipments page how do I run the fetch collection with the orderid that has been selected?

Thanks

2

Hey Steve,

There are two ways to approach this:

Option 1: Store the order information associated with the clicked order ID in a variable. This is straightforward to implement, but the downside is that the data is stored on the frontend, making it less secure.

Option 2: Set up an API call from Xano to retrieve the order details dynamically. This approach is more secure and scalable.

To help with setting up dynamic collection pages for displaying order information on a new page, check out this video from the WeWeb Academy.

Hope that helps!

1 Like
3

@ishika Thanks. I am running Supabase but will watch the video and work my way from there.

1 Like