locked
Search and Querying on one parent table and two children tables RRS feed

All replies

  • It's not possible to do it at client side, you have to do it at server side.

    So, you will need to pass the filter conditions to server side by Query parameters, then do the filter at server side in XXX_ProcessQuery method.

    Saturday, July 21, 2012 2:49 AM
  • Thanks Ryan, I was hoping for an easier solution, I will try to follow your suggestion.

    Rachida


    Rachida Dukes

    Saturday, July 21, 2012 12:57 PM
  • Rachda, I really hope there is a better solution too, but for now, the LINQ supported at client side is too weak, there is no group by , there is no aggregation, there is no sub-select...

    Let's just hope it be improved in future version.

    For filter scenario, you can look at the Filter Control Extension,  the filter control actually generate a filter string then pass it to server side, the server side do the actual filter. Although it not supported the child collection filtering, but it should be easy to make it work.( I've done something same, which support child-collection filtering ).

    Hope it helps.

    Saturday, July 21, 2012 4:15 PM