Title: Data Grouping
Last modified: August 11, 2022

---

# Data Grouping

 *  Resolved [Mason Lam](https://wordpress.org/support/users/masonlam/)
 * (@masonlam)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/data-grouping/)
 * Hello, I would like to know if there is a way to group data based on a field (
   such as an ID) and display this as a grouping. We have restaurants that we’d 
   like to show the inspection history for each. We’d like the user to search for
   a restaurant, and then be able to click on it to see the past few inspections,
   either in a pop-up details or some other way. Is this possible with WP Data Access?
   If so, do we need the premium version to do this? Thank you!
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdata-grouping%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/data-grouping/#post-15908588)
 * Hi [@masonlam](https://wordpress.org/support/users/masonlam/),
 * WP Data Access supports row grouping in both, the free and premium version. A
   demo including an explanation is available here:
    [https://wpdataaccess.com/row-grouping-client-side/](https://wpdataaccess.com/row-grouping-client-side/)
   [https://wpdataaccess.com/row-grouping-demo/](https://wpdataaccess.com/row-grouping-demo/)
 * The first link demonstrates row grouping with client-side processing. The second
   link with server-side processing. Since your table contains 1683 records, I would
   advise to use the client-side solution as it allows sorting inside a group. The
   server-side solution does not support sorting.
 * You need a little json and javascript knowledge to add row grouping. Please have
   a look at the demos and let me know if this helps…
 * Best regards,
    Peter
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/data-grouping/#post-15930662)
 * Hi [@masonlam](https://wordpress.org/support/users/masonlam/),
 * Did you get this to work? Can I close this issue?
 * Thanks,
    Peter
 *  Thread Starter [Mason Lam](https://wordpress.org/support/users/masonlam/)
 * (@masonlam)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/data-grouping/#post-15931935)
 * I sort of created a solution a different way: using the details pop-up to display
   previous inspections. I pivoted the data before uploading, creating columns for
   each inspection (up to 4). These show in the details when a row is clicked. Anyway,
   it keeps the record count much lower so performance is better and it works more
   the way we wanted in the UX. Thanks for your help! -Mason
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/data-grouping/#post-15933700)
 * Smart solution! 😊
 * Thanks for reporting back,
    Peter

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Data Grouping’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [3 years, 9 months ago](https://wordpress.org/support/topic/data-grouping/#post-15933700)
 * Status: resolved