Sort two parameters inside data

[Ikedia]

Hello, everyone! I have a problem, hope someone can help me with solution, I can’t find for hours. What I need is sort range of data files by variable, and after that do another sort by another variable. I will show, what I am trying to do.

{{ range sort (sort .Site.Data.portfolio_residential “project_name”) “favorite”}}
{{ end }}

favorite: “2”
project_name: Betesh
picture: /assets/images/public/BET_200220_07.jpg
address: Brooklyn, NY

So I want to get list of favorites. Favorites could be from 1 to 7. It looks like: if from 1 to 6, they are on the top by numerous order. If “favorite” is 7, use alphabet order. Now it looks strangely. Favorites are on the top, but alphabet looks a bit wrong, also if I add one more item f.e. with favorite - “1” (so they are two with same number) on the top appears not alphabetically first…

A bit complicated description, sorry. Would be glad for any help! Thanks for your time!

[Ikedia]

To be more clear:
This sorting works. F.e. if I remove parameter “project_name”, and leave only “favorite”, the items with parameter = 7 are created randomly each time.
With both parameters, it stops creating randomly, but order is strange, mostly alphabetical, but some items are not in their places. I wondering what I am doing wrong, the second parameter is correct and checked, there are no mistakes… Still need some help, guys!

[damien1]

@Ikedia

parameter

I think you are talking about a custom taxononmy for your parameter - when enabled, then you can do sorting on it

Taxonomies

and maybe also this post

List custom taxonomy terms in a specific order (not alphabetical)

I didn’t understand how you finally solved your issue. Did it hurt to post a brief summary on where an how you assigned your weights and what code did you put into the partial?

[jmooring]

The SQL equivalent of what the OP wants to achieve is:

SELECT * FROM .Site.Data.portfolio_residential ORDER BY favorite ASC, project_name ASC;

As far as I know this is not easily achievable. When sorting pages you can use nested .ByParam calls, but not when working with data files.

You may be able adapt this to your use case, but it’s complicated:

Order data files by secondary parameter

Sorry, I probably just missed something: How is it possible to sort data file output by a “secondary” parameter? This is what I need for a huge bibliography: {{ range .Site.Data.bibliography }} {{ range sort . "author.family" }} {{ .title }} … {{ end }} {{ end }} Thank you very much in advance!

[jmooring]

This post from @FelicianoTech was really helpful:

GroupBy For Data Files in Hugo

Cross-posted from my blog I recently had the need to list out a bunch of locations on a page with Hugo. With over 100 locations to display, I wanted to group them by state on the page creating a kind of directory. The first thing that came to mind was Hugo’s GroupBy function. Unfortunately I’ve learned that the GroupBy function only works on Hugo Pages while I’m storing all of these locations in a Hugo Data File. Here’s how I solved this problem. Now, my solution is no where near as neat…

data/portfolio_residential.json:

[
  {
    "favorite": "3",
    "project_name": "D"
  },
  {
    "favorite": "3",
    "project_name": "C"
  },
  {
    "favorite": "1",
    "project_name": "B"
  },
  {
    "favorite": "1",
    "project_name": "A"
  },

  {
    "favorite": "2",
    "project_name": "E"
  },
  {
    "favorite": "6",
    "project_name": "F"
  },
  {
    "favorite": "5",
    "project_name": "G"
  },
  {
    "favorite": "4",
    "project_name": "I"
  },
  {
    "favorite": "4",
    "project_name": "H"
  }
]

Template:

{{/* Build slice of unique, sorted favorites. */}}
{{- $favorites := slice -}}
{{- range .Site.Data.portfolio_residential -}}
  {{- $favorites = $favorites | append .favorite -}}
{{- end -}}
{{- $favorites = $favorites | uniq | sort -}}

{{/* Range over the sorted favorites, then range over a sorted subset of the data file. */}}
{{- range $favorites -}}
  {{- range where (sort $.Site.Data.portfolio_residential "project_name" "asc") "favorite" . -}}
    favorite = {{ .favorite }}<br>
    project_name = {{ .project_name }}<br><br>
  {{- end -}}
{{- end -}}

[Ikedia]

WOW! Great decision! Thanks for the time you spent! This really works even with separate data files

[jmooring]

Credit to @FelicianoTech.