How can i get the last item of a orderBy in dexie.js?
I must admit, I am a bit confused about when an operation needs to bed done on a collection and when it needs to be done on a table in dexie js.
So I am not sure, whether this is the right approach (which is not working anyway) to achieve my goal.
What I'd like to do is sort a table named "products" in the database "shopDb" by the field "updated_at", and get the last item on the result, like this:
shopDb.products.orderBy('updated_at').last().then((result) => { // stuff });
This code already crashes on sortBy because:
TypeError: shopDb.products.orderBy is not a function
I must be missing something fundamental here.
javascript dexie
asked Dec 28 '18 at 5:37
LongHikeLongHike
712923
add a comment |
I must admit, I am a bit confused about when an operation needs to bed done on a collection and when it needs to be done on a table in dexie js.
So I am not sure, whether this is the right approach (which is not working anyway) to achieve my goal.
What I'd like to do is sort a table named "products" in the database "shopDb" by the field "updated_at", and get the last item on the result, like this:
shopDb.products.orderBy('updated_at').last().then((result) => { // stuff });
This code already crashes on sortBy because:
TypeError: shopDb.products.orderBy is not a function
I must be missing something fundamental here.
javascript dexie
asked Dec 28 '18 at 5:37
LongHikeLongHike
712923
See if jsfiddle.net/dfahlander/3tf5r0cu helps.
– shahkalpesh
Dec 28 '18 at 5:57
No, it does not help, sorry.
– LongHike
Dec 28 '18 at 6:18
I am sorry. Here is the corrected one usingorderBy- jsfiddle.net/0qgr9zto
– shahkalpesh
Dec 28 '18 at 7:13
1
If you post it as an answer, I will mark it. Thanks!
– LongHike
Dec 28 '18 at 8:37
No worries. I am not sure what fixed it for you because I saw theorderBymethod. If it was a overlook/spelling mistake or any such thing, you can close this. If you think your finding can help others, post an answer.
– shahkalpesh
Dec 28 '18 at 15:47
add a comment |
I must admit, I am a bit confused about when an operation needs to bed done on a collection and when it needs to be done on a table in dexie js.
So I am not sure, whether this is the right approach (which is not working anyway) to achieve my goal.
What I'd like to do is sort a table named "products" in the database "shopDb" by the field "updated_at", and get the last item on the result, like this:
shopDb.products.orderBy('updated_at').last().then((result) => { // stuff });
This code already crashes on sortBy because:
TypeError: shopDb.products.orderBy is not a function
I must be missing something fundamental here.
javascript dexie
asked Dec 28 '18 at 5:37
LongHikeLongHike
712923
I must admit, I am a bit confused about when an operation needs to bed done on a collection and when it needs to be done on a table in dexie js.
So I am not sure, whether this is the right approach (which is not working anyway) to achieve my goal.
What I'd like to do is sort a table named "products" in the database "shopDb" by the field "updated_at", and get the last item on the result, like this:
shopDb.products.orderBy('updated_at').last().then((result) => { // stuff });
This code already crashes on sortBy because:
TypeError: shopDb.products.orderBy is not a function
I must be missing something fundamental here.
javascript dexie
javascript dexie
asked Dec 28 '18 at 5:37
LongHikeLongHike
712923
asked Dec 28 '18 at 5:37
LongHikeLongHike
712923
edited Dec 28 '18 at 5:42
LongHike
asked Dec 28 '18 at 5:37
LongHikeLongHike
712923
asked Dec 28 '18 at 5:37
LongHikeLongHike
712923
asked Dec 28 '18 at 5:37
LongHikeLongHike
712923
712923
See if jsfiddle.net/dfahlander/3tf5r0cu helps.
– shahkalpesh
Dec 28 '18 at 5:57
No, it does not help, sorry.
– LongHike
Dec 28 '18 at 6:18
I am sorry. Here is the corrected one usingorderBy- jsfiddle.net/0qgr9zto
– shahkalpesh
Dec 28 '18 at 7:13
1
If you post it as an answer, I will mark it. Thanks!
– LongHike
Dec 28 '18 at 8:37
No worries. I am not sure what fixed it for you because I saw theorderBymethod. If it was a overlook/spelling mistake or any such thing, you can close this. If you think your finding can help others, post an answer.
– shahkalpesh
Dec 28 '18 at 15:47
add a comment |
See if jsfiddle.net/dfahlander/3tf5r0cu helps.
– shahkalpesh
Dec 28 '18 at 5:57
No, it does not help, sorry.
– LongHike
Dec 28 '18 at 6:18
I am sorry. Here is the corrected one usingorderBy- jsfiddle.net/0qgr9zto
– shahkalpesh
Dec 28 '18 at 7:13
1
If you post it as an answer, I will mark it. Thanks!
– LongHike
Dec 28 '18 at 8:37
No worries. I am not sure what fixed it for you because I saw theorderBymethod. If it was a overlook/spelling mistake or any such thing, you can close this. If you think your finding can help others, post an answer.
– shahkalpesh
Dec 28 '18 at 15:47
See if jsfiddle.net/dfahlander/3tf5r0cu helps.
– shahkalpesh
Dec 28 '18 at 5:57
See if jsfiddle.net/dfahlander/3tf5r0cu helps.
– shahkalpesh
Dec 28 '18 at 5:57
No, it does not help, sorry.
– LongHike
Dec 28 '18 at 6:18
No, it does not help, sorry.
– LongHike
Dec 28 '18 at 6:18
I am sorry. Here is the corrected one using
orderBy - jsfiddle.net/0qgr9zto– shahkalpesh
Dec 28 '18 at 7:13
I am sorry. Here is the corrected one using
orderBy - jsfiddle.net/0qgr9zto– shahkalpesh
Dec 28 '18 at 7:13
1
1
If you post it as an answer, I will mark it. Thanks!
– LongHike
Dec 28 '18 at 8:37
If you post it as an answer, I will mark it. Thanks!
– LongHike
Dec 28 '18 at 8:37
No worries. I am not sure what fixed it for you because I saw the
orderBy method. If it was a overlook/spelling mistake or any such thing, you can close this. If you think your finding can help others, post an answer.– shahkalpesh
Dec 28 '18 at 15:47
No worries. I am not sure what fixed it for you because I saw the
orderBy method. If it was a overlook/spelling mistake or any such thing, you can close this. If you think your finding can help others, post an answer.– shahkalpesh
Dec 28 '18 at 15:47
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%2f53954109%2fhow-can-i-get-the-last-item-of-a-orderby-in-dexie-js%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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53954109%2fhow-can-i-get-the-last-item-of-a-orderby-in-dexie-js%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
See if jsfiddle.net/dfahlander/3tf5r0cu helps.
– shahkalpesh
Dec 28 '18 at 5:57
No, it does not help, sorry.
– LongHike
Dec 28 '18 at 6:18
I am sorry. Here is the corrected one using
orderBy- jsfiddle.net/0qgr9zto– shahkalpesh
Dec 28 '18 at 7:13
1
If you post it as an answer, I will mark it. Thanks!
– LongHike
Dec 28 '18 at 8:37
No worries. I am not sure what fixed it for you because I saw the
orderBymethod. If it was a overlook/spelling mistake or any such thing, you can close this. If you think your finding can help others, post an answer.– shahkalpesh
Dec 28 '18 at 15:47