Hi All, Having trouble today with getting an array passed into a custom query action IN clause. For testing I have tried hard-coding the numbers, which yields the correct results: [43%20AM] If I then switch out the values (88,90,123,98,91,92) and replace with parameter :P4, the result in testin…

@George and @patrick , Thanks, this was very helpful. For anybody needing to do this in the future, here is what will work inside a wappler custom query: [01%20PM] I found you can use the mysql find_in_set function in lieu of the IN clause. It should be noted that this shouldn’t be used on larg…

Hi Ken, Please check the following topic: [image] Working with the database query IN filter How To This is one of the peculiarities of the Query Builder. You would expect to be able to add the criteria as you would in a normal SQL query, but you need to turn the list into…

Thanks @Teodor , That is the first thing I was trying, but as I said, I keep getting an array to string conversion error. I assume because I need numbers, not string. So I have tried: {{$_GET.filter_tags.split(",").toNumber()}} {{$_GET.filter_tags.toNumber().split(",")}} {{$_GET.filter_tags.spl…

How are the GET parameter values generated, i.e. what kind of value is passed there and what generates the value?

It is an array variable on the front end: <dmx-array id="filter_tags"></dmx-array> I add to that array like this: [30%20PM] [30%20PM]

In the query builder, this should be working perfectly fine, with a value coming from the array component: {{$_GET.parameter.split(",")}} No need of tonumber formatter.

I just tested this and it seems to work perfectly fine. Are you sure you added this in the Filters section of the query builder?

Sorry, I missed the part you were referring to a custom query. I am testing this with a normal query, built with Wappler query builder. @patrick can advise here.

Ya, I’ve done this in a regular query plenty of times…always works. In the custom query though, I can’t even get the proper results when using the Execute Query button within the action, but assumed that is because I didn’t format properly as an array.???

GET array for use with IN clause of custom query action

Wappler General Need Help

Teodor August 3, 2019, 6:57pm 2

Hi Ken,
Please check the following topic: