Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #3495703
Row group option not available
Closed

Comments

  • Terrie started the conversation
    October 10, 2023 at 6:16pm

    I am trying to create a table where I can group by category. This sample table has a few categories, but the group row setting is not showing up. It is NOT a server-side table, so not sure what the issue is. I also noticed that when looking up solutions, the back-end table settings/editing options look completely different than some I see in samples (see attached screenshot w no group option...it's not showing up in any of my columns). 

    This site is built using Genesis Dynamik theme and uses Beaver Builder. I have this same configuration on a different site with no issues, so wondering if it may be a plugin conflict, but most plugins I'm using are on the other site as well. So I'm stumped :/

    Attached files:  Screenshot 2023-10-10 at 11.15.01 AM.png

  •  1,847
    Miloš replied
    October 12, 2023 at 3:52pm

    Hi Terrie,

    Sorry for the late reply.

    -

    As far as i see by inspecting the HTML of your Page, this is a Manual Table type?

    Manual Tables have a server-side processing in the background which can not be disabled.

    As a workaround, you can make an additional SQL Query based table which will pull the same data,

    and any editing you do on it will reflect the original Manual Table.

    First, check under Editing Tab, what is the MySQL Table Name,

    then make an additional SQL Table like :  SELECT * FROM TableName.

    After this, just disable the server-side processing in the Data Source Tab ( if the table has less than 2 thousand rows),

    and you should be able to choose a column for the Grouped feature.

    Let me know if that helps.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables