Data Grouping

  • Resolved Mason Lam

    (@masonlam)


    3 years, 10 months ago

    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 to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    3 years, 10 months ago

    Hi @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-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

    (@peterschulznl)

    3 years, 9 months ago

    Hi @masonlam,

    Did you get this to work? Can I close this issue?

    Thanks,
    Peter

    Thread Starter Mason Lam

    (@masonlam)

    3 years, 9 months ago

    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

    (@peterschulznl)

    3 years, 9 months ago

    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.