Filtering Database Query with an URL Parameter


#1

If you don’t know how to define an URL parameter on your page, please check this tutorial as you will need this later.

First, we need to create a server action. Open the server connect panel and click the add new button:

We call it product_details:

Then right click GET under Globals menu:

Add variable:

This variable will be used to filter our database query. Let’s call it: productid (NOTE - it needs to be lowercase).

Right click steps:

Open database actions menu:

Add a database connection:

Load your database connection, or create one if you have not defined one yet. Then right click the database connection step:

Open the database actions menu:

And add database query:

Open the query options:

Add your database table:

Then add the database table columns you need:

Open the conditions tab:

And select the column you want to filter your database query by:

Select the equal operator:

And click the dynamic data picker for the filter value:

Select the GET variable we created - productid:

Then click ok:

Save your server action and close the server connect panel as we won’t need it anymore:

In App Structure define your URL parameter using the query manager:

Then add new component:

Open the data menu:

Select Server Connect:

And click the select server action button:

Select your server action:

Under Input parameters, you will see the GET variable which you defined in the server action. Ours is called productid - click the dynamic data picker to assign a dynamic value to it:

Under query select the URL parameter you defined:

Then on your page, double click where you want to show the dynamic data:

Click the dynamic data picker button:

And select the data you need here, from your server action:

That’s it your data will be filtered using the URL parameter’s value and you will see it on the page.


WapplerPrevious   WapplerNext



Define URL Parameters
ASP.NET: How to filter a query with URL parameter?
Wappler Official Documentation
Server Connect Introduction