Filtering Data with Queries

Filtering Data with Queries in LightSwitch

 

In LightSwitch, you can use queries to work with a subset of data. For example, instead of displaying all orders, you can use a query to display orders for customers in a certain country or region.

In this set of lessons you’ll learn how to create both simple and parameterized queries and apply them to screens.

System_CAPS_noteNote

These lessons build upon the My First Application project that you last modified in the Displaying Local Information in a LightSwitch Application lesson. If your application isn't already open in Visual Studio, on the menu bar, choose File, Open Project to open it.

Read this lesson

To learn

Creating a Basic Query in LightSwitch

How to create a basic query in the Query Designer.

Creating a LightSwitch Screen Based on a Query

How to create a screen to display the results of a query.

Creating a Parameterized Query in LightSwitch

How to create a query that includes a value determined at run time.

Using a Parameterized Query on a LightSwitch Screen

How to display the results of a parameterized query.

Show:
© 2016 Microsoft