Where function in page design

Questions
1

is it possible to add “GROUP BY” in the where of page design ?

errore_1.112
errore_1.112991×371 92 KB

2

@Maxr167 what project type is this? Either create the question to the specific category for the project type on the forum or add the project type details to your question, thanks.

3

PHPRad Vue project … in the where of the page design-> Default query configuration I would like to add the “GROUP BY” function; in the web page it gives me syntax error, unexpected ‘GROUP’ (T_STRING)

errore_1.113
errore_1.1131114×442 145 KB

errore_1.114
errore_1.1141132×207 35.2 KB

4

@Maxr167 according to the fields i saw in the image, the query should look like any of the below.

$query->where("sospensione", "=", "Nassuna")->where("fatturato", "=", "No")->groupBy("palestra");

OR

$query->where("sospensione", "Nassuna")->where("fatturato", "No")->groupBy("palestra");

OR

$query->where("sospensione", "=", "Nassuna");
$query->where("fatturato", "=", "No");
$query->groupBy("palestra");

OR

$query->where("sospensione", "Nassuna");
$query->where("fatturato", "No");
$query->groupBy("palestra");

They are all the same.
Visit here Database: Query Builder - Laravel - The PHP Framework For Web Artisans to learn more.