How to filter results of linked SQL grouped and summed view from inside LightSwitch? RRS feed

  • Question

  • Hi

    I have a LightSwitch app which is linked to SQL db.

    now I have a problem that is:

    After I get the sum of SQL grouped by Product query, and I linked it to my LightSwitch application.

    I now need to filter the results of summed product quantities by date .. the date will be defined into one screen of my LightSwitch application.

    (Note: I can't make the sum SQL query contain the date field because I if so I shall select group by or first or something for the date field !!)

    how can I filter the results from inside the lightswitch app.???

    Thanks in advance


    Ehab, Egy.

    Monday, September 22, 2014 6:39 PM


  • HI Ehab,

    I read your previous thread that how to create totals Query in LightSwitch, as Michael suggested, you can use WCF RIA Service, it can query or sort on the computed value when used in a collection.

    Please let me know if there is anything that I can do to help.

    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 Friday, October 3, 2014 2:42 AM
    Thursday, September 25, 2014 9:36 AM