Data Publisher, remove column names from footer

Hi Stefanie,

You can use css to hide the footer:
.wpda-datatable tfoot {
display: none;
}

Is this what you are looking for?

Best regards,
Peter

Hello,
yes, thank you very much ??

I am just starting to use your plug-in. Is there a way to have links to other tables in a table view? So if I have a table “dept” in the data publisher, that I could click in one column and would get an overview over another table (i.e. employees), which is selected by the ID of the department?

So let′s say it should then be
“Select * from employees where department_id = dept.id”?

Kind regards,
Stefanie

Hi Stefanie,

>>> yes, thank you very much ??

Great! ??

>>> Is there a way to have links to other tables in a table view?

There are a number of options to achieve this result:
(1) Use dynamic hyperlinks (within the Data Publisher)
(2) Use Data Projects with shortcode wpdadiehard
(3) Use Data Projects with shortcode wpdadataproject
(4) Use Data Projects with shortcode wpdadataforms

Option (1) and (2) are free. Options (3) and (4) are part of the premium version.

(1) Described here:
https://wpdataaccess.com/docs/documentation/data-explorer/table-and-view-settings/
See: dynamix hyperlinks

Additionally you will need this documentation:
https://wpdataaccess.com/docs/documentation/data-publisher/adding-filters/
See: URL parameters

(2) Start here:
https://wpdataaccess.com/docs/documentation/data-projects/styling-a-project-page/
And let me know if you have questions.

(3) and (4) Are new in version 4
I haven’t paid much attention to the documentation yet, but this is super easy and state of the art. Here are the introduction and some demos:
https://wpdataaccess.com/docs/documentation/data-forms/overview/
https://wpdataaccess.com/docs/documentation/data-forms/project-demo/
https://wpdataaccess.com/docs/documentation/data-forms/page-demo/

What do you think?

Best regards,
Peter

Hello Peter,

thank you very much for your help.
I will let you know how it goes.

Have a great day ??

Hello Peter,

I was taking a closer look and what I need is actually that instead of having the “view” build-in functionality, I would like to have that exact functionality in another column and always visible.

I was trying to use one column as a hyperlink column but it always needs the exact key but I want to display the “child table data”, so it would be more than only one record (just like “view table rows” does).

I hope you understand what I mean. So I have a list of cemeteries (yes, I know, it′s a little weird) and for each cemetery I would like to have one column that would be a count of all the graves, that are associated with that cemetery. Then I would like to have a link there “view graves”, where it would be a select on the grave table with cemetery_id as the one that is chosen in the list.

Kind regards,
Stefanie

Hi Stefanie,

Thank you for your explanation. Let me see if I understand your question correctly…

(1) Every cemetery has a number of graves. Correct?
(2) You want to view the list of cemeteries on a web page. Correct?
(3) When a users clicks on a cemetery, the gaves for that cemetery are show in a list. Correct?

Presuming these requirements are correct, you would need to create two tables:
(1) cemeteries
(2) graves (needs something like a cemetery id to maintain the relationship)

You can add table cemeteries to a Data Project page with a one to many relationship to table graves and use wpdadataforms to show this relationship on a web page. If you set your Data Project page mode to view, users will not be able to update any information. You can add a second page for data administration. That page can use the same settings, you just need to set the mode to edit and limit access to it.

Does this make sense to you? Let me know if you need help.

Best regards,
Peter

Hello Peter,
thank you for your quick reply.
Yes, you understood my problem correctly.

I did that, I have a data project with a page where the cemeteries are displayed and under the build in “view” in the first column the graves of that cemetery get displayed.
See here: bluszytn.stefaniescheidgen.com/

Is is possible that instead of the build in “view” I could use that functionality and have a link that says “view graves” or something like that, in one of the columns? Because the functionality is there in the javascript.

Kind regards,
Stefanie

Hi Stefanie,

Thank you for sharing the URL!

>>> Is is possible that instead of the build in “view” I could use that functionality and have a link that says “view graves” or something like that, in one of the columns?

Sorry, you cannot change those labels from the plugin settings. You can use javascript to achieve that result, although I don’t like that solution.

But you can add a dynamic hyperlink to your table. Much better! ?? A dynamic hyperlink allows you to define your own labels. Dynamic hyperlinks are explained on this page:
https://wpdataaccess.com/docs/documentation/data-explorer/table-and-view-settings/

Let me know if you need further assistance.

Bets regards,
Peter

Hello Peter,

yes, I did that but it looks like that it only works when the primary key is present in the query.

So if I use:
https://bluszytn.stefaniescheidgen.com/wp-admin/admin.php?page=wpda&table_name=Grave&action=listtable&action=view&ID=$$ID$$”
it shows the particular grave by ID.

But when I use:
https://bluszytn.stefaniescheidgen.com/wp-admin/admin.php?page=wpda&table_name=Grave&action=listtable&action=view&ID_Cemetery=$$ID$$”
it show an error message “ERROR: Wrong arguments [missing key value]”

Is there something I have to configure additionally?

Have a nice Christmas,
Stefanie

• This reply was modified 3 years, 11 months ago by stefaniescheidgen.
• This reply was modified 3 years, 11 months ago by stefaniescheidgen.
• This reply was modified 3 years, 11 months ago by stefaniescheidgen.

Hi Stefanie,

>>> yes, I did that but it looks like that it only works when the primary key is present in the query.

To view, edit or delete a record from a table, you must add the primary key to your query. You cannot access an individual column without the primary key. This is to ensure you are not accessing or deleting multiple records at ones.

Does this help?

Best regards,
Peter

Yes, thank you very much.

To create a view, do I have to create it with SQL scripts?

Is there the possibility to have one column return a count of something?
Let′s say I want to know the number of graves for one cemetery, and want the number to be up to date, could I then have a select count return value in a column?

I hope I don′t ask too much.

Have a nice day,
Stefanie

Hi Stefanie,

Yes, you can write your own SQL script and execute it from the Data Explorer – button Import data/Execute script(s). Make sure your create view statement ends with a semi colon and a line feed directly after the semi colon. The plugin needs these characters to identify the end of a SQL statement.

>>> I hope I don′t ask too much.

Perfectly okay! Don’t worry about it! ??

Good luck,
Peter

Hello Peter,
happy new year.

I have come further now with my project, but I still have some questions. On my wordpress page I use shortcode to point to my data project. ([wpdadiehard project_id=”1″ page_id=”1″])

That displays but the paging is missing and I only see the paging when I use the project within the data access plugin (build in probably).

Where do I configure the paging for it outside of the plugin? In the css? And is there somewhere an overview what properties are available?
I refer to something like you sent me for hiding the footer of a table:
.wpda-datatable tfoot {
display: none;
}

Kind regards,
Stefanie