Skip to content
This repository has been archived by the owner on Oct 26, 2021. It is now read-only.

Query with entity set returns empty result #576

Open
jheeffer opened this issue Nov 16, 2017 · 0 comments
Open

Query with entity set returns empty result #576

jheeffer opened this issue Nov 16, 2017 · 0 comments

Comments

@jheeffer
Copy link
Member

jheeffer commented Nov 16, 2017

The following query should return the same datapoint data as with "key": ["geo","time"] but instead returns an empty result.

Also see correct DDFcsv reader behaviour (fixed recently): https://jsfiddle.net/jasperh/gxcdd8v4/11/

Query:

{
  "language": "en",
  "from": "datapoints",
  "animatable": "time",
  "select": {
    "key": [
      "country",
      "time"
    ],
    "value": [
      "income_per_person_gdppercapita_ppp_inflation_adjusted"
    ]
  },
  "where": {
    "$and": [
      {
        "time": "$time"
      }
    ]
  },
  "join": {
    "$time": {
      "key": "time",
      "where": {
        "time": {
          "$gte": "1993",
          "$lte": "2015"
        }
      }
    }
  },
  "order_by": [
    "time"
  ],
  "dataset": "open-numbers/ddf--gapminder--systema_globalis"
}
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant