platformOS Community

503 error on GraphQL aggregation query

matt Jun 18 2021 at 09:19

We've got an aggregation that used to work:

query{
  customizations(
    aggregations: {
      name: "form_item_count",
      filter: {
        properties: [
          { name: "email", exists: true }
        ]
      }
      fields: [
        {
          name: "results"
          field_name: "name.raw",
          type: terms
        }
      ]
    }
  ){
    aggregations{
      raw
    }
  }
}

It just started returning 503 error on most sites around late May. Is anyone else facing issues with aggregations lately?

Rich - DataOT Jun 29 2021 at 00:15

Does it work with records? Not sure when customizations will be phased out as they deprecated

matt Jun 30 2021 at 10:16

Sorry, didn't see this as no email notifications.

Can't do aggregations on records I don't think.

Rich - DataOT Jul 01 2021 at 04:59

The query works fine for me, but in the past I have broken features of the DB by uploading a model table with a reserved word for a column name (id)... (I broke related records for the entire instance)....bug has been reported... the only reason I found it was I tested the query on a naked (no code) instance of POS. Try with a new instance and see if it works... then it was trial and error until I found the model that was breaking it...

matt Jul 01 2021 at 05:43

pOS have fixed the issue now thankfully.

Please sign in or fill up your profile to answer a question