locked
Filter a preloaded lightswitch grid on check box click basing on date column in the grid RRS feed

  • Question

  • Hi Team Lightswitch,

    I am working on a search screen in lightswitch with silverlight client. I know how to bind the check box to the grid's boolean field and then filter. But the requirement is to filter entire grid basing on date field nullable myDateField is not null on check box click. Can any body provide me guidance. Thanks in advance!!

    Monday, June 15, 2015 6:51 AM

Answers

  • Hi Hemakiran,

    This will help you on this scenario, and Beth's suggestion is available.

    Reference: How can I use a checkbox to determine if a string is null or empty on a custom query screen

    With regards,

    Angie


    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.

    • Proposed as answer by Otis Ranger Wednesday, June 24, 2015 10:09 AM
    • Marked as answer by Hemakiran Thursday, June 25, 2015 4:26 AM
    • Unmarked as answer by Hemakiran Thursday, June 25, 2015 4:27 AM
    • Marked as answer by Hemakiran Thursday, June 25, 2015 4:31 AM
    Wednesday, June 24, 2015 7:28 AM

All replies

  • Hi Hemakiran,

    This will help you on this scenario, and Beth's suggestion is available.

    Reference: How can I use a checkbox to determine if a string is null or empty on a custom query screen

    With regards,

    Angie


    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.

    • Proposed as answer by Otis Ranger Wednesday, June 24, 2015 10:09 AM
    • Marked as answer by Hemakiran Thursday, June 25, 2015 4:26 AM
    • Unmarked as answer by Hemakiran Thursday, June 25, 2015 4:27 AM
    • Marked as answer by Hemakiran Thursday, June 25, 2015 4:31 AM
    Wednesday, June 24, 2015 7:28 AM
  • Thank you Very much Angie..

    i can able achieve the requirement by writing my code in preprocessor method of the screen as follows, Beth suggestion helped me alot.

    If (onScreenBooleanOptionalFilter.HasValue) Then
     If (onScreenBooleanOptionalFilter.value = False) Then
        query = query.Where(Function(a) Not a.myNullableDateColumn.HasValue)
    Else
        query = query.Where(Function(a) a.myNullableDateColumn.HasValue)
     EndIf
    
    EndIf

    With Regards,

    hemakiran.

    Thursday, June 25, 2015 4:39 AM