Access the last element of a nested database
0
How to get the last element in a nested database in firebase.
This is my db
In this there are several ids and for each id under the bot's msg i want the last message which in this case will be
I am fine.Thank You....
I know the brute approach but it will take a lot of time.
Here is my code :
return ref.child(user).once('value').then((snapshot) => {
var i = 0;
snapshot.forEach((snap) => {
console.log(snap.child('bot').child('msg').msg);
snap.child('bot').child('msg')
.forEach((openTicketSnapshot) => {
var val = openTicketSnapshot.val();
val.forEach((text) => {
userMsg2.push({
'who': 'User',
'msg': text.msg,
'time': text.timestamp
});
})
});
//Here i will access the last index of userMsg
var data1 = {
"data": "found"
};
res.json(data1);
// ...
return data1;
})
How to do this efficiently?
node.js firebase firebase-realtime-database
edited Nov 22 '18 at 21:56
Frank van Puffelen
234k29380407
asked Nov 22 '18 at 19:59
aeshna Kashyapaeshna Kashyap
347
|
show 1 more comment
0
How to get the last element in a nested database in firebase.
This is my db
In this there are several ids and for each id under the bot's msg i want the last message which in this case will be
I am fine.Thank You....
I know the brute approach but it will take a lot of time.
Here is my code :
return ref.child(user).once('value').then((snapshot) => {
var i = 0;
snapshot.forEach((snap) => {
console.log(snap.child('bot').child('msg').msg);
snap.child('bot').child('msg')
.forEach((openTicketSnapshot) => {
var val = openTicketSnapshot.val();
val.forEach((text) => {
userMsg2.push({
'who': 'User',
'msg': text.msg,
'time': text.timestamp
});
})
});
//Here i will access the last index of userMsg
var data1 = {
"data": "found"
};
res.json(data1);
// ...
return data1;
})
How to do this efficiently?
node.js firebase firebase-realtime-database
edited Nov 22 '18 at 21:56
Frank van Puffelen
234k29380407
asked Nov 22 '18 at 19:59
aeshna Kashyapaeshna Kashyap
347
you can use limitToLast in that reference
– Gastón Saillén
Nov 22 '18 at 20:04
But i want all the id and for each id i want the bot's last message
– aeshna Kashyap
Nov 22 '18 at 20:05
what does thisconsole.log(snap.child('bot').child('msg').msg);give you?
– Peter Haddad
Nov 22 '18 at 20:22
undefined value
– aeshna Kashyap
Nov 22 '18 at 20:24
yes I thought so..,console.log(snapshot)should contain all data insideuserand contain all theidsyou can then dosnap.child('bot').child('msg').limitToLast(1) .forEach((openTicketSnapshot) => {to get the last one
– Peter Haddad
Nov 22 '18 at 20:28
|
show 1 more comment
0
0
0
How to get the last element in a nested database in firebase.
This is my db
In this there are several ids and for each id under the bot's msg i want the last message which in this case will be
I am fine.Thank You....
I know the brute approach but it will take a lot of time.
Here is my code :
return ref.child(user).once('value').then((snapshot) => {
var i = 0;
snapshot.forEach((snap) => {
console.log(snap.child('bot').child('msg').msg);
snap.child('bot').child('msg')
.forEach((openTicketSnapshot) => {
var val = openTicketSnapshot.val();
val.forEach((text) => {
userMsg2.push({
'who': 'User',
'msg': text.msg,
'time': text.timestamp
});
})
});
//Here i will access the last index of userMsg
var data1 = {
"data": "found"
};
res.json(data1);
// ...
return data1;
})
How to do this efficiently?
node.js firebase firebase-realtime-database
edited Nov 22 '18 at 21:56
Frank van Puffelen
234k29380407
asked Nov 22 '18 at 19:59
aeshna Kashyapaeshna Kashyap
347
How to get the last element in a nested database in firebase.
This is my db
In this there are several ids and for each id under the bot's msg i want the last message which in this case will be
I am fine.Thank You....
I know the brute approach but it will take a lot of time.
Here is my code :
return ref.child(user).once('value').then((snapshot) => {
var i = 0;
snapshot.forEach((snap) => {
console.log(snap.child('bot').child('msg').msg);
snap.child('bot').child('msg')
.forEach((openTicketSnapshot) => {
var val = openTicketSnapshot.val();
val.forEach((text) => {
userMsg2.push({
'who': 'User',
'msg': text.msg,
'time': text.timestamp
});
})
});
//Here i will access the last index of userMsg
var data1 = {
"data": "found"
};
res.json(data1);
// ...
return data1;
})
How to do this efficiently?
node.js firebase firebase-realtime-database
node.js firebase firebase-realtime-database
edited Nov 22 '18 at 21:56
Frank van Puffelen
234k29380407
asked Nov 22 '18 at 19:59
aeshna Kashyapaeshna Kashyap
347
edited Nov 22 '18 at 21:56
Frank van Puffelen
234k29380407
asked Nov 22 '18 at 19:59
aeshna Kashyapaeshna Kashyap
347
edited Nov 22 '18 at 21:56
Frank van Puffelen
234k29380407
edited Nov 22 '18 at 21:56
Frank van Puffelen
234k29380407
edited Nov 22 '18 at 21:56
Frank van Puffelen
234k29380407
234k29380407
asked Nov 22 '18 at 19:59
aeshna Kashyapaeshna Kashyap
347
asked Nov 22 '18 at 19:59
aeshna Kashyapaeshna Kashyap
347
asked Nov 22 '18 at 19:59
aeshna Kashyapaeshna Kashyap
347
347
you can use limitToLast in that reference
– Gastón Saillén
Nov 22 '18 at 20:04
But i want all the id and for each id i want the bot's last message
– aeshna Kashyap
Nov 22 '18 at 20:05
what does thisconsole.log(snap.child('bot').child('msg').msg);give you?
– Peter Haddad
Nov 22 '18 at 20:22
undefined value
– aeshna Kashyap
Nov 22 '18 at 20:24
yes I thought so..,console.log(snapshot)should contain all data insideuserand contain all theidsyou can then dosnap.child('bot').child('msg').limitToLast(1) .forEach((openTicketSnapshot) => {to get the last one
– Peter Haddad
Nov 22 '18 at 20:28
|
show 1 more comment
you can use limitToLast in that reference
– Gastón Saillén
Nov 22 '18 at 20:04
But i want all the id and for each id i want the bot's last message
– aeshna Kashyap
Nov 22 '18 at 20:05
what does thisconsole.log(snap.child('bot').child('msg').msg);give you?
– Peter Haddad
Nov 22 '18 at 20:22
undefined value
– aeshna Kashyap
Nov 22 '18 at 20:24
yes I thought so..,console.log(snapshot)should contain all data insideuserand contain all theidsyou can then dosnap.child('bot').child('msg').limitToLast(1) .forEach((openTicketSnapshot) => {to get the last one
– Peter Haddad
Nov 22 '18 at 20:28
you can use limitToLast in that reference
– Gastón Saillén
Nov 22 '18 at 20:04
you can use limitToLast in that reference
– Gastón Saillén
Nov 22 '18 at 20:04
But i want all the id and for each id i want the bot's last message
– aeshna Kashyap
Nov 22 '18 at 20:05
But i want all the id and for each id i want the bot's last message
– aeshna Kashyap
Nov 22 '18 at 20:05
what does this
console.log(snap.child('bot').child('msg').msg); give you?– Peter Haddad
Nov 22 '18 at 20:22
what does this
console.log(snap.child('bot').child('msg').msg); give you?– Peter Haddad
Nov 22 '18 at 20:22
undefined value
– aeshna Kashyap
Nov 22 '18 at 20:24
undefined value
– aeshna Kashyap
Nov 22 '18 at 20:24
yes I thought so..,
console.log(snapshot) should contain all data inside user and contain all the ids you can then do snap.child('bot').child('msg').limitToLast(1) .forEach((openTicketSnapshot) => { to get the last one– Peter Haddad
Nov 22 '18 at 20:28
yes I thought so..,
console.log(snapshot) should contain all data inside user and contain all the ids you can then do snap.child('bot').child('msg').limitToLast(1) .forEach((openTicketSnapshot) => { to get the last one– Peter Haddad
Nov 22 '18 at 20:28
|
show 1 more 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
});
}
});
draft saved
draft discarded
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%2f53437389%2faccess-the-last-element-of-a-nested-database%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
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53437389%2faccess-the-last-element-of-a-nested-database%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
you can use limitToLast in that reference
– Gastón Saillén
Nov 22 '18 at 20:04
But i want all the id and for each id i want the bot's last message
– aeshna Kashyap
Nov 22 '18 at 20:05
what does this
console.log(snap.child('bot').child('msg').msg);give you?– Peter Haddad
Nov 22 '18 at 20:22
undefined value
– aeshna Kashyap
Nov 22 '18 at 20:24
yes I thought so..,
console.log(snapshot)should contain all data insideuserand contain all theidsyou can then dosnap.child('bot').child('msg').limitToLast(1) .forEach((openTicketSnapshot) => {to get the last one– Peter Haddad
Nov 22 '18 at 20:28