Stuck Adding Parameter to Custom Query

Wappler General How To
#1

I followed the docs here …

But it doesn’t show how to add the parameter to the query?

23%20AM
Screen Shot 2019-11-28 at 9.58.23 AM.png1492×882 72.7 KB

#2

Hey Brad. Are you looking for something other than typing in the name (:P1 in this case)?

#3

No matter what I put in the WHERE statement I get an error.

27%20AM
Screen Shot 2019-11-28 at 10.23.27 AM.png1152×778 89.2 KB

#4

The where clause comes before the group by.

#5

Perfect! Knew it had to be something simple. Works like a charm. Thanks @mebeingken!

1 Like
#6

I have a similar setup… my question is to find out how to use a custom query and add SUM to some of the fields. The other method of query we can use the Aggregate and Alias and create another ‘field’ name with SUM. Is something like this available to custom queries?

#7

Yes, you can use SUM in your custom query. In my case I used COUNT but the syntax to use SUM is the same.

1 Like
#8

Awesome!