Query builder

Radzen is using OData V4 services to query MS SQL, MySQL Oracle and PostgreSQL data source and you can use query builder to build visually filter and sort expressions for Invoke data source method action that will return collection of data (like getOrders() method from Northwind data source).

String values must be entered with literals. Date-time values can be picked with date-picker. You can use expressions (${}) to specify values.

Combine DataGrid column filters with initial filtering

Let’s build Orders by customer page with a DropDown component for Northwind Customers and DataGrid for selected customer Orders.

  1. Add DropDown component and bind it to Northwind Customers.
  2. Add DataGrid component and bind it to Northwind Orders.
  3. Handle DropDown Change event, set new Page customerId property equal to ${event.CustomerID} and execute ${this.grid0.load()} to reload the DataGrid.
  4. Open query builder for DataGrid LoadData event and add additional filter CustomerID equals '${this.customerId}'.
  5. Run the application, select customer and filter orders by customer.

We are here for you

Making our users happy is always a priority for us.