Okay
  Public Ticket #3687307
Not getting Details on Detail Page
Closed

Comments

  • Brian started the conversation

    On the Master-detail Setting, if settings are Open details on: Row Click; and Show Details in: Popup are set, once I click I the Detail. I get all the detail in a popup.

    However, if Open details on Row Click and Show details in Page; Template page is set to Dive Report Details and Send details over is POST. I get the Dive Report Details page showing the column slugs in typed in. The values are not coming through.

    In using the current version of wpdatatables and master detail plug in.


    Attached files:  SettingsPopup.jpg
      SettingsTemplateDetails.jpg
      PopupDetails.jpg
      DetailTemplatePage.jpg

  •  1,819
    Miloš replied

    Hi Brian,

    I am not sure I understood. Does this happen when you click from the actual table to get redirected, and it does not load the placeholder;

    or are you trying to visit the URL of the Master Details Page directly?

    -

    When you set the method as "POST", in this case, the Page URL can not be accessed directly to render column placeholder values.

    When we use POST, as explained in this Documentation - it can only pass the values when you click it from the actual table.

    if you visit this custom page directly, placeholders will be replaced with empty strings, so data will be populated only when you access this page from our table by clicking on Row or Button depending on your configuration.

    2. But we now have the new method to set it as "GET". In this case, each record/row from your Table will have its own unique URL with the row ID parameter, and it can be directly visited to load the values.

    I will show you some useful informations, our Documentation will be updated very soon, but here are the new features you can use right now :


    Starting from Master-Detail Tables version 2.0, when 'Show details in' is set to 'Page' or 'Post', you will see a new option called "Send details over" with two choices: "POST" or "GET".

    9777363768.png

    The POST method is chosen by default. It sends details associated with the Table ID and the Column ID from the selected/clicked row.

    - Limitation: With the POST method, the column placeholder values on your ‘Template Page/Post’ will only render when the user is redirected by clicking/selecting the row from the table. Directly visiting the URL of the 'more details Page' or 'Post' will only show empty column placeholders. -


     If you change this to the "GET" method, the details data associated with the table ID and the chosen column ID from the selected row will be conveyed through GET parameters, making the information accessible via the unique URL.

     In other words, this allows you to have a unique URL for each record/row in the table. 

    This URL can be visited directly, and it will render the column placeholder values without having to click the row or button from the Table.

    - Please note : If you choose the "GET" method, make sure to set your chosen "Parent/Child Table column Name". If you leave that option blank, you will see an error if you click a row from the Table and the Template Page won’t load/redirect.

    2525034287.png

    - It is recommended for that column to have unique values - because, for example if you have a repeating ID value in multiple rows, it will only take the first row and ignore other 'duplicate ID' rows. 

    The value from this column will be sent to the designated Post or Page as a "GET" parameter, making it accessible in the URL. Here is an example of how the URL will look if we click into a specific row from a Table which is configured like that.

    3551609873.png
    9641570868.png

    - Parent/Child Relation : If you choose “Send child Table Row Data” in the “Send table data” option, this can be used to make a relation between two tables based on a 'common ID field' between them. You need to choose which columns are used as the ‘Parent Table Column Name’ and the ‘Child Table Column Name’

    5380006920.png

    Then, the column placeholder values from the row with the matching ID between your chosen Parent and Child Table Columns will be rendered from the Child Table. 

    Please note : This will only be handled as a “One-to-One” relation by our Master-Detail Tables, it is not possible to achieve “one-to-many” relations. 

    For example, if you have multiple rows with the same ID in your selected Child Table’s “Parent Table Column Name”; In that case, it will only render the first row which matches the chosen ID and ignore any other ‘duplicate ID rows’. 

    That is why we recommended to use unique values for the relation columns earlier ( both parent and Child Columns). Send Child Table Data :

    -

     If you wish to load the entire Child Table, filtered by the selected unique row from the Parent table, choose “Send Child Table data”. For this to work, you need to insert this shortcode on the Template Page/Post : %wpdatatables_md_child_table% 

    3528301870.png
    9348926279.png


    Apologies for too many details.

    Let me know if that helped and if you encounter any issue with this logic.

    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

  • Brian replied

    Milos - Thanks for your reply. I switched to the GET method. See image below of Master-detail Settings. I created a simple 2 field "Details" page. But I'm still not getting data passed to the Details page. See 2nd image.

    The URL for the details page seems correct:

    https://2scubadb.com/details/?wdt_md_p_t_id=10&wdt_md_p_t_col_name=id&wdt_md_col_value=2

    But the values are not being passed.

    Brian


    Attached files:  Master Detail Settings.jpg
      Details Page.jpg

  •  1,819
    Miloš replied

    Hi Brian,

    Yes, that looks strange from the screenshots.

    Can we take a closer look remotely?

    Please provide me a temporary WP-admin (administrator) user 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 parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.


    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

  •   Brian replied privately
  • Brian replied

    Milos - were you able to get into the site and find the problem?  Thanks, Brian

  • Brian replied

    Milos - Have you had a chance to look into this? Any suggestions to fix the problem? Thanks, Brian

  •  1,819
    Miloš replied

    Hi Brian

    My sincerest apology, there was an error on this ticket from my end - I wrote a reply, but it somehow did not get sent properly.

    This will not happen again, thank you very much for your patience.


    Happy to report, I isolated and fixed this issue.

    It was just a small error in the column placeholder names on the Master Details Page.

    Basically, it was set for the 'displayed header name' while it should be the 'origin Header name' for these columns.

    So for the first column, I edited it with Elementor and changed from 'Title' to small letters 'title', and the 'Entry ID' to just 'id'.  Now it renders the placeholders correctly.

    1735787734.png

    1167650808.png
    3443260711.png
    3924908890.png
    8303780373.png
    5596406181.png

    Please check and let me know, everything should be fixed now.

    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

  • Brian replied

    Milos - Thanks. I have everything working now. Brian

  •   Miloš replied privately