6
votes
Accepted
Group entries by section
You can use the Twig group filter.
{% set entries = allowedSearchableEntries.search(query).order('score').limit(100) %}
{% set entriesBySection = entries|group('section') %}
{% for section, ...
- 3,819
5
votes
Accepted
Grouping entries by category - most efficient approach
One improvement I think could be made is to fetch only the ID's of your hotTubs entries at the start of your code. You're only using this to get the related categories and fetching ID's is faster than ...
- 1,456
3
votes
Accepted
How to group assets by category/sub-category
I’m assuming you want to do this in Twig rather than PHP, since you haven’t specified nor have you provided any code.
First, fetch all assets, eager-loading the categories.
{% set assets = entry....
- 7,796
3
votes
Accepted
Passing a variable to an include
You set the variable that your are passing in to your include to a string. And in your include you try to access it like an object.
The variable which you’re passing in to your include is set to a ...
- 36.3k
3
votes
Accepted
Sort entries in a category via entry field
You are getting this error because the "entries" fields are always considered to be a query (ElementCriteriaModel) that can return more than one element. Therefore, if you know for sure that you will ...
- 496
2
votes
Accepted
Better way to group by category and include full category entry
Your actual code is pretty effective – the problem is that it's potentially going to result in a lot of queries.
This is a good example of the so-called N+1 query problem, where each iteration over ...
2
votes
Group entries by section, then order and combine sections
You could do this in a few steps (warning: this is untested code):
1) Define an array of the sections you cited, in the correct order:
{# Define a list of the sections you want to display in the ...
- 496
2
votes
Accepted
Set OrderBy on Grouped Query Involving Smart Map Field
Okay, I've been able to solve this and figured I'd share what I discovered. The key for each group is the value of the state so really what I was after here was a key sort and just didn't realize it. ...
- 1,022
2
votes
Order grouped entries
Stumbled upon this looking to answer similar problem. You should be able to do this now without a plugin, using the multisort filter where you iterate through your profiles, e.g.:
{% for profile in ...
- 151
2
votes
Accepted
Archive Not Returning Correct Date Variable
Your postDate.day will output the number of the day in the month so if your entries postdate is 02.dd.yyyy your output is 2. Your array index will be something like [2, 3, 5, 12, 31] thus these values ...
- 19.8k
2
votes
Accepted
Grouping a large number of entries
First, based on your example code I don't think you actually need to loop on the entries – you could simply group them on the brand name, and then loop on the keys for the grouped array (the keys ...
2
votes
Accepted
Change order within grouped archive
Assuming the years are currently rendered in the correct (descending) order, an easy way to make sure the entries are rendered in ascending order would be to simply reverse the entriesInYear array, i....
2
votes
Grouping by Date (Day) Not Working Correctly
Figured it out. I actually asked for all entries for the group, rather than just the entries (events) that matched the date.
{% set passEvents = craft.entries.section("event").eventForwardPass("Yes")...
- 131
2
votes
Order entries by related "Year" category and paginate?
You could sort using the multisort filter (docs) then paginate using Yii's ArrayDataProvider - see this post for reference.
{# Fetch your entries and order by theYear descending #}
{% set ...
- 7,515
2
votes
Accepted
Stuck when grouping entries to get any other parameters like url, id etc
The group filter creates an associative array so the location Twig var in your loops is the array item key, which is a string.
I think you'll have to get the location object that's related to the ...
- 225
2
votes
Accepted
Grouping entries by a custom date conditional
You could fetch your entries then split them in three arrays which would give you the ability to then add headings manually and display as you need to.
{# Define today and three arrays to hold your ...
- 7,515
2
votes
Group by related entries field
A little late to the party here, but in case anyone else comes across this post.
The suggestion that August was making here was very close, but when I tried something similar, I was running into the ...
- 356
2
votes
Accepted
Group entries by custom fields
Assuming you can't change your data model easily to use relationships pointing to a 2-level Structure for State > Suburb (which would be a more robust approach), you can use the group filter to ...
- 5,689
1
vote
Group entries by custom fields
Wasn't that hard actually, just needed to stop and think about it for a bit.
{% set buildings = craft.entries.authorId(currentUser.id) %}
{% set states = [] %}
{% set suburbs = [] %}
{% for building ...
- 665
1
vote
Group/sort by multiple criteria
You can pass multiple columns to the orderBy parameter like so:
{% set people = craft.users().groupId(1).orderBy('isLeadership DESC, isActive DESC, lastname ASC').all() %}
{% for person in people %}
...
- 3,045
1
vote
Accepted
Group by related entries field
I think you're nearly there! Give this a shot:
{% set allEntriesByPrename = allEntries | group('{{ (object.composerName | first).lastName | upper | slice(0, 1) }}') %}
I believe the issue is that ...
- 3,620
1
vote
Order grouped results by dropdown order
You could wrap this in another for loop and put a condition on the inner fors,
something like
{% for option in myPositionDropdown %}
<h2>{{ option.value }}</h2>
{% for position, ...
- 624
1
vote
List elements grouped by multiple dates
You could loop through all your events, and create a date-keyed hash with the ids of the entries - assuming your (e.g
{% set saleDays = {} %}
{% for entry in events %}
{% for row in ...
- 146
1
vote
Accepted
Grouping by select - keep order of options
The group filter loops through the passed elements in the order that they are returned by your query and builds the groups array in the order that it encounters the values being grouped. So there’s no ...
- 3,443
1
vote
Select query question
Why don't you use the prepared ElementCriteriaModel in the category and change the query?
{% for category in craft.categories.group('whatever') %}
{% set articles = category....
- 19.8k
1
vote
Accepted
error when trying to loop through grouped entries according to dropdown field
You have to remove the entry from your entry.resourceType
{% set allEntriesByCat = allEntries|group('resourceType') %}
will work
- 19.8k
1
vote
Using the Group filter with Squarebit Charge plugin
I got this to work with the following:
{% set allCharges = craft.charge.charges.limit(5) %}
{% set charges = allCharges|group("dateCreated|date('F')") %}
{% for month, details in charges %}
<...
- 1,463
1
vote
Search entries ordered by sections
Something like this should get you started, q is the querystring in your results url:
{% set query = craft.request.getParam('q') %}
{% set entries = craft.entries.search(query).level(1).order('score')...
- 850
1
vote
Can I move existing tags, which are currently in a global tag group, to new the new tag groups I've set up?
There is no way to do this natively in Craft through the control panel.
You could either write quick plugin that programmatically moved the existing tags to new tag groups or write some custom SQL ...
- 67.6k
1
vote
Accepted
Get Section Handle From Group
In your example, you're attempting to use a SectionModel instance as the key for your grouped entries. This is not possible.
What actually happens behind the scenes is the group filter generates an ...
- 2,429
Only top scored, non community-wiki answers of a minimum length are eligible