Flutter [cloud_firestore/unknown] An error occurred while parsing query arguments 'field == orders[0][0]': The initial orderBy() field '[[FieldPathType.documentId, false]][0][0]' has to be the same as the where() field parameter 'FieldPath([userType])' ..

[Error]

1. Flutter [cloud_firestore/unknown] An error occurred while parsing query arguments

 

2. 'field == orders[0][0]': The initial orderBy() field '[[FieldPathType.documentId, false]][0][0]' has to be the same as the where() field parameter 'FieldPath([userType])' when an inequality operator is invoked.

 

나의 경우 .where('data', isNotEqualTo: 'value')와 startAfterDocument()를 같이 사용하려고 했을 때 오류가 발생했다.

.where('userType', isNotEqualTo: '이용회원')
.startAfterDocument(lastDocSnap)

 

오류원인은 Firebase의 쿼리 규칙에 따른것이며 아래와 같다.

If you include a filter with a range comparison (<, <=, >, >=), your first ordering must be on the same field

 

[solution]

문제가 생긴 쿼리와 같은 .orderBy()를 추가해주면 된다.

.where('userType', isNotEqualTo: '이용회원')
.orderBy('userType')
.startAfterDocument(lastDocSnap)