Group By does not work with Query which is filtered by a $_SESSION

Wappler General Need Help
1

Wappler Version : 1.9.2
Operating System : MacOS 10.14.3

Expected behavior

What do you think should happen?

Group a query

Actual behavior

What actually happens?

It groups the query but doesn't show any text.

How to reproduce

  • Detail a step by step guide to reproduce the issue
  • A screenshot or short video indicating the problem
  • A copy of your code would help. Include: JS, HTML.
  • Test your steps on a clean page to see if you still have an issue

  1. I have a query which is filtered from a $_SESSION

  2. I insert the Server Connect query in App Connect

  3. I create a Bootstrap 4 Table with the Generator

  4. Table without Group

image
image1884×906 92.5 KB

  1. In the Repeat Properties I click on the Data Binding symbol

image

  1. I select Group By in the Data Formats

image
image866×918 68.6 KB

  1. Codeview after Group

image
image2542×936 224 KB

  1. Table with Group

image
image1880×370 6.92 KB

EDIT:

I also discovered a strange behavior in the Data Bindings Panel.

image

2

any news on this topic?

3

Hello,
that’s now how you use the Group By in App connect. You cannot just apply it to the table like that. After you create a repeat grouped by a property, you need to bind a value inside it using data from what is returned under $value:

Screenshot_23
Screenshot_23.jpg1139×745 158 KB

What exactly are you trying to achieve there?

4

Hello @Teodor,

thanks for your help. I didn’t know that I have to bind to another value. It is a little bit irritating that you get 2 $value options under Data Bindings and the mouse is always jumping to the first one…

image

Is there an other option to use group by for a query in Server Connect as I can’t group in Query Builder?

5

We will check the issue with the two $value groups.

Can you explain a little more detailed what the desired result on your page is?

6

Following your tip I got the results I wanted.

I just need to group by a certain column (Mkohtgeraet see Screenshot above). I just thought it would be easier to do this in Query Builder on server side.