ParseErrorCode
ShopifyQL parsing errors.
Anchor to Valid valuesValid values
- Anchor to BACKFILL_DATE_RANGE_NOT_FOUNDBACKFILL_DATE_RANGE_NOT_FOUND•
When using
with themodifier,ormust be defined.- Anchor to COLUMN_NOT_FOUNDCOLUMN_NOT_FOUND•
Column not found.
- Anchor to COMPARE_TO_INCOMPATIBLE_PERIODCOMPARE_TO_INCOMPATIBLE_PERIOD•
The time period for
must be the same length as.- Anchor to COMPARE_TO_INVALID_PERIODCOMPARE_TO_INVALID_PERIOD•
Invalid
period specified. Make sure it's not the same as theclause.- Anchor to COMPARE_TO_MISSING_PERIODCOMPARE_TO_MISSING_PERIOD•
Cannot use a
clause withoutor.- Anchor to COMPARISON_WITH_NON_AGGREGATE_FIELDSCOMPARISON_WITH_NON_AGGREGATE_FIELDS•
Comparison queries must only contain aggregated fields.
- Anchor to DATE_INTERVAL_NOT_FOUNDDATE_INTERVAL_NOT_FOUND•
Date interval not found.
- Anchor to DATE_NOT_PARSABLEDATE_NOT_PARSABLE•
Date isn't parsable.
- Anchor to DATE_TIME_NOT_PARSABLEDATE_TIME_NOT_PARSABLE•
Datetime value isn't parsable.
- Anchor to EXCESS_BACKFILL_DIMENSIONSEXCESS_BACKFILL_DIMENSIONS•
The
function is limited to one parameter with themodifier.- Anchor to EXCESS_DIMENSIONSEXCESS_DIMENSIONS•
The
function has too many parameters. When usingwithuse only oneparameter.- Anchor to EXCESS_PERIODSEXCESS_PERIODS•
Mixing of
and/orwithis not allowed.- Anchor to EXCESS_PRESENTMENTSEXCESS_PRESENTMENTS•
Use the correct syntax for either
or.- Anchor to FROM_NOT_FOUNDFROM_NOT_FOUND•
Keyword
not found.- Anchor to FUNCTION_ARGUMENTS_NOT_FOUNDFUNCTION_ARGUMENTS_NOT_FOUND•
Function is missing required argument(s).
- Anchor to FUNCTION_EXCESS_ARGUMENTSFUNCTION_EXCESS_ARGUMENTS•
Function has too many arguments.
- Anchor to FUNCTION_INCOMPATIBLE_TYPESFUNCTION_INCOMPATIBLE_TYPES•
Function has incompatible types.
- Anchor to FUNCTION_MODIFIER_NOT_FOUNDFUNCTION_MODIFIER_NOT_FOUND•
Function does not have any valid modifiers.
- Anchor to FUNCTION_NESTED_AGGREGATEFUNCTION_NESTED_AGGREGATE•
An aggregate function received a nested aggregate argument, which is not allowed.
- Anchor to FUNCTION_NOT_FOUNDFUNCTION_NOT_FOUND•
Function not found.
- Anchor to INVALID_DATE_RANGEINVALID_DATE_RANGE•
The
date must be before or the same as thedate.- Anchor to LIMIT_INVALIDLIMIT_INVALID•
Limit is invalid.
- Anchor to LIST_MIXED_ARGUMENT_TYPESLIST_MIXED_ARGUMENT_TYPES•
Mixing of
list arguments of different data types is not allowed.- Anchor to MIXED_AGGREGATE_AND_NON_AGGREGATEMIXED_AGGREGATE_AND_NON_AGGREGATE•
Mixing an aggregate expression and a non-aggregate expression is not allowed.
- Anchor to NAMED_DATE_NOT_FOUNDNAMED_DATE_NOT_FOUND•
Named date not found.
- Anchor to OPERATOR_INCOMPATIBLE_TYPESOPERATOR_INCOMPATIBLE_TYPES•
Invalid arguments for operator.
- Anchor to PRESENTMENT_NOT_FOUNDPRESENTMENT_NOT_FOUND•
Query is missing
or.- Anchor to REQUIRED_GROUP_BY_NOT_FOUNDREQUIRED_GROUP_BY_NOT_FOUND•
Column must include
arg1.- Anchor to SEMANTICALLY_INVALIDSEMANTICALLY_INVALID•
Semantically invalid.
- Anchor to SORT_FIELD_NOT_FOUNDSORT_FIELD_NOT_FOUND•
Sort field not found.
- Anchor to SYNTAX_FAILED_PREDICATESYNTAX_FAILED_PREDICATE•
A semantic predicate failed during validation.
- Anchor to SYNTAX_INPUT_MISMATCHSYNTAX_INPUT_MISMATCH•
Identifier or function out of place.
- Anchor to SYNTAX_INVALID_TOKENSYNTAX_INVALID_TOKEN•
Invalid entry.
- Anchor to SYNTAX_MISSING_TOKENSYNTAX_MISSING_TOKEN•
Query is incomplete.
- Anchor to SYNTAX_NO_VIABLE_ALTERNATIVESYNTAX_NO_VIABLE_ALTERNATIVE•
Identifier after
is not valid in its current position.- Anchor to SYNTAX_NOT_RECOGNIZEDSYNTAX_NOT_RECOGNIZED•
Syntax not recognized.
- Anchor to SYNTAX_UNWANTED_TOKENSYNTAX_UNWANTED_TOKEN•
Identifier or function out of place.
- Anchor to TABLE_NOT_FOUNDTABLE_NOT_FOUND•
Table not found.
- Anchor to TIME_FUNCTION_NOT_FOUNDTIME_FUNCTION_NOT_FOUND•
Time function is incompatible in a
clause with themodifier.- Anchor to UNBACKFILLED_TIME_GROUP_BY_COMPARISONUNBACKFILLED_TIME_GROUP_BY_COMPARISON•
When using
with a time-based,must be used.- Anchor to UNKNOWNUNKNOWN•
Unknown error.
- Anchor to VALUE_NOT_PARSABLEVALUE_NOT_PARSABLE•
Value isn't parsable.
- Anchor to VISUALIZE_CHART_TYPE_NOT_FOUNDVISUALIZE_CHART_TYPE_NOT_FOUND•
The type of visualization is invalid. Acceptable types: bar, line.
- Anchor to VISUALIZE_EXCESS_PROJECTIONSVISUALIZE_EXCESS_PROJECTIONS•
Visualize has too many projections.
- Anchor to VISUALIZE_GROUP_BY_MIXED_BACKFILLVISUALIZE_GROUP_BY_MIXED_BACKFILL•
Function
can only useorwith themodifier, not both.- Anchor to VISUALIZE_GROUP_BY_NOT_FOUNDVISUALIZE_GROUP_BY_NOT_FOUND•
Function
requires.- Anchor to VISUALIZE_INCOMPATIBLE_TYPESVISUALIZE_INCOMPATIBLE_TYPES•
Function
contains a data type which cannot be plotted.