HTML Client dropdown of selectable values from distinct values in a table RRS feed

  • Question

  • Hi

    I want to add a parameter on the browse screen that displays a dropdown populated from a list of distinct values from a table.

    The table contains multiple columns so this needs to be filtered down to return a single column of distinct values (SELECT DISTINCT COL FROM...)

    Is this possible? How would I achieve this?

    Friday, October 3, 2014 4:02 PM


  • Hi,

    You could write SQL queries in a WCF RIA service.

    You can run LINQ queries in screen code behind.

    For more information about how to use WCF RIA services, please see link below:

    # Creating a WCF RIA Service for Visual Studio LightSwitch


    Best Regards,

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Angie Xu Monday, October 13, 2014 2:47 AM
    Monday, October 6, 2014 9:03 AM