Handle addition of firestore documents in multiple orderBy pagination query
I am struggling for quite a while now trying to achieve a live pagination.
I have the following query:
getBatch(offset: { prio: number, posted: Date} | null) {
return this.db
.collection('jobs', ref =>
ref.orderBy('prio')
.orderBy('posted', 'desc')
.startAfter(offset ? offset.prio: null, offset ? offset.posted: null)
.limit(10)
)
.stateChanges()
.pipe(...mapping the result - skipped for shortening...)
}
Basically the results are being accumulated in an array that is passed to an infinite-scroll in ionic 4. The offset comes from the last rendered item on the infinite-scroll.
Everything works fine, pagination works great, and data is being properly updated. The problem is when adding items to the jobs collection. FYI, multiple documents can have the same prio value, ranging from 0 to 5.
When a new document is being added the last document from the batch it suppose to go gets removed(to make space for the newly added one) and this makes that last removed document not belong to any batch now, losing any real time updates on it.
I hope I clearly exposed my scenario and hope someone with greater experience than myself would be kind enough to guide me on how to overcome this situation.
Thank you very much for your time!
typescript firebase google-cloud-firestore angularfire2 ionic4
asked Nov 20 '18 at 19:51
RollyRolly
2818
add a comment |
I am struggling for quite a while now trying to achieve a live pagination.
I have the following query:
getBatch(offset: { prio: number, posted: Date} | null) {
return this.db
.collection('jobs', ref =>
ref.orderBy('prio')
.orderBy('posted', 'desc')
.startAfter(offset ? offset.prio: null, offset ? offset.posted: null)
.limit(10)
)
.stateChanges()
.pipe(...mapping the result - skipped for shortening...)
}
Basically the results are being accumulated in an array that is passed to an infinite-scroll in ionic 4. The offset comes from the last rendered item on the infinite-scroll.
Everything works fine, pagination works great, and data is being properly updated. The problem is when adding items to the jobs collection. FYI, multiple documents can have the same prio value, ranging from 0 to 5.
When a new document is being added the last document from the batch it suppose to go gets removed(to make space for the newly added one) and this makes that last removed document not belong to any batch now, losing any real time updates on it.
I hope I clearly exposed my scenario and hope someone with greater experience than myself would be kind enough to guide me on how to overcome this situation.
Thank you very much for your time!
typescript firebase google-cloud-firestore angularfire2 ionic4
asked Nov 20 '18 at 19:51
RollyRolly
2818
add a comment |
I am struggling for quite a while now trying to achieve a live pagination.
I have the following query:
getBatch(offset: { prio: number, posted: Date} | null) {
return this.db
.collection('jobs', ref =>
ref.orderBy('prio')
.orderBy('posted', 'desc')
.startAfter(offset ? offset.prio: null, offset ? offset.posted: null)
.limit(10)
)
.stateChanges()
.pipe(...mapping the result - skipped for shortening...)
}
Basically the results are being accumulated in an array that is passed to an infinite-scroll in ionic 4. The offset comes from the last rendered item on the infinite-scroll.
Everything works fine, pagination works great, and data is being properly updated. The problem is when adding items to the jobs collection. FYI, multiple documents can have the same prio value, ranging from 0 to 5.
When a new document is being added the last document from the batch it suppose to go gets removed(to make space for the newly added one) and this makes that last removed document not belong to any batch now, losing any real time updates on it.
I hope I clearly exposed my scenario and hope someone with greater experience than myself would be kind enough to guide me on how to overcome this situation.
Thank you very much for your time!
typescript firebase google-cloud-firestore angularfire2 ionic4
asked Nov 20 '18 at 19:51
RollyRolly
2818
I am struggling for quite a while now trying to achieve a live pagination.
I have the following query:
getBatch(offset: { prio: number, posted: Date} | null) {
return this.db
.collection('jobs', ref =>
ref.orderBy('prio')
.orderBy('posted', 'desc')
.startAfter(offset ? offset.prio: null, offset ? offset.posted: null)
.limit(10)
)
.stateChanges()
.pipe(...mapping the result - skipped for shortening...)
}
Basically the results are being accumulated in an array that is passed to an infinite-scroll in ionic 4. The offset comes from the last rendered item on the infinite-scroll.
Everything works fine, pagination works great, and data is being properly updated. The problem is when adding items to the jobs collection. FYI, multiple documents can have the same prio value, ranging from 0 to 5.
When a new document is being added the last document from the batch it suppose to go gets removed(to make space for the newly added one) and this makes that last removed document not belong to any batch now, losing any real time updates on it.
I hope I clearly exposed my scenario and hope someone with greater experience than myself would be kind enough to guide me on how to overcome this situation.
Thank you very much for your time!
typescript firebase google-cloud-firestore angularfire2 ionic4
typescript firebase google-cloud-firestore angularfire2 ionic4
asked Nov 20 '18 at 19:51
RollyRolly
2818
asked Nov 20 '18 at 19:51
RollyRolly
2818
edited Nov 20 '18 at 22:17
Rolly
asked Nov 20 '18 at 19:51
RollyRolly
2818
asked Nov 20 '18 at 19:51
RollyRolly
2818
asked Nov 20 '18 at 19:51
RollyRolly
2818
2818
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53400552%2fhandle-addition-of-firestore-documents-in-multiple-orderby-pagination-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53400552%2fhandle-addition-of-firestore-documents-in-multiple-orderby-pagination-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
