Column grouping in RIA service

13 posts, 0 answers
  1. Maciej
    Maciej avatar
    2 posts
    Member since:
    Nov 2010

    Posted 16 Nov 2010 Link to this post

    Hello,

    I'm developing an Silverlight application using RIA services (with DomainDataSource load size of 50), dataGrid, and DataPager (with page size of 10). I would like to group my data by selected column which has 12 different values. And here is the problem: insted of getting 10 first groups (two other are on second page of pager), I only get 10 first grouped results (with 5 pager pages available). Is there any way to change that behaviour and group whole 50 result, or even better whole data accesible in database table? It was working fine in webservice approach, unfortunately i have to use RIA.
  2. Rossen Hristov
    Admin
    Rossen Hristov avatar
    2478 posts

    Posted 16 Nov 2010 Link to this post

    Hello Maciej,

    Unfortunately, WCF RIA Services do not support real grouping. When you group on the server, it simply sorts the data according to the grouping, but it does not perform real grouping, i.e. it does not return groups. Instead it returns sorted Entities.

    Unless MS decide to implement grouping -- there is nothing that can be done as far as grouping on the server is concerned.

    I hope this helps.

    Sincerely yours,
    Ross
    the Telerik team
    See What's New in RadControls for Silverlight in Q3 2010 on Tuesday, November 16, 2010 11:00 AM - 12:00 PM EST or 10:00 PM - 11:00 PM EST: Register here>>
  3. DevCraft banner
  4. Maciej
    Maciej avatar
    2 posts
    Member since:
    Nov 2010

    Posted 16 Nov 2010 Link to this post

    Thank you for fast reply Ross.

    Regards,
    Maciej.
  5. Jonx
    Jonx avatar
    258 posts
    Member since:
    Jul 2012

    Posted 19 Jan 2011 Link to this post

    Helo Ross,
    Does your RadDomainDatasource solve the problem?
    It seems to me that it doesn't but maybe I missed something.

    I have the same problem then Maciej, It does only group the items on the current page which is useless...

    Any hints about how this may be done by "hand"?

    Thanks,
    John. 
  6. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 20 Jan 2011 Link to this post

    Hello,

     RadDomainDatasource will work in this case exactly like regular DomainDatasource since our component is just a client for WCF RIA Services. The data source will just tell the service to return groups and it is up to the service how this grouping will be created and returned. 

    Kind regards,
    Vlad
    the Telerik team
    Let us know about your Windows Phone 7 application built with RadControls and we will help you promote it. Learn more>>
  7. Jonx
    Jonx avatar
    258 posts
    Member since:
    Jul 2012

    Posted 20 Jan 2011 Link to this post

    I understand... Thank you for the explanation...

    But know, woud you have any idea where I should start to make things rights by myself?
    Where would you start?

    Maciej, you say it's working with webservices? Would you be so kind and point me to an exemple somewhere working with webservices?
    That yould be so helpful to me,
    Thanks a lot in advance...

    John.
  8. Jonx
    Jonx avatar
    258 posts
    Member since:
    Jul 2012

    Posted 03 Feb 2011 Link to this post

    Still... What alternatives do I have?
    Could the VirtualQueryableCollectionView be a solution?
    I absolutely need to find a way...
    Any hints?
    Thanks a lot in advance,
    John.
  9. Jonx
    Jonx avatar
    258 posts
    Member since:
    Jul 2012

    Posted 03 Feb 2011 Link to this post

    What about the new DomainCollectionView added in SP1?
    Does it also have the same limitation in terms of grouping?
    Thank you for your help guys...
  10. Jonx
    Jonx avatar
    258 posts
    Member since:
    Jul 2012

    Posted 03 Feb 2011 Link to this post

    Ok after that post I wait for an answer before adding a new post ;)

    I just stumbled on that post of yours Vlad:
    http://blogs.telerik.com/vladimirenchev/posts/10-01-14/how_to_server_sorting_filtering_grouping_and_paging_with_radgridview_for_silverlight_without_wcf_ria_services.aspx

    Is this what I was looking for ? A grid with grouping working correctly with a pager ?

    Thank you for your help ;)

    John.
  11. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 04 Feb 2011 Link to this post

    Hello,

     The approach in this blog post is not related to RIA services - I've used plain WCF service to achieve this. 

    Greetings,
    Vlad
    the Telerik team
    Let us know about your Windows Phone 7 application built with RadControls and we will help you promote it. Learn more>>
  12. Jonx
    Jonx avatar
    258 posts
    Member since:
    Jul 2012

    Posted 04 Feb 2011 Link to this post

    If it's the only way to get working groups, I'll go that way.

    Can you please confirm, the groups are working correclty before I try to go down that road?

    Thanks...
  13. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 04 Feb 2011 Link to this post

    Hello,

     You can download the group items in this way however currently the virtual collection will not virtualize groups - this is still not supported. We have plans to improve this however we don't have any clear release date for such feature so far. Once we have more info we will announce it publicly. 

    Best wishes,
    Vlad
    the Telerik team
    Let us know about your Windows Phone 7 application built with RadControls and we will help you promote it. Learn more>>
  14. Jonx
    Jonx avatar
    258 posts
    Member since:
    Jul 2012

    Posted 05 Feb 2011 Link to this post

    Ok Vlad,

    I guess that I will use standard filtering for now instead of grouping and wait for better solutions.

    Thank you for your help.
Back to Top
DevCraft banner