Articles
- Getting started
- Creating publications
- Responsive publications
- Custom queries
- Custom Post Types
- Styling publications
- Code Manager
- Manual styling
- Premium styling
- Global styling
- Styling issues
- Premium extensions
- Static filters
- Interactive filters
- URL parameters
- Search form
- Search Builder
- Search Panes
- Advanced search
- Geolocation search
- Advanced settings
- Row grouping
- Adding hyperlinks
- Master detail publication
- Large tables and performance
- Change publication language
- Non admin user access
The data publisher’s pub id is allways unabled thurs one can not add a table…..
Please just leave that field blank. The plugin will generate an ID when you save your publication the first time. Hope this helps…
Hi,
I created a Publication and Published it in a page. The type of one of the columns that is shown is “Attachment”. When I am logged as Administrator is show the icon of the file attached, that’s ok. The problem is, when I am logged as Subscriber nothing is shown in this column. You could tell me if this is a bug or if I have to make some configuration?
Thanks a lot.
Hi Ávila,
Sorry for my late reply! I’m on holiday… 🙂
Did you add the attachment to your publication? It is not added automatically:
– Go to the Data Publisher
– Edit your publication
– Click the select button (after column “Column Names (* = all)”)
– Add the attachment and save
Does this help?
Best regards,
Peter
Peter
I would like to be able to select the records (for printing, clipboard, csv, or excel) from multiples pages
at the moment I can only select from one page all other selections are forgotten
Simon
Dear Peter,
I have created a database with a product catalogue incl. product images and prices. I have also published the catalogue and it works well.
Now, what I would need is a form, where user can entry e.g. a number of products and based on this, products should be shown and incl. the total caculated price should per product (numer of items coming from the form x single price coming out the database)
Is that possible within the plugin or what else would be needed?
Many thanks for your help and best regards
Bojan
Hi Bojan,
You can create a Data Project to manage your table data. A video tutorial can be found here:
https://wpdataaccess.com/docs/documentation/data-projects/overview/
At this time the plugin does not support computed fields. Sorry! But your can add a calculation to a view and use that view in a publication.
Hope this helps,
Peter
Dear Peter,
many thanks for your quick reply – really helpful!
Best regards
Bojan
Dear Peter,
sorry for bothering you again. Everything re the table works perfect now. In order to avoid computed fields i´m calculating different prices within the table (for number of 1 – 100 products, that´s fine )
E.g. if user enters 50 in a form field, the respective line incl. calculated field should be shown.
So, where I´m really struggling right now is to setup the form field.
1. Do I understand it right, that i cannot include the form and the table shortcode on the same page as the page needs to reload after submitting the form field? If yes, i will setup the form on one page, opening the other incl. the table – no problem
2. could you please help me with the form field, lets´s take the entered 50, search in the table for respective line with 50 (on specific row) and show certain rows out of the same line
Many thanks again
Bojan
Hi Bojan,
This page might be helpful to create a search form:
https://wpdataaccess.com/docs/documentation/data-publisher/adding-filters/
See section: URL Parameters.
You can create a search form that redirects the user to your publication using URL parameters in the specified format. Here is a real live example:
https://www.rutherfordglobal.com/pars-search/
Select #CCN = 3959752984492 and click SEARCH
If you are looking for a more generic search solution this page might interest you as well:
https://wpdataaccess.com/search-builder-demo/
Good luck,
Peter
Many Thanks, Peter.
I´m having a table with a column name gesamtkosten. One of the entries is 15325.
I have included a form with WPForms Builder and entered in the confirmation mail the following url:
https://myurl.de/ ?wpda_search_column_gesamtkosten=%%
And it always shows all values after submission, instead of showing entered value in the form.
If I Put: https://myurl.de/ ?wpda_search_column_gesamtkosten=15325. It shows only 15325.
Do you have an idea what is missing?
Many thanks
Bojan
Hi Peter,
column name is logo
it works if i put a concrete value in the form notification (WPForms Builder) url: https://url.de/?wpda_search_column_logo=2
But if i want to use a value from the form, writing https://url.de/?wpda_search_column_logo=%% , it doesn not work.
What am I missing?
Many thanks
Bojan
Hi Bojan,
It looks like you want to use wildcards, is that correct? Wildcards only work with text columns. If I understand your situation correctly, your columns gesamtkosten and logo are numeric? You can try to create a view and convert your numeric values to text, but your query results will be unpredictable. Can you share a public url? You can use the contactform if you prefer to send it in private.
Thanks,
Peter
Hi Peter,
many thanks. I sorted it out by doing my homework by reading a lots of documentation 😉
So, what I need is a form with 2 custom fields (numeric).
It works (when using form with one field and entering e.g. 12):
wpda_search_column_einzelpreis=12
This also works (when using form with 2 fields and entering 12 and 2), showing one line where both column values are matched:
wpda_search_column_einzelpreis=12&wpda_search_column_anzahl=2
But what I would like is to show both lines i.e. I would like to show a value from one column in one line AND an another value from another column in the second line.
Is that possible using url?
Many thanks
Bojan
Hi Bojan,
Good you got it working! 🙂 If I understand your question correctly you need to add an or condition? Or conditions with url parameters is currently only supported within one column using arrays. You cannot add an or condition for two different columns. Sorry! It is on my to do list…
Best regards,
Peter
Thanks Peter ;-),
exactly, in order to show 2 values/lines from 2 form fields, i would need an OR condition.
Is there any other best practise to read information from database based on form and list them on a page?
Many thanks again
Bojan
Hi Bojan,
Your question got me thinking… I added a new URL parameter ‘wpda_search_column_operator’ to support the OR condition. It will be available with the next update which I hope to release this week.
Thanks for the discussion! 🙂
Best regards,
Peter
Hi Peter,
I managed to create a table, a form and even a view with calculated fields – and it works fine.
The Problem i´m having is, that I´m trying to show at the bottom of the table a total sum of a column. I can put it in the view but it shows naturally the total amout of all rows.
Due to the fact, that I´m working with a form which is fitering the table, I would like to show only sum of filtered columns, any idea how to sort this out?
Many thanks
Bojan
Hi Bojan,
The premium version of the plugin supports row grouping. Here are two demos:
https://wpdataaccess.com/row-grouping-demo/
https://wpdataaccess.com/row-grouping-client-side/
The first link provides a server side demo, the second a client side demo. The client side solutions offers more flexibility but works for smaller datasets only as it needs to load the whole dataset on page load.
Hope this helps,
Peter
Excellent, many thanks Peter, great support!
Hi,
Firstly this is a really excellent plug in. I only spent about one hour playing with the free version before deciding to upgrade, so great job!!
Question 1 : Is it possible to set the default pagnation value for a publication (wpdataaccess shortcode) on the front end like it can be set for the wpdadiehard shortcode ?
Question 2 : Is there any possible way to automatically add row numbers when displaying a publication grid on the font end ?
Many thanks
Mark
Hi Mark,
Glad you like the plugin! 🙂
Answer 1: You can use the advanced settings to change default pagination. The following page contains an example:
https://wpdataaccess.com/docs/documentation/data-publisher/advanced-settings/
See section: Change the list of shown entries (lengthMenu = items shown in list, pageLength = default);
Answer 2: There are two ways to do this:
(1) Create a view based on your query and add a row number to your view. Then use the view for your publication instead of the table.
(2) Add a custom renderer. There are multiple ways to do this. Within WP Data Access I would advice to use the built-in function fnRowCallback. There is a fnRowCallback example on the page I previously mentioned. Here is direct link to that section:
https://wpdataaccess.com/docs/documentation/data-publisher/advanced-settings/#javascript-functions-more-complex
Hope this helps,
Peter
Thank you Peter for your response. I will check out both links and report back if I have any issues.
Regards
Mark
Hi, I am creating a publication with data publishers, but when it comes to showing the data to the front-end, it always shows all the table data at once. Thus, the pagination and the entries sorting number did not work.
Am I missing something so that the data publishers did not work properly?
Thank you.
Hi Tama,
Please open your publication in the Data Publisher, open the Advanced Settings section and enable these checkboxes:
> Allow Searching?
> Allow Ordering?
> Allow Paging?
> Server Side Processing?
Hope this helps,
Peter