InvalidOrderingOperatorError() — supabase Function Reference

Source Code

apps/studio/components/grid/components/grid/GridError.tsx lines 115–146

const InvalidOrderingOperatorError = ({ error }: { error: ResponseError }) => {
  const { sorts, onApplySorts } = useTableSort()
  const invalidDataType = (error.message ?? '').split('type ').pop() ?? ''
  const formattedInvalidDataType = invalidDataType.includes('json')
    ? invalidDataType.toUpperCase()
    : invalidDataType

  return (
    <Admonition
      type="warning"
      className="pointer-events-auto"
      title={`Sorting is not supporting on ${sorts.length > 1 ? 'one of the selected columns' : 'the selected column'}`}
    >
      <p className="!mb-0">
        Unable to retrieve results as sorting is not supported on{' '}
        {sorts.length > 1 ? 'one of the selected columns' : 'the selected column'} due to its data
        type. ({formattedInvalidDataType})
      </p>
      <p className="!mb-2">
        Remove any sorts on columns with the data type {formattedInvalidDataType} applying the sorts
        again.
      </p>
      <p className="text-sm text-foreground-lighter prose max-w-full !mb-4">
        Error: <code className="text-code-inline">{error.message}</code>
      </p>

      <Button type="default" onClick={() => onApplySorts([])}>
        Remove sorts
      </Button>
    </Admonition>
  )
}