Okay
  Public Ticket #1659548
Child rows
Closed

Comments

  • kacem78 started the conversation

    Hi All

    Thanks for this great plugin, i may confess that i spent a hell of time looking for such a plugin, i finally found it, thanks again

    i started my project,  and the row child feature is a must for my project; as a workaround i'm using the responsive function to mimic this feature, however it would be nice to implement it with more freedom as linking a master view with a child view and have the capabilities to design the child view as any other table. 

    if this requires specific customization, then i'm ready to talk.

    there are a few bugs that i will escalate in another tickets, mainly related to column calculation when the grouping features is enabled. numbers are confusing

    other limitation are in drawing charts with the follow filtering table,  if you have one table and multiple chart on the same page,  only One chart is updated not the other ones. 

    BR 

    Kacem

  •  471
    Isidora replied

    Hi kacem78,
    Thank you for your purchase.

    Master detail feature is on our TO DO list and  I hope very soon we will start developing on this feature.

    Can you please explain me in little more details about issue with calculations when you are using grouping option? Which data source you are using? What exactly you mean by "numbers are confusing"?

    Can you please tell me did you turn on Follow table filtering on all charts that you made from that table?

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

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

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables

  •   kacem78 replied privately
  •  471
    Isidora replied

    HI kacem78,

    Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

    Also provide me table id's where you have issue with sum and also table id which you use for crating charts and ids of charts that is not updated when you filter the table.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

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

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables

  •   kacem78 replied privately
  •  471
    Isidora replied

    Hi kacem78,

    You have issue because of the query that you use for this table. Because you  use GROUP BY in query and  wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (happens rarely, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.

    Please note some this when working with the server-side processing feature:

    • Please do not use “LIMIT” in the SELECT statement. wpDataTables adds it automatically and it will be overridden.
    • Please do not use “ORDER BY” in the SELECT statement. wpDataTables has its own sorting engine so it makes no sense to use MySQL’s sorting, since it will be overridden. Also server-side processing feature adds this part of statement automatically when users triggers the sorting on the front-end, and having it in initial statement may cause the table to crash.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

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

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables