Query filters

H @measy,

Are you perhaps referring to the WHERE clause in an SQL query?

Could you give us more details about your case?

Currently, in a Data Project, there are three ways to add filters:

1. Default where clause
2. Shortcode parameters
3. URL parameters

Please check this page for more information: Adding Filters

Let us know if this helps!

Hi Kim,

thanks for your reply.

I’m aware of “Adding filters”, but I couldn’t find out the solution to the following:

BUSINESS CASE:

assume you’re a training institute (similar to your demo), and you record indos about your contracted Teachers, like: experience (yrs), preferred working locations, and other specific “CV content”.

Assuming you need to fill a gap for a new Class to start, you want to check in your Teachers database (table), to find out the best match (ie, 10 yrs exp, “only works in London municipality + others (stored in the table) AND ITERATE the process by changing these parameters value to produce different views of the underlying table

In my understanding, you need a form (list, tabular style) where the columns (headers) are filterable in AND to produce different partial views of your Teachers table.

In other words: WHERE condition with variable (form based) parameters.

Hope this help to better explain the business requirement.

Any Idea more than appreciated.

Regards,

M.

Hi Marco,

Isn’t the Search Builder the right tool for your use case? The Extension Manager allows you to define which columns are searchable and allow the user to dynamically built a where clause using AND and OR conditions.

Here is demo:
https://wpdataaccess.com/search-builder-demo/

The demo allows searching on first name and last name only, but this can be extended using the Extension Manager.

Does this help?
Peter

Hi Peter,

yes it does! I do apologize:

honestly, I still miss to check the WPDA Premium features… ??

Thanks again,

Marco