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.
Step 2. Screen-> Right click-> Add screen-> Editable grid
screen-> Select Customer-> Ok.
Step 3. Now run application-> Click
editable customer grid-> Click + sign-> Fill data-> Ok-> Save-> Refresh-> Close
page.
Step 4. Click edit query.
Step 5. Add
sort-> Save.
Step 6. Customer
table-> Right click-> Add query.
Step 7. Change query
name (SortCustomer)-> Add sort-> Save.
Step 8. Screen-> Right
click-> Editable grid screen-> Select screen data (sort Customer)-> Ok.
Step 9. Customer
table-> Right click-> Add query-> Change query name (filter Customer)-> Add filter
(write query)-> Select source (sortcustomer)-> Save.
Step 10. Screen-> Click
editable sort customer-> Add data item-> Click query-> Select filter Customer-> Ok.
Step 11. Now
add-> Filter Customer.
Step 12. Now run
application-> Click editable Customer grid-> Click + sign-> Fill
data-> Ok-> Save-> Refresh.
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.