178 Posts
Jeka
9 years ago
3
Topic

HI Devs and Community!

For today i have the task to create list and search in which results will be grouped by specified field.

Thank for any suggestion!

Get a VIP membership
9 years ago
1
Level 1

Hi Jeka

We did it before, using a before render code field in the list or item view. This is however quite heavy from cpu point of view but it worked. You can make any SQL query in the code field.

Now we prefer create a new list template

cyril

178 Posts
Jeka
9 years ago
0
Level 2

Hi Cyril and thank for so fast answer. 

So, now you prefer custom list template with some if / else statements?

I not so good to build complex sql queries, but i hearв that LEFT or RIGHT joins can help with achievement of needed result.

9 years ago
0
Level 1

It really depends on the result you want to get. You have to think over wether the result may be reusable in another project.

If you can have such a question in a few projects then you definitively need to create a new list template because it will run faster, be more packaged and you won't spend so much time next time.

if there is very few chances to face such a need, then you can use a code field in the seblod list you have. You use the seblod list (with any template you want) to perform the overall search and the code field is there to gather the results according to your criterial.

cyril

Get a VIP membership