GreenFairy.CQL.Scalars.ArrayString (GreenFairy v0.3.0)

View Source

CQL scalar for string array fields.

Operators

  • :_includes - Array contains value
  • :_excludes - Array does not contain value
  • :_includes_all - Array contains all values
  • :_excludes_all - Array contains none of the values
  • :_includes_any - Array contains any of the values
  • :_excludes_any - Array does not contain all values
  • :_is_empty - Array is empty
  • :_is_null - Array is null

Adapter Variations

  • PostgreSQL: Native array operators (@>, &&)
  • MySQL: JSON_CONTAINS, JSON_OVERLAPS
  • SQLite: Limited JSON1 support
  • MSSQL: OPENJSON with EXISTS
  • Exlasticsearch: Native multi-value fields