OrchardCMS / OrchardDoc

Documentation for Orchard 1.x (not Orchard Core, for that see https://docs.orchardcore.net/).
http://docs.orchardproject.net
142 stars 242 forks source link

Localization.Culture filter does not work #359

Closed PogudinaAnnaYu closed 4 years ago

PogudinaAnnaYu commented 4 years ago

Hi! We use "OrchardCore.Application.Cms.Targets" Version="1.0.0-rc1-12653" and "OrchardCore.Translations.ru" Version="1.0.0-rc1-105368" We have a dictionary which has fields: title and localization. We get an error when we make query in GraphQl with filter by Localization.Culture. Query which we make:

query MyQuery {
  localizationDictionary(where: {localization: {localizationSet: "", culture: "ru"}}) {
    localization {
      culture
      localizationSet
    }
    displayText
  }
}

Answer from server which we get (error message translated from Russian):

"extensions": {
        "code": "POSTGRES",
        "data": {
          "Severity": "ERROR",
          "InvariantSeverity": "ERROR",
          "SqlState": "42703",
          "MessageText": "column LocalizedContentItemIndex.culture is not found",
          "Hint": "Perhaps a column reference was supposed \"LocalizedContentItemIndex.Culture\".",
          "Position": 385,
          "File": "d:\\pginstaller.auto\\postgres.windows-x64\\src\\backend\\parser\\parse_relation.c",
          "Line": "3294",
          "Routine": "errorMissingColumn"
        }
      }

Do you know what is the problem?

Skrypt commented 4 years ago

That's a duplicate. Issue is related with PostgreSQL case sensitivity. The correct column name is LocalizedContentItemIndex.Culture. I'm closing as you posted the issue in the wrong place.