How to add sortBy (use sort order of field in other blueprint) to groupBy?

[Roman]

I am showing registrations to tennis tournaments and want to group them by players Groups.

Tried this example https://getkirby.com/docs/reference/objects/pages/group-by#example and it’s working fine. Only there are two things, that I can’t figure out:

1. groups are printed in lowercase, although they are stored normally in blueprints.

2. How can I sort by Groups, where group order should be the same, as it is in “Event” page, from which Group name goes to registration:

[texnixe]

@Roman

groups are printed in lowercase,

If they are stored in lowercase then they will be printed in lowercase.

@Roman

How can I sort by Groups , where group order should be the same, as it is in “Event” page, from which Group name goes to registration:

If your groups are sorted alphabetically, you can just add a sortBy(), if it is some custom order, you will have to map a value to each group to sort by.

[Roman]

In blueprint values are with capital letter, for example: Group: Pirma grupė, but still group value is printed in all lowercase.

To sort alphabetically with sortBy() - that’s working well, but the question is how to have the same order, as this field option values have in blueprint (there is not certain sort, like alphabetical).

[texnixe]

@Roman

In blueprint values are with capital letter, for example: Group: Pirma grupė,

I was asking what is stored in your content file, not in the blueprint.

[texnixe]

@Roman

To sort alphabetically with sortBy() - that’s working well, but the question is how to have the same order, as this field option values have in blueprint (there is not certain sort, like alphabetical).

Well, then you have to eitherread that order from the blueprint or create an array of values in the same order and assign a sort number to them, then sort by that array.

Basically, you would first use map() to assign a sorting order to the grouped collection, then use this assigned sort value to sort by.

Or you sort your registrations first by that grouping value, then group, like here:

Custom Grouping Order

Ok, I see, seems to depend on the order. Other idea (condition1etc. is just a placeholder for your conditions: We map an order number to each item depending on condition and then sort by this order number. $groups = $site->find('events','exhibitions')->children()->visible()->map(function($article) { if(condition1) $article->order = 1; else if(condition2)) $article->order = 2; else if(condition3)) $article->order = 3; else $article->order = 4; return $article; })->sortBy('order'); $groups = …

[Roman]

Sorry, I meant to say, that it’s stored in content file (registration.txt), so yes, it’s with capital letters there: Group: Pirma grupė

Thank you for information about ordering, will check it out.

[texnixe]

@Roman

Sorry, I meant to say, that it’s stored in content file (registration.txt), so yes, it’s with capital letters there: Group: Pirma grupė

Hm, in any case you can use ucfirst() to make the first letter an uppercase letter again.