The Data Publisher allows plugin users to create responsive tables from local and remote databases. Publications can be created with just a few mouse clicks. Customizable styles are available for download for free. Demos and videos are available to help new and experienced users getting their publications up and running. The Data Publisher supports client side processing for small tables and server side processing for large tables (several use cases with over two million rows). Advanced options and javscript support is available for more experienced developers.
Show all features
Demos
- Interactive filtering with the Search Builder and export buttons
- Interactive filtering with Search Panes and export buttons
- Customizable search form
- Responsive table with advanced interactive filtering and export buttons
- Progressive loading using the SHOW MORE button
- Free styling with the Code Manager and export buttons
- Geolocation integration
- Publication with media library integration
- Publication with static hyperlinks
- Publication with dynamic hyperlinks
- Row grouping using server-side processing (no interactive reordering)
- Row grouping using client-side processing (allows interactive reordering within the group)
- Master detail publication
Hi there,
I’m new to WP and WP Data Access. For project management I created several related tables and now it’s time for a nice frontend. Amongst other tables I have: 1. Project table, 2. Booked Hours, 3. Performed Work
I’d like to have the open projects on top of the page (this is done)
When I select a project, I’d like to filter the list below (Booked Hours) with the selected idProject.
One or many items are be listed.
Then again, if I pick one of the booked hours items, the 3rd list should be filtered by this idBookedHours.
Is there any video or instruction how to pass a parameter (idProject) to another list on the same page?
Thanks for any input on this!
Hi Peter,
You can create master detail pages using Data Projects to manage your relationships. This is documented here:
https://wpdataaccess.com/docs/documentation/data-projects/one-to-many-relationships/
The tutorial is a bit outdated, but the it still works the same way.
Data Projects makes your implementation easier, but it does not give you the freedom you have with a programming language. Pages are constructed in a standard format. You’ll need to check if this fulfill your needs.
If necessary, you can add your own links to other pages with dynamic hyperlinks. This is documented here:
https://wpdataaccess.com/docs/documentation/data-explorer/dynamic-hyperlinks/
Dynamic hyperlinks allow you to create your own page flow, but each link requires a new page request, which is not needed with Data Forms (premium Data Projects solution). An example of a Data Forms application can be found here:
https://wpdataaccess.com/docs/documentation/data-forms/project-demo/
Hope this helps,
Peter
Thanks Peter, I will check this out.
Yesss, the Data Forms (3rd link) did the trick 🙂
I set up already all 1:n relations (1st link)
One more thing: How, or better, where to change the layout of the tables?
It seems to be limited to 50% of the browser window.
Also the font size is way too large.
My neighbour across the street is commenting on my projects 😉
Cheers
//Peter
Hi Peter,
For you popups you can overwrite class wpdadataforms_modal. A menu is shown in a div containing class wpdadataproject_menu, pages are bundled in a div containing class wpdadataproject_menu_pages and each single page contains class wpdadataproject_menu_page. With these classes you should be able to style your Data Forms.
Some individual elements might need individual styling. That often depends on your theme. You can use your inspector for fine tuning. Let me know if you have good ideas for improvements…
Good luck,
Peter
Thanks, Peter.
Where would I find the class wpdadataforms_modal and the other class’ you mentioned.
So far, I created a Project with several Pages, one for each table and also added the relations between the tables. Each Page has a ‘Template Set Name’ with ‘default’ setting.
Thank you!
//Peter
Hi Peter,
I believe I did not explain myself very well… This is not a code class. It is a CSS class, which you can easily overwrite.
Hope this helps,
Peter