Retrieving certain data from a MongoDB

[UnborN]

@Schlitz

I save the values differently than I want to retrieve them now

ok .. so this explains why you dont get a result now .. i was going to recommend to review the way you save the data in mongo because from your previous screenshot it seems that you were saving some unnecessary fields in each document (for example the data were nested under payload, saving topic, socketid, _msgid )

@Schlitz

My input is done through 8 input fields on the Node Red dashboard, which are then bundeled together before I save them in MongoDB through a join node.

that can work but you could also use a Form ui_form node that gathers all the data and sends them with a Submit button.

@Schlitz

Do I need to address the data differently to retrieve it?

Probably. It depends on how your data in mongodb looks like now after the changes you made
Can you show us a screenshot of a couple of records ? (documents in mongodb)

[Schlitz]

Okay, I have now inserted a ui_form node as you suggested (I have removed the individual text nodes and the join node)

However, I think the data is still stored in MongoDB in the same way: (The last one is made with the new ui_form node - just typing "5" in every field

Here is my current data acquisition flow. Starting with the now new Ui_Form Node, followd by a function "6" (In "function 6" I add a static addition to some values to bring them to a certain standard format): , after that uploading it with a mongoDB out node

[UnborN]

@Schlitz

However, I think the data is still stored in MongoDB in the same way

In the mongodb out node .. that saves the new document ..
do you have the option to save only the payload checked ?

[Schlitz]

Thanks for the comment, I had forgotten about that.

Thats my complete flow now:

I have emptied my MongoDB and imported two new documents.

However, the query still simply outputs all values (in this case now just the 2):

[UnborN]

Much cleaner now with the db

Whats in your Function 7 now ?
it can be :

msg.payload = { "parentID": msg.payload }
// msg.projection = { "parentID" : 1 }
return msg;

[Schlitz]

Nice!
Now it works with your code! Thanks!

(I will now make a few more adjustments.. i hope i can manage the rest on my own)