Okay
  Public Ticket #3495703
Row group option not available
Closed

Comments

  • Terrie started the conversation

    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,698
    Miloš replied

    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

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

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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