angularfire5 & firebase自动补全等同于哪里？

Question

我使用angularfire2 v5的firebase自动完成服务如下所示：

getUsersTypeAhead(searchString: string) {
    const list: AngularFireList<User> = this.fireBase.list('/users', ref => ref
        .orderByChild('name')
        .limitToFirst(10)
        .startAt(searchString)
        .endAt(searchString + '\uf8ff')
    );
    return list.snapshotChanges().pipe(
        map(items => items.map(item => ({
            key: item.key,
            name: item.payload.val().name
        })))
    );
}

但是，这似乎是区分大小写的。这是否存在限制，或者是否存在类似于mySQL中的查询？

Answer 1

请看这里的答案Making a firebase query search NOT case sensitive

getUsersTypeAhead(searchString: string) {
    const list: AngularFireList<User> = this.fireBase.list('/users', ref => ref
        .orderByChild('name')
        .limitToFirst(5)
        .startAt(searchString.toUpperCase())
        .endAt(searchString.toLowerCase() + '\uf8ff')
    );
    return list.snapshotChanges().pipe(
        map(items => items.map(item => ({
            key: item.key,
            name: item.payload.val().name
        })))
    );
}