Okay
  Public Ticket #3692486
Master-Detail wdt_ID reference
Closed

Comments

  • David Szostek started the conversation

    Hi,


    When I reference %wdt_ID% on the detail page, it is adding a comma after the id reaches 1,000. That is making references that receive the id not work because the field won't match. Is there a way to tell it to not pass a comma for int fields or for a specific field call or even just that one field?


    Thanks,

    David

    Attached files:  Screenshot 2024-07-24 113550.png
      Screenshot 2024-07-24 113449.png

  •  1,805
    Miloš replied

    Hi David,

    You are right, this is a new bug we have for the "GET" method of sending the Master Details Parent Table ID, when the integer reaches 1000 or higher, it adds that comma separator and does not work correctly.

    Our Developers made a fix. This will be added to a new Master Details add-on update as soon as possible, I just can't say an exact ETA yet, but you can apply this fix and it should work.

    So far, we have a couple of users who report it works for them and it also works for our Test sites.


    Here are the instructions if you wish to try it on your Site.

    Find this PHP file in our Master Details add-on folder on your FTP on the Hosting server or the Hosting File Manager, this is the path : ../wp-content/plugins/wdt-master-detail/wdt-master-detail.php

    around line 1069 you will see a function getDetailsDataArray, find this line of code :

    if (in_array($childTableData->table_type,[ 'manual','sql'])) {

    replace it with this :

    if (in_array($childTableData->table_type,[ 'manual','sql']) || ($childTableData->table_type == 'mysql' && $childTableData->server_side)) {

    Save the changes, then check, the bug should be fixed, try to load any row from the Table which has the chosen Parent Table Column ID higher than 999 and see if the placeholders load on the Template Page via the "GET" method.

    Let me know how it goes.


    If you need us to edit that file for you, we will need URL of your Site, Administrator User credentials, and FTP credentials (please also confirm the path to the WordPress Folder on the FTP for us, to save time - you can check that with the Hosting Support if you're not sure).


    Then we can remote in and edit the code for you, then we can test the Master details Page again with the "GET" method.


    If you send us access, just ensure it is a PRIVATE reply for security, then only we can see it.


    If you can just also confirm the Table ID which is setup for the Master Details.


    Thank you.


    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