Filter json database with conditions

EL_tech · 5 June 2023 21:05

Hello,
I have a variable json database like this format

{
    "success": true,
    "center": {
        "lot": 88,
        "lng": 99
    },
    "results": [
        {
            "id": 8524,
            "name": "Kkkk",
            "fuels": [
                {
                    "id": 514,
                    "num": 1.871,
                    "name": "Be",
                    "fID": 1,
                    "Self": false
                },
                {
                    "id": 589,
                    "num": 1.879,
                    "name": "Be",
                    "fID": 1,
                    "Self": true
                },
                {
                    "id": 687,
                    "num": 1.719,
                    "name": "G",
                    "fID": 2,
                    "Self": false
                },
             ],
            "location": {
                "lot": 1587,
                "lng": 1474
            },
            "insertDate": "2023",
            "address": "test",
            "tk": "hello"
        },
        {
            "id": 24864,
            "name": "aaaaaaaaaaaaa",
            "fuels": [
                {
                    "id": 51455,
                    "num": 1.879,
                    "name": "Be",
                    "fID": 1,
                    "Self": true
                },
                {
                    "id": 9841,
                    "num": 1.719,
                    "name": "Ga",
                    "fID": 2,
                    "Self": true
                },
            ],
            "location": {
                "lot": 47
                "lng": 45
            },
            "insertDate": "2023",
            "address": "hgjnn",
            "tk": "test"
        }
    ]
}

and I would like to filter the content of the data record where contains for example the "name: "Be" ("fID": 1).
For example the filter resultat:

 ("name":) "Kkkk"
_______________
("num":) 1.871,
("name":) "Be",
("Self":) false
*******************
("num":) 1.879,
("name":) "Be",
("Self":) true
______________
"insertDate": "2023"
====================

  "name": "aaaaaaaaaaaaa"
__________________
("num":) 1.879,
("name":) "Be",
("Self":) true
______________
"insertDate": "2023"

I hope I was able to explain the task well.
I trieded to resolve the problem with the switch-node or function node but unfortunately I havn't positive results...
Some one can help me to resolve the problem?

Thanks in advance!

E1cid · 5 June 2023 22:23

Input example has a couple of errors, for json format need to remove the extra commas.

Output is very vague. Do you want that exact string output or some form of object?

Maybe a better output example will help reduce the guessing.

EL_tech · 6 June 2023 18:22

Hello @E1cid ,
Thank you for your helpfulness.
Sorry for the confision of the input json file. I forget to cancel some commas when I preparied a excpert of the input json file.
Here the correct file (valid json):

{
	"success": true,
	"center": {
		"lot": 88,
		"lng": 99
	},
	"results": [{
			"id": 8524,
			"name": "Kkkk",
			"fuels": [{
					"id": 514,
					"num": 1.871,
					"name": "Be",
					"fID": 1,
					"Self": false
				},
				{
					"id": 589,
					"num": 1.879,
					"name": "Be",
					"fID": 1,
					"Self": true
				},
				{
					"id": 687,
					"num": 1.719,
					"name": "G",
					"fID": 2,
					"Self": false
				}
			],
			"location": {
				"lot": 1587,
				"lng": 1474
			},
			"insertDate": "2023",
			"address": "test",
			"tk": "hello"
		},
		{
			"id": 24864,
			"name": "aaaaaaaaaaaaa",
			"fuels": [{
					"id": 51455,
					"num": 1.879,
					"name": "Be",
					"fID": 1,
					"Self": true
				},
				{
					"id": 9841,
					"num": 1.719,
					"name": "Ga",
					"fID": 2,
					"Self": true
				}
			],
			"location": {
				"lot": 47,
				"lng": 45
			},
			"insertDate": "2023",
			"address": "hgjnn",
			"tk": "test"
		}
	]
}

Now I would like to filter the json file.
I would like to filter all elements from the objects for example name: "kkkk" and name": "aaaaaaaaaaaaa" (the names are only examples and therfore are variable) that contains for example the name:"Be" (where is the name:Be the fID is 1). The structur from the json file is allways the same.
For example the result/content of af a filter request what I would like:

Kkkk: (from source "name")
+++++++++++
1.871 (from source "num")
Be (from source "name")
false (from source "Self")
°°°°°°°°°°°°°°°°°°
1.879 (from source "num")
Be (from source "name")
true (from source "Self")
+++++++++++
2023 (from source "insertDate")

/////////////////////////////////////////////////////////////////////////////

aaaaaaaaaaaaa: (from source "name")
+++++++++++
1.879 (from source "num")
Be (from source "name")
true (from source "Self")
+++++++++++
2023 (from source "insertDate")

the conent in the braket are only information to explain more detailed the source of the filterinformation.

I hope I was able to explain the task well.
Thanks in advance.

E1cid · 6 June 2023 18:43

Try this It's fairly close , due to template limitations. Will let you work on it

[{"id":"d68df420c3c419a9","type":"inject","z":"b9860b4b9de8c8da","name":"","props":[{"p":"payload"},{"p":"name","v":"Be","vt":"str"},{"p":"fID","v":"1","vt":"num"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"success\":true,\"center\":{\"lot\":88,\"lng\":99},\"results\":[{\"id\":8524,\"name\":\"Kkkk\",\"fuels\":[{\"id\":514,\"num\":1.871,\"name\":\"Be\",\"fID\":1,\"Self\":false},{\"id\":589,\"num\":1.879,\"name\":\"Be\",\"fID\":1,\"Self\":true},{\"id\":687,\"num\":1.719,\"name\":\"G\",\"fID\":2,\"Self\":false}],\"location\":{\"lot\":1587,\"lng\":1474},\"insertDate\":\"2023\",\"address\":\"test\",\"tk\":\"hello\"},{\"id\":24864,\"name\":\"aaaaaaaaaaaaa\",\"fuels\":[{\"id\":51455,\"num\":1.879,\"name\":\"Be\",\"fID\":1,\"Self\":true},{\"id\":9841,\"num\":1.719,\"name\":\"Ga\",\"fID\":2,\"Self\":true}],\"location\":{\"lot\":47,\"lng\":45},\"insertDate\":\"2023\",\"address\":\"hgjnn\",\"tk\":\"test\"}]}","payloadType":"json","x":110,"y":3860,"wires":[["c62fd51268123011"]]},{"id":"c62fd51268123011","type":"change","z":"b9860b4b9de8c8da","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"($$.payload.results{\t   $.name: {\t       \"name\": $.name,\t       \"fuels\": [$.fuels[$.fID = $$.fID and $.name = $$.name]],\t       \"insertDate\":$.insertDate\t   }\t}).*","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":280,"y":3860,"wires":[["c5ec8cb9fb1e5dee"]]},{"id":"c5ec8cb9fb1e5dee","type":"template","z":"b9860b4b9de8c8da","name":"","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"{{#payload}}\n{{name}}\n+++++++++++\n{{#fuels}}\n{{num}}\n{{name}}\n{{Self}}\n°°°°°°°°°°°°°°°°°°\n{{/fuels}}\n{{insertDate}}\n///////////////////////\n{{/payload}}\n","output":"str","x":480,"y":3860,"wires":[["0ceb4c62b14375c6"]]},{"id":"0ceb4c62b14375c6","type":"debug","z":"b9860b4b9de8c8da","name":"debug 199","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":670,"y":3860,"wires":[]}]

Output

Kkkk
+++++++++++
1.871
Be
false
°°°°°°°°°°°°°°°°°°
1.879
Be
true
°°°°°°°°°°°°°°°°°°
2023
///////////////////////
aaaaaaaaaaaaa
+++++++++++
1.879
Be
true
°°°°°°°°°°°°°°°°°°
2023
///////////////////////

[edit] fix fID input.

EL_tech · 6 June 2023 19:26

Hello @E1cid,
Thank you verry much for your support and the code.
I will try your nodes calmly in the next days and I give you a feedback.

EL_tech · 7 June 2023 19:18

Hlle @E1cid ,
Thank you for your code, too.
It works with the example json file!
Do you know where can I find good informationen for this topics like set msg.payload, format template,... to learn it and to delve your code?

Question:
I get the json data with a request like this example: [Set a request header : Node-RED](https://Set a request header)
Do you know how i have do modify your inject node that it works? :thinking

Thanks in advance.

E1cid · 7 June 2023 19:28

Jsonata documentaion is here
Mustache used in template is here ( the mustache i used in new example is two none empty lists nested, followed by an inverted selection)

Using a http request node i would have thought you just replace the inject node/s, and set it to output a parsed json. If that does not work show us a debug of http request nodes output.

p.s. This version may work better, added handling no result from search

[{"id":"d68df420c3c419a9","type":"inject","z":"b9860b4b9de8c8da","name":"","props":[{"p":"payload"},{"p":"name","v":"Be","vt":"str"},{"p":"fID","v":"12","vt":"num"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"success\":true,\"center\":{\"lot\":88,\"lng\":99},\"results\":[{\"id\":8524,\"name\":\"Kkkk\",\"fuels\":[{\"id\":514,\"num\":1.871,\"name\":\"Be\",\"fID\":1,\"Self\":false},{\"id\":589,\"num\":1.879,\"name\":\"Be\",\"fID\":1,\"Self\":true},{\"id\":687,\"num\":1.719,\"name\":\"G\",\"fID\":2,\"Self\":false}],\"location\":{\"lot\":1587,\"lng\":1474},\"insertDate\":\"2023\",\"address\":\"test\",\"tk\":\"hello\"},{\"id\":24864,\"name\":\"aaaaaaaaaaaaa\",\"fuels\":[{\"id\":51455,\"num\":1.879,\"name\":\"Be\",\"fID\":1,\"Self\":true},{\"id\":9841,\"num\":1.719,\"name\":\"Ga\",\"fID\":2,\"Self\":true}],\"location\":{\"lot\":47,\"lng\":45},\"insertDate\":\"2023\",\"address\":\"hgjnn\",\"tk\":\"test\"}]}","payloadType":"json","x":110,"y":3860,"wires":[["c62fd51268123011"]]},{"id":"c62fd51268123011","type":"change","z":"b9860b4b9de8c8da","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"($$.payload.results{\t   $.name: {\t       \"name\": $.name,\t       \"fuels\": [$.fuels[$.fID = $$.fID and $.name = $$.name]],\t       \"insertDate\":$.insertDate\t   }\t}).*[$exists($.fuels[0])]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":280,"y":3860,"wires":[["c5ec8cb9fb1e5dee"]]},{"id":"ffe6a8fb97615df4","type":"inject","z":"b9860b4b9de8c8da","name":"","props":[{"p":"payload"},{"p":"name","v":"Be","vt":"str"},{"p":"fID","v":"1","vt":"num"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"success\":true,\"center\":{\"lot\":88,\"lng\":99},\"results\":[{\"id\":8524,\"name\":\"Kkkk\",\"fuels\":[{\"id\":514,\"num\":1.871,\"name\":\"Be\",\"fID\":1,\"Self\":false},{\"id\":589,\"num\":1.879,\"name\":\"Be\",\"fID\":1,\"Self\":true},{\"id\":687,\"num\":1.719,\"name\":\"G\",\"fID\":2,\"Self\":false}],\"location\":{\"lot\":1587,\"lng\":1474},\"insertDate\":\"2023\",\"address\":\"test\",\"tk\":\"hello\"},{\"id\":24864,\"name\":\"aaaaaaaaaaaaa\",\"fuels\":[{\"id\":51455,\"num\":1.879,\"name\":\"Be\",\"fID\":1,\"Self\":true},{\"id\":9841,\"num\":1.719,\"name\":\"Ga\",\"fID\":2,\"Self\":true}],\"location\":{\"lot\":47,\"lng\":45},\"insertDate\":\"2023\",\"address\":\"hgjnn\",\"tk\":\"test\"}]}","payloadType":"json","x":110,"y":3920,"wires":[["c62fd51268123011"]]},{"id":"c5ec8cb9fb1e5dee","type":"template","z":"b9860b4b9de8c8da","name":"","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"{{#payload}}\n{{name}}\n-------------\n{{#fuels}}\n{{num}}\n{{name}}\n{{Self}}\n-------------\n{{/fuels}}\n{{insertDate}}\n______________\n\n{{/payload}}\n{{^payload}}No Result for\nname: {{name}}\nfID: {{fID}}{{/payload}}","output":"str","x":480,"y":3860,"wires":[["0ceb4c62b14375c6"]]},{"id":"0ceb4c62b14375c6","type":"debug","z":"b9860b4b9de8c8da","name":"debug 199","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":670,"y":3860,"wires":[]}]

EL_tech · 12 June 2023 18:00

Hello @E1cid ,
Sorry for the late response.
Thank you for your nice version. It works and I like it!

I connected a debug node to the output of the post to HttpBin and I get a response.
When I connect your nodeexample to my request header i get allways the message "No Result for name fueled.
I connected the post to HttpBin (return a parsed JSON object) to your set.msg.payload. The inject nodes I cancelled.
Question: Where I get the request for the msg.name = Be and msg.fuelId?

E1cid · 12 June 2023 18:48

With out all the info all i can do is guess.
You set msg.fID to the fID in the message before the change node, to the fID you are after, e.g. 1 make sure it is a number not a string. You set msg.name to the name you wish to search fo "Be".

EL_tech · 12 June 2023 19:10

Hello @E1cid,
sorry for the confusion.
I show you my code. Maybe it is more understandable.

[{"id":"28957e037055f9ad","type":"function","z":"67e5e39e7b6a8e54","name":"set payload and headers","func":"msg.headers = {};\nmsg.headers = {\n};\n\n\nmsg.payload = {};\nmsg.payload = {\n    'region' : 9,\n    'province': 'RM',\n    'town' : 'Monterotondo',\n    'priceOrder':'desc', \n    'fuelType': '1-1',\n    'refuelingMode': 1\n};\n\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":330,"y":3640,"wires":[["032934fb12b24bb2"]]},{"id":"cf770b6810ef06f2","type":"inject","z":"67e5e39e7b6a8e54","name":"","repeat":"","crontab":"","once":false,"topic":"","payload":"","payloadType":"date","x":140,"y":3640,"wires":[["28957e037055f9ad"]]},{"id":"032934fb12b24bb2","type":"http request","z":"67e5e39e7b6a8e54","name":"post to HttpBin","method":"POST","ret":"obj","paytoqs":"ignore","url":"https://carburanti.mise.gov.it/ospzApi/search/area","tls":"","persist":false,"proxy":"","insecureHTTPParser":false,"authType":"","senderr":false,"headers":[],"credentials":{},"x":540,"y":3640,"wires":[["abee4808abae2642","c62fd51268123011"]]},{"id":"d68df420c3c419a9","type":"inject","z":"67e5e39e7b6a8e54","name":"","props":[{"p":"payload"},{"p":"name","v":"Be","vt":"str"},{"p":"fuelId","v":"12","vt":"num"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"success\":true,\"center\":{\"lat\":88,\"lng\":99},\"results\":[{\"id\":8524,\"name\":\"Kkkk\",\"fuels\":[{\"id\":514,\"price\":1.871,\"name\":\"Be\",\"fuelId\":1,\"isSelf\":false},{\"id\":589,\"price\":1.879,\"name\":\"Be\",\"fuelId\":1,\"isSelf\":true},{\"id\":687,\"price\":1.719,\"name\":\"G\",\"fuelId\":2,\"isSelf\":false}],\"location\":{\"lat\":1587,\"lng\":1474},\"insertDate\":\"2023\",\"address\":\"test\",\"tk\":\"hello\"},{\"id\":24864,\"name\":\"aaaaaaaaaaaaa\",\"fuels\":[{\"id\":51455,\"price\":1.879,\"name\":\"Be\",\"fuelId\":1,\"isSelf\":true},{\"id\":9841,\"price\":1.719,\"name\":\"Ga\",\"fuelId\":2,\"isSelf\":true}],\"location\":{\"lat\":47,\"lng\":45},\"insertDate\":\"2023\",\"address\":\"hgjnn\",\"tk\":\"test\"}]}","payloadType":"json","x":170,"y":3760,"wires":[["c62fd51268123011"]]},{"id":"c62fd51268123011","type":"change","z":"67e5e39e7b6a8e54","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"($$.payload.results{\t   $.name: {\t       \"name\": $.name,\t       \"fuels\": [$.fuels[$.fuelId = $$.fuelId and $.name = $$.name]],\t       \"insertDate\":$.insertDate\t   }\t}).*[$exists($.fuels[0])]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":360,"y":3760,"wires":[["c5ec8cb9fb1e5dee","525d43e58e968f9b"]]},{"id":"c5ec8cb9fb1e5dee","type":"template","z":"67e5e39e7b6a8e54","name":"","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"{{#payload}}\nName company: {{name}}\n-------------\n{{#fuels}}\nprice: {{price}}\nfuel: {{name}}\nisSelf: {{isSelf}}\n-------------\n{{/fuels}}\nDate and time: {{insertDate}}\n______________\n\n{{/payload}}\n{{^payload}}No Result for\nname: {{name}}\nfuelId: {{fuelId}}{{/payload}}","output":"str","x":560,"y":3760,"wires":[["0ceb4c62b14375c6"]]},{"id":"0ceb4c62b14375c6","type":"debug","z":"67e5e39e7b6a8e54","name":"debug 199","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":750,"y":3760,"wires":[]},{"id":"abee4808abae2642","type":"debug","z":"67e5e39e7b6a8e54","name":"debug 201","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":810,"y":3640,"wires":[]},{"id":"7df991ec4a32e86d","type":"inject","z":"67e5e39e7b6a8e54","name":"","props":[{"p":"payload"},{"p":"name","v":"Be","vt":"str"},{"p":"fuelId","v":"1","vt":"num"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"success\":true,\"center\":{\"lat\":88,\"lng\":99},\"results\":[{\"id\":8524,\"name\":\"Kkkk\",\"fuels\":[{\"id\":514,\"price\":1.871,\"name\":\"Be\",\"fuelId\":1,\"isSelf\":false},{\"id\":589,\"price\":1.879,\"name\":\"Be\",\"fuelId\":1,\"isSelf\":true},{\"id\":687,\"price\":1.719,\"name\":\"G\",\"fuelId\":2,\"isSelf\":false}],\"location\":{\"lat\":1587,\"lng\":1474},\"insertDate\":\"2023\",\"address\":\"test\",\"tk\":\"hello\"},{\"id\":24864,\"name\":\"aaaaaaaaaaaaa\",\"fuels\":[{\"id\":51455,\"price\":1.879,\"name\":\"Be\",\"fuelId\":1,\"isSelf\":true},{\"id\":9841,\"price\":1.719,\"name\":\"Ga\",\"fuelId\":2,\"isSelf\":true}],\"location\":{\"lat\":47,\"lng\":45},\"insertDate\":\"2023\",\"address\":\"hgjnn\",\"tk\":\"test\"}]}","payloadType":"json","x":170,"y":3840,"wires":[["c62fd51268123011","04979bd3d7004a7b"]]},{"id":"525d43e58e968f9b","type":"debug","z":"67e5e39e7b6a8e54","name":"debug 203","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":610,"y":3840,"wires":[]},{"id":"04979bd3d7004a7b","type":"debug","z":"67e5e39e7b6a8e54","name":"debug 204","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":370,"y":3840,"wires":[]}]

The example data in the inject nodes are a little different from the http request data.
I used them only for different tests.

E1cid · 12 June 2023 20:26

You switched form fID in OG post to fuelId,. You should have notified use of this fact

I am still awaiting a debug of http request node, i have asked three times now. I try to help but when i ask for info you ignore my request, and offer something I did not ask for.

You still had cross over for changing the fID and typo's due to this.

As said in last post add the name and fuelId in a change node before the JSONata expression.

The http return does not contain any name's "Be".

This should work when name is "Be" and fuelId id 1, set in change node.

[{"id":"e6926a4555f50a3e","type":"inject","z":"b9860b4b9de8c8da","name":"","repeat":"","crontab":"","once":false,"topic":"","payload":"","payloadType":"date","x":100,"y":4020,"wires":[["d00f26c8017f46e9"]]},{"id":"d00f26c8017f46e9","type":"function","z":"b9860b4b9de8c8da","name":"set payload and headers","func":"msg.headers = {};\nmsg.headers = {\n};\n\n\nmsg.payload = {};\nmsg.payload = {\n    'region' : 9,\n    'province': 'RM',\n    'town' : 'Monterotondo',\n    'priceOrder':'desc', \n    'fuelType': '1-1',\n    'refuelingMode': 1\n};\n\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":290,"y":4020,"wires":[["1d8bb51c38acb99a"]]},{"id":"1d8bb51c38acb99a","type":"http request","z":"b9860b4b9de8c8da","name":"post to HttpBin","method":"POST","ret":"obj","paytoqs":"ignore","url":"https://carburanti.mise.gov.it/ospzApi/search/area","tls":"","persist":false,"proxy":"","insecureHTTPParser":false,"authType":"","senderr":false,"headers":[],"x":500,"y":4020,"wires":[["0a4e9c551c73218d","89f87e77215f7336"]]},{"id":"0a4e9c551c73218d","type":"debug","z":"b9860b4b9de8c8da","name":"debug 201","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":690,"y":4000,"wires":[]},{"id":"89f87e77215f7336","type":"change","z":"b9860b4b9de8c8da","name":"","rules":[{"t":"set","p":"fuelId","pt":"msg","to":"1","tot":"num"},{"t":"set","p":"name","pt":"msg","to":"Be","tot":"str"},{"t":"set","p":"payload","pt":"msg","to":"($$.payload.results{\t   $.name: {\t       \"name\": $.name,\t       \"fuels\": [$.fuels[$.fuelId = $$.fuelId and $.name = $$.name]],\t       \"insertDate\":$.insertDate\t   }\t}).*[$exists($.fuels[0])]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":320,"y":4140,"wires":[["be1bf5946d6e9650","c6137e1d72f2da72"]]},{"id":"8794ef747eeeb81b","type":"inject","z":"b9860b4b9de8c8da","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"success\":true,\"center\":{\"lat\":88,\"lng\":99},\"results\":[{\"id\":8524,\"name\":\"Kkkk\",\"fuels\":[{\"id\":514,\"price\":1.871,\"name\":\"Be\",\"fuelId\":1,\"isSelf\":false},{\"id\":589,\"price\":1.879,\"name\":\"Be\",\"fuelId\":1,\"isSelf\":true},{\"id\":687,\"price\":1.719,\"name\":\"G\",\"fuelId\":2,\"isSelf\":false}],\"location\":{\"lat\":1587,\"lng\":1474},\"insertDate\":\"2023\",\"address\":\"test\",\"tk\":\"hello\"},{\"id\":24864,\"name\":\"aaaaaaaaaaaaa\",\"fuels\":[{\"id\":51455,\"price\":1.879,\"name\":\"Be\",\"fuelId\":1,\"isSelf\":true},{\"id\":9841,\"price\":1.719,\"name\":\"Ga\",\"fuelId\":2,\"isSelf\":true}],\"location\":{\"lat\":47,\"lng\":45},\"insertDate\":\"2023\",\"address\":\"hgjnn\",\"tk\":\"test\"}]}","payloadType":"json","x":130,"y":4140,"wires":[["89f87e77215f7336"]]},{"id":"be1bf5946d6e9650","type":"template","z":"b9860b4b9de8c8da","name":"","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"{{#payload}}\nName company: {{name}}\n-------------\n{{#fuels}}\nprice: {{price}}\nfuel: {{name}}\nisSelf: {{isSelf}}\n-------------\n{{/fuels}}\nDate and time: {{insertDate}}\n______________\n\n{{/payload}}\n{{^payload}}No Result for\nname: {{name}}\nfuelId: {{fuelId}}{{/payload}}","output":"str","x":520,"y":4140,"wires":[["89cad60e79bf2836"]]},{"id":"c6137e1d72f2da72","type":"debug","z":"b9860b4b9de8c8da","name":"debug 203","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":570,"y":4220,"wires":[]},{"id":"89cad60e79bf2836","type":"debug","z":"b9860b4b9de8c8da","name":"debug 199","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":710,"y":4140,"wires":[]}]

EL_tech · 12 June 2023 20:46

Hi @E1cid ,
sorry for the confusion.
In the example of the json data I used for example the word "Be " instead the whole word.
I'm a newbie with Nodered and so I have some understanding problems.
So, now I will look your Programm and try to understand. Especially the change node how it works like a filter.
Thank you for your helpfulness and your great patience!

system · 26 June 2023 20:47

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
JSON Array Filtering - Function Node General	4	2494	17 May 2021
Filter only some fields in a json General	6	106	8 March 2024
JSON Filtering Question General	3	3034	16 September 2018
Help to filter data General	4	1328	17 February 2021
JSONata $filter General	2	175	30 June 2023

Filter json database with conditions

Related topics