Index

  1. Home
  2. Docs
  3. Index
  4. Data Publisher
  5. Master detail publication

Master detail publication

It is possible to combine two publications to create a master detail page. This gives you more flexibility for both, the master and the detail publication. The master publication shows the table with a dynamic hyperlink to the detail page. When the users clicks on the dynamic hyperlink the bike id is used to show the detail publication.

Inline demo

Click on a Show Bike Details hyperlink to see the detail page.

BrandBrand TypeColorShow Bike Details
BrandBrand TypeColorShow Bike Details

Shortcode used for this master page

[wpdataaccess pub_id="7"]

Master publication

Show only the most important columns and add a dynamic hyperlink to the detail publication. Dynamic hyperlink used for this publication:

https://wpdataaccess.com/data-publisher-detail-page-demo-detail/?wpda_search_column_bike_id=$$bike_id$$

Detail publication

Make sure you select only one row in your dynamic hyperlink! And set the following options in your publication:

Number Of Columns = 1

Type = Expanded

Show Icon = No

Allow ordering? = Disabled

Table options (advanced) =

{
	"dom": "t",
	"pageLength": 1,
	"initComplete" :"function (oSettings){jQuery('#' + oSettings.sTableId + ' tbody').off();}"
}

Credits

The idea to combine two separate publications into one master|detail publication came from Charles Godwin. Charles is also the author of the alternative WP Data Access search algorithm extension.

Thank you Charles!

Was this article helpful to you? Yes No

3 Replies to “Master detail publication”

  1. Hi Peter,

    I have published data table to my website using the generated shortcode.
    Now I want to edit text in one of the varchar columns due to a spelling error in the data table. I select Data Explorer, hover over the table name and click the Explore link. The next screen (Premium Data Explorer) shows a message “No Data Found”, even though I know the data table contains 4 rows of data.

    Is it possible to edit the individual field text once a data table has been published ?

    Thanks
    Mark

    1. Hi Mark,

      Yes, you can use the Data Explorer to edit your table. I read your review in which you said you like the Google like search and I guess this issue is related to this type of search. When you configure a table to use the Google like search, this search type is used everywhere. Just perform a search in the Data Explorer and your data will be there.

      BTW, the Google like search is currently only available on table level. Some plugin users have ask to configure it for specific publications and projects as well. This will be added later to allow you to work with normal searches in the Data Explorer.

      Thank you for your review! 🙂

      Hope this helps,
      Peter

      1. ahhhhh got it, thanks Peter that was indeed the issue. Appreciate the quick response!

        Good to hear, its a great feature of this plug in.

        Regards
        Mark

Leave a Reply

Your email address will not be published.

1 × 1 =