How to use query editor in custom module?

Wappler General How To
#1

I’m trying to extend paged query to allow user to filter on multiple columns in table.

I extended paged query and I’m looking for the hjson of the Wappler paged query to stick as much as possible as the original, but I can’t find if it’s possible to have the query editor as the original database query modules.

EDIT: For the dropdown of database connections I don’t know if we can have that too in custom modules?

#2

From what we know, query editor is not available for use in the Custom Module capabilities.

1 Like
#3

I’ve seen Paged custom query this post and maybe @JonL have something to share? Or I go along with just a text field, I don’t know

#4

So what’s the issue to filter a paged query by multiple columns right now, using the query builder?

#5

Maybe I’ve missed some option but I don’t currently see how I can in a paged query filter from dynamic column with dynamic “search value”.

Example for url would be:

/api/request?sort=a&dir=asc&filter=b|testORa|3

And my request would generate a where clause like:

SELECT ... WHERE b ~'test' OR a > 3

Something like that (don’t have the final design if you have suggestion :slight_smile: The idea is to allow user to click on a column and filter by dropdown when column type is an enum, if the type is date allow them to select a range of months or year, etc)

#6

So is this now what you want?

Screenshot_4
Screenshot_41064×669 110 KB

#7

Well yes but I want the name of the column and the number of filter be dynamic, coming from the request and then I do something like that (from last example):

$_GET
  .filter
  .split('OR')
  .forEach(or => addWhereOrInRequest(or.split('|')))
#8

No, that is not supported.
You can just define the columns and their filters and toggle the filters conditionally.

#9

Yeah I’d figured that out and move to custom modules

#10

You can just add all columns you want to filter and add a conditional per column when to activate the filter. So you will have multiple conditional activated filters like this.

1 Like
#11

Thank you so much it also “fix” another issue I had: duplicating queries to conditional where, never noticed this option, Awesome! :smiley:

1 Like
#12

The conditional option in Query Builder is a great feature; QB would far less powerful/useful without it. Eg you can create pages with mulltiple search options with it.

As far as I know, the only way to create a completely dynamic query it to use a custom query to execute a stored procedure - eg you could store any query in a variable and run that.

1 Like
#13

If you need full control over the query I don’t see another way but to use a custom module. My use case was very specific though as I wanted to pass the name of the table dynamically which is currently not possible with Wappler. Knex does a good job at making sure there is no SQL injection so I used knex for this.

1 Like
#14

Do wappler use knex? I mean I’ve never wondered but now you say that I’m wondering if Wappler handle for me sql injection when I’m using Wappler modules?

#15

For nodejs it does(in some components). Don’t know if they use it 100% throughout the app.

1 Like