Sort by count

Users Dgraph
1 
{
    "set": [
        {
            "uid": "_:org1",
            "name@en": "organization_a",
            "social_networks": [
                {
                    "name@en": "twitter"
                },
                {
                    "name@en": "telegram"
                },
                {
                    "name@en": "facebook"
                }
            ]
        },
        {
            "uid": "_:org2",
            "name@en": "organization_b",
            "social_networks": [
                {
                    "name@en": "twitter"
                },
                {
                    "name@en": "telegram"
                }
            ]
        },
        {
            "uid": "_:org3",
            "name@en": "organization_c",
            "social_networks": [
                {
                    "name@en": "twitter"
                },
                {
                    "name@en": "telegram"
                }
            ]
        }
    ]
}
  1. How to sort by count of social_networks? count(social_networks)?
    “count(social_networks)”: 3
    “count(social_networks)”: 2
    “count(social_networks)”: 2
  2. How to group by values of count(social_networks) and get counts of organizations
    “count(social_networks)”: 3 - 1 organization
    “count(social_networks)”: 2 - 2 organizations
2 
{
      socialmedia(func: uid(0x18b3879,0x18b387a,0x18b387b)) {
        uid
        name@en
      }
}

## DATA

{
  "data": {
    "socialmedia": [
      {
        "uid": "0x18b3879",
        "name@en": "twitter"
      },
      {
        "uid": "0x18b387a",
        "name@en": "telegram"
      },
      {
        "uid": "0x18b387b",
        "name@en": "facebook"
      }
    ]
  }
}

dataset

{
    "set": [
        {
            "uid": "_:org1",
            "name@en": "organization_a",
            "social_networks": [
                {
                    "uid": "0x18b3879"
                },
                {
                    "uid": "0x18b387a"
                },
                {
                    "uid": "0x18b387b"
                }
            ]
        },
        {
            "uid": "_:org2",
            "name@en": "organization_b",
            "social_networks": [
                {
                    "uid": "0x18b3879"
                },
                {
                    "uid": "0x18b387a"
                }
            ]
        },
        {
            "uid": "_:org3",
            "name@en": "organization_c",
            "social_networks": [
                {
                    "uid": "0x18b3879"
                },
                {
                    "uid": "0x18b387a"
                }
            ]
        }
    ]
}

{
      socialmedia(func: has(social_networks)) {
        uid
        name@en
        count(social_networks)
      }
}


{
  "data": {
    "socialmedia": [
      {
        "uid": "0x18b387c",
        "name@en": "organization_c",
        "count(social_networks)": 2
      },
      {
        "uid": "0x18b387d",
        "name@en": "organization_a",
        "count(social_networks)": 3
      },
      {
        "uid": "0x18b387e",
        "name@en": "organization_b",
        "count(social_networks)": 2
      }
    ]
  }
}

Not possible like this.

{
  var(func: has(<~social_networks>)) @groupby(<~social_networks>) {
      a as count(uid)
  }

  byGenre(func: uid(a), orderdesc: val(a)) {
    name@en
    social_networks : val(a)
  }
}

Response

{
  "data": {
    "byGenre": [
      {
        "name@en": "organization_a",
        "social_networks": 3
      },
      {
        "name@en": "organization_c",
        "social_networks": 2
      },
      {
        "name@en": "organization_b",
        "social_networks": 2
      }
    ]
  }
}
1 Like
3

use a block defining a var and then order using the value of the var.
Example with donor dataset (available in benchmark repo) where schools have many projects.

{
   var(func:type(School),first:10) {
    c as count(~project_school)
  }
  list(func:uid(c),orderdesc:val(c)){
    name
    numberOfProjects:count(~project_school)
  }
}

Will give you the kind of aggregation you are looking for (from what I understand).

{
  "data": {
    "list": [
      {
        "name": "Delaware Elementary Equity School",
        "numberOfProjects": 16
      },
      {
        "name": "L E Monahan Elementary School",
        "numberOfProjects": 14
      },
      {
        "name": "Philadelphia Performing Arts Charter School - West Campus",
        "numberOfProjects": 8
      },...
1 Like