The shortcode [wpdataaccess] does not display the relationship.

Hi @sistemes,

Thanks for getting in touch!

The Data Publisher supports only one table per publication. Sorry! Relationships are only supported in Data Projects.

You have a number of options to solve this issue:
(1) Create two publication (master+detail) that work together like a relationship
(2) Make your Data Project read-only and use it as a pubication
(3) Since you have a premium license you can use Data Forms (!)

(1) Here is a demo including an explanation:
https://wpdataaccess.com/demos/demos-data-publisher/data-publisher-detail-page-demo/

(2) To make your project read-only, open your project, edit the project page which you want to make read-only and set mode to ‘View’. Add the project shortcode to your page to view your relationships on a public website.

(3) Data Forms is the premium way to use Data Projects. You first need to make the project page read-only as described in option (2). After that you can just use one of the Data Forms shortcodes: wpdadataproject and wpdadataforms. Here is demo of each shortcode:
https://wpdataaccess.com/docs/documentation/data-forms/project-demo/
https://wpdataaccess.com/docs/documentation/data-forms/page-demo/
The demos are read-only as well. You can select your own style:
https://wpdataaccess.com/docs/documentation/data-forms/overview/#styling

Does this helps?

Best regards,
Peter

Hi Peter, thank you for your time and for your quick response. Your options are great. I have duplicated the project only in read mode. But, I would like to be able to choose the columns that are shown in public and also customize the search box.

In “Data publishes” in “Column Names (* = all)”, you can select the columns and it also has “Advanced settings” where you can host custom code, for example

{
“wpda_searchbox”: “header”,
“wpda_search_placeholder_prefix”: “icon”
}

“Data Projects” does not have those options.

Is there a way to customize the view with some shortcode? Is there a way to select only the columns that I want?

Hi @sistemes,

Sorry for my late response! I was on holiday.

You can customize project as well but this works with templates. Here is a tutorial:
https://wpdataaccess.com/docs/documentation/data-projects/overview/

Please let me know if this helps,
Peter