Ok, hello. I’m having some trouble with a query to a database. Basically the problem is with the data I require. The databse query is something like this: [image] I need to “concatenate” (I don’t think that’s the specific word for it) the apartment column be one and sum the balance column, so I …

Hi. This is more of SQL question than Wappler question. You should find learning material on building queries to help you in such scenarios. Stack overflow almost always has something… just need to search with right keywords. For this case, I am presuming the data is all coming from a single tabl…

With wappler’s query manager I can’t do this kind of queries, right?

Right. Not yet. You have to use Custom Query server action step. Or, if you can create a view, then you can just use that in the regular DB Query server action step.

[image] sid: Or, if you can create a view , then you can just use that in the regular DB Query server action step. What do you mean with "view"? And where do I create it?

[image] sid: This is more of SQL question than Wappler question. You should find learning material on building queries to help you in such scenarios :point_up:

[image] Query the database with merging records How To Hello In the database the data is stored as a table: [2] How to create a query in Wappler, so that the output is formed according to the condition - if the records have the same names field 1 and field 2, the record…

The group_concat is something specific for mysql and is not possible with the query builder, so you will need to use the custom query for that. The group by and sum are supported by the query builder.

Query problem

Wappler General Need Help

Mr.Rubi December 1, 2019, 5:22pm 7

Look at this topic. I needed to something like that. I just implemented the recommendations and the solution worked perfectly. Perhaps will helpful and than the will help you.