Query Builder – Queries like pages or with shortcode

Hi Roger,

If you want to execute queries via shortcodes, take a look at the Code Manager:
https://www.ads-software.com/plugins/code-manager/

You can use your WP Data Access connections (like remote databases) directly from the Code Manager.

>>> permits to put more than one instruction in a saved query

I’ll what I can do! ??

Best regards,
Peter

Hi Roger,

I just released an update. You can now enter multiple SQL commands in a query! ??

Thanks for your contribution,
Peter

Hi Peter,
Great ! Thanks a lot !
I would like to provide logged users with a set of forms, table views and for some of them, procedures processing to validate set of updates.
This on the backend using the wpda menu.
So, having the possibility to execute queries via the wpda menu would be … my final request!
??
Kind regards
Roger

Hi Roger,

You can do that! Please have a look at this page:
https://wpdataaccess.com/code/

There are a number of hooks and filter you can use. The wpda_before_list_table and wpda_after_list_table can be used to add code before or after a table list is displayed. The same can be done for data entry forms with wpda_before_simple_form and wpda_after_simple_form.

There is also a validation method. One on forms level and one on each item. They all have protected access modifiers, but I can add a hook or filter if you tell me what you need.

Let me know,
Peter

Hi Peter,
I am not a programmer but just a manager of software engineers. However, I have a university degree in computer science specializing in databases.
Even if I can dig into the solutions you offer me, the context in which I want to use WP Data Access is the implementation of a data management application for an international association (fistf.com) which does not have any resources. competent in programming.
My goal is therefore to set up a “no code” solution, in other words entirely based on the configuration of a WP plugin with simple SQL requests or mass updates.
A typical example is the filling of a form by the national associations each year (insertion of an article in a table) followed by the execution by the secretary of a mass validation process of the forms that he will have checked as valid, which processing consists of copying the articles from one table to another.
For this I only need WP Data Access pages for forms and Queries for mass processing.
So the only lack today is the possibility of creating WP Data Access pages associated not with templates but with Queries.
Like this, I am able to offer a WP Data Access menu on the backend offering the viewing or updating of tables and the execution of SQL query packets.

Concerning the before_form and after_form, why not offer the “HTML / Javascript code before” and “HTML / Javascript code after” fields in the page definition form? Ideally fields that can be edited with the WYSIWYG plugin from the WP backend …

Regarding the backend menus, would it be possible to have several levels of submenus? For example using the “\” or “/” character to signify a sublevel in the “Menu Name” field
For example: “Inscriptions\Validation” would give a “Inscriptions” menu and a “Validation” sub-menu`

… A letter to Santa Claus!

Let me know.
Roger

If I can add one essential element: my goal is that the entire application is stored in the WPDA tables of the database and that no PHP code is added (eg in function.php). So the compatibility of the application with version upgrades is ensured by WP and each plugin without my having to do non-regression tests and modify the code (especially when I will no longer be there to do it …).

Of course I know that features must be adaptated to WPDA capabilities.

• This reply was modified 3 years, 10 months ago by sturmy31.

Hi Roger,

Regarding your posts, I thought you were a programmer! ??

I think (hope) I understand your needs. It is possible to add pages to a Data Project. You just need to select static page instead of table or parent/child. This is not used a lot and I have been thinking about remove it from Data Projects. Maybe I need to reconsider…

If you add a static page you can add links to run queries on that page. The page is yours and can be designed outside of the plugin. But you’ll need to have some control to execute those queries. I don’t have a generic solution for that right away. Let me think about this…

The before_form and after_form events are conform the WordPress standards. I want to keep it that way as it makes it accessible to WordPress developers in general. Sorry!

About the WYSIWYG concept, this might sound silly but WP Data Access is not even half way where I want to go. There are still a million ideas to be implemented. This will come, but it takes time. Step by step… ??

Thanks,
Peter