Devographics / Monorepo

Monorepo containing the State of JS apps
surveyform-sigma.vercel.app
Other
134 stars 52 forks source link

[results/js2023/years_of_experience] runQuery Issue: addOverallBucket: no overall results found #386

Closed antonromankov closed 4 months ago

antonromankov commented 4 months ago

Edition ID

js2023

Block ID

years_of_experience

Filters:

{
  "options": {
    "showDefaultSeries": false,
    "enableYearSelect": false,
    "mode": "grid",
    "queryOnLoad": false,
    "cutoff": 10,
    "cutoffType": "count",
    "limit": 20,
    "mergeOtherBuckets": false,
    "preventQuery": false
  },
  "filters": [
    {
      "year": 2023,
      "conditions": [
        {
          "fieldId": "country",
          "sectionId": "user_info",
          "operator": "eq",
          "value": "AUS"
        },
        {
          "fieldId": "react",
          "sectionId": "front_end_frameworks",
          "operator": "eq",
          "value": "would_use"
        }
      ]
    }
  ],
  "facet": {
    "sectionId": "user_info",
    "id": "yearly_salary"
  }
}

Query:


query {
    surveys {
    state_of_js {
        js2023 {
        user_info {

        years_of_experience_by_yearly_salary_1: years_of_experience {
            id

            responses(facet: user_info__yearly_salary, filters: {user_info__country:{eq:AUS},front_end_frameworks__react:{eq:would_use}}, parameters: {cutoff:10,facetCutoff:10,limit:20}) {
            currentEdition {

                completion {
                    count
                    percentageSurvey
                    total
                }
                average
                percentiles {
                    p50
                }

                buckets {
                    count
                    id
                    percentageQuestion
                    percentageSurvey
                    hasInsufficientData
                    entity {
    name
    nameHtml
    nameClean
    alias
    description
    descriptionHtml
    descriptionClean
    id
    entityType
    example {
      label
      language
      code
      codeHighlighted
    }
    avatar {
      url
    }
    homepage {
      url
    }
    youtube {
      url
    }
    twitter {
      url
    }
    twitch {
      url
    }
    rss {
      url
    }
    blog {
        url
    }
    mastodon {
        url
    }
    github {
        url
    }
    npm {
        url
    }
    mdn {
        url
    }
    caniuse {
        url
    }
    resources {
        url
        title
    }
}
                    averageByFacet

    percentilesByFacet {
        p0
        p10
        p25
        p50
        p75
        p90
        p100
    }

    facetBuckets {
        id
        count
        percentageBucket
        percentageQuestion
        hasInsufficientData
        entity {
    name
    nameHtml
    nameClean
    alias
    description
    descriptionHtml
    descriptionClean
    id
    entityType
    example {
      label
      language
      code
      codeHighlighted
    }
    avatar {
      url
    }
    homepage {
      url
    }
    youtube {
      url
    }
    twitter {
      url
    }
    twitch {
      url
    }
    rss {
      url
    }
    blog {
        url
    }
    mastodon {
        url
    }
    github {
        url
    }
    npm {
        url
    }
    mdn {
        url
    }
    caniuse {
        url
    }
    resources {
        url
        title
    }
}
        token {
    id
    parentId
}
    }

                }
            }
            }
        }
        }
        }
    }
    }
}

Location

https://2023.stateofjs.com/en-US/demographics/

Timestamp

Fri Jun 21 2024 13:46:49 GMT+0200 (Центральная Европа, летнее время)

Error:

  {
  "message": "addOverallBucket: no overall results found",
  "locations": [
    {
      "line": 13,
      "column": 13
    }
  ],
  "path": [
    "surveys",
    "state_of_js",
    "js2023",
    "user_info",
    "years_of_experience_by_yearly_salary_1",
    "responses",
    "currentEdition"
  ],
  "extensions": {
    "code": "INTERNAL_SERVER_ERROR"
  }
}
SachaG commented 4 months ago

This is because we switched to a new format to store some of the data, so the query is now wrong. I'm deploying a fix.