8 years ago
1
Topic
SEBLOD 3.6.0 (2015-05-08) brought
Ability to append "Group By" clauses and "User-defined Variables" to Search system.
As of today, no example and no documentation exists, here it is:
"User-defined Variables" refers to MySQL "User-defined Variables" (another interesting example)
Use:
- In the User-defined Variables box, write something like
SET @VARA='OK', @VARB='OK';
Don't put more than one SET or you'll get an error.
- In the SQL Query box, put something like
SELECT * FROM #__users WHERE @VARA = @VARB
