Sort and Filter Data on a Screen in a LightSwitch Application

Using this article one can sort and filter business application data. In this article I tell you how to sort and filter data on screen in LightSwitch application.


Introduction

LightSwitch is a Microsoft application which is used for create the business application. Using this article one can sort and filter business application data. In this article I will tell you how to sort and filter data on screen in a LightSwitch application.

Sort and Filter Data on a Screen in a LightSwitch Application step by step.

Step 1. First of all we created a table(Customer) in LightSwitch likes below image.

faltu.gif

Step 2. Screen-> Right click-> Add screen-> Editable grid screen-> Select Customer-> Ok.

image1.gif

Step 3. Now run application-> Click editable customer grid-> Click + sign-> Fill data-> Ok-> Save-> Refresh-> Close page.

image2.gif

Step 4. Click edit query.

image3.gif

Step 5. Add sort-> Save.

image4.gif

Step 6. Customer table-> Right click-> Add query.

image5.gif

Step 7. Change query name (SortCustomer)-> Add sort-> Save.

image6.gif

Step 8. Screen-> Right click-> Editable grid screen-> Select screen data (sort Customer)-> Ok.

image7.gif

Step 9. Customer table-> Right click-> Add query-> Change query name (filter Customer)-> Add filter (write query)-> Select source (sortcustomer)-> Save.

image8.gif

Step 10. Screen-> Click editable sort customer-> Add data item-> Click query-> Select filter Customer-> Ok.

image10.gif

Step 11. Now add-> Filter Customer.

filter.gif

Step 12. Now run application-> Click editable Customer grid-> Click + sign-> Fill data-> Ok-> Save-> Refresh.

image12.gif

Summary

So this article is very useful for sorting and filtering data on a screen in LightSwitch application. Using this article one can easily understand how to sorting and filtering data on screen in LightSwitch application.