Articles → LIGHT SWITCH 2011 → Apply Filters On Data In Light Switch 2011

Apply Filters On Data In Light Switch 2011

In this tutorial how to apply filter on data in Light Switch.

Implementation

First of all add a new screen in the project. The screen type which I am adding in this tutorial is "Editable Grid Screen".

Picture showing adding a new Editable Grid Screen

Click to Enlarge

Once you click Ok a screen will be added in Screen folder. For this tutorial I am using Employee entity.

Picture showing design view of Employee table in Lightswitch

Click to Enlarge

Consider a scenario in which you are creating a screen where have to set the eligibility criteria for the employee. The criteria is only those employees having the experience more than 2 years are eligible to attend a training session.

First of all add data into the table. See the figure below I have added 3 records in the table.

Picture showing Editable Grid Screen in lightswitch

Click to Enlarge

Here the employee Narendra and Sumit are eligible to attend the training, but Abhishek is not eligible.

To add a filter go to the designer screen and click on Edit Query

Picture showing how to open a filter screen using design screen

Click to Enlarge

Once you click on the link a screen appears as shown in figure below

Click to Enlarge

Click on Add Filter button to add filter criteria. When you click on the button a row is added as shown in the figure below

Picture showing adding a filter named Experience

Click to Enlarge

Here select the field i.e. Experience, the operator i.e. greater than and finally enter the value i.e. 2. You can add more filters by clicking on +Add Filter button. Save the record and close the designer window.

Now run the screen

Picture showing the output of Editable Grid Screen with filter

Click to Enlarge

As you can see from the screen the employee Abhishek is not showing in the list as the filter is applied on data.

Posted By -	Karan Gupta

Posted On -	Tuesday, January 3, 2012

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**