[Fork] https://stackoverflow.com/questions/76853483/are-nested-filters-supported-by-newtonsoft-in-jsonpath-expressions | C# Online Compiler

[Fork] https://stackoverflow.com/questions/76853483/are-nested-filters-supported-by-newtonsoft-in-jsonpath-expressions by dbc_MinLength

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Newtonsoft.Json.Converters;
using Newtonsoft.Json.Serialization;	

using NUnit.Framework; // Throws NUnit.Framework.AssertionException

//https://stackoverflow.com/questions/76853483/are-nested-filters-supported-by-newtonsoft-in-jsonpath-expressions

    class TestClass
    {
        public static void Test()
        {
			var jtokenRoot = JToken.Parse(GetJson());
			
			var titles = jtokenRoot
				.SelectTokens("store.book[?(@.authors[?(@.lastName =~ /^(?i)[\\s]*waugh[\\s]*$/)])].title")
				.ToList();
						
			Console.WriteLine(JsonConvert.SerializeObject(titles, Formatting.Indented));
		}	
		
		static string GetJson() =>
			"""
			{
				"store": {
					"book": [
						{
							"category": "reference",
							"authors": [
								{
									"firstName": "Nigel",
									"lastName": "Rees"
								},
								{
									"firstName": "Evelyn",
									"lastName": "   Waugh   "
								}
							],
							"title": "Sayings of the Century",
							"price": 8.95
						},
						{
							"category": "fiction",
							"authors": [
								{
									"firstName": "Herman",
									"lastName": "Melville"
								},
								{
									"firstName": "Somebody",
									"lastName": "Else"
								}
							],
							"title": "Moby Dick",
							"isbn": "0-553-21311-3",
							"price": 8.99
						},
						{
							"category": "fiction",
							"authors": [
								{
									"firstName": "Evelyn",
									"lastName": "WAUGH"
								},
								{
									"firstName": "Nigel",
									"lastName": "Rees"
								}
							],
							"title": "Sword of Honour",
							"price": 12.99
						},
						{
							"category": "fiction",
							"authors": [
								{
									"firstName": "J. R. R.",
									"lastName": "WaughTolkien"
								}
							],
							"title": "The Lord of the Rings",
							"isbn": "0-395-19395-8",
							"price": 22.99
						}
					],
					"bicycle": {
						"color": "red",
						"price": 19.95
					}
				},
				"expensive": 10
			}
			
			""";
	}

	public class Program
	{
		public static void Main()
		{
			Console.WriteLine("Environment version: {0} ({1}), {2}", System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription , Environment.Version, Environment.OSVersion);
			Console.WriteLine("{0} version: {1}", typeof(JsonSerializer).Namespace, typeof(JsonSerializer).Assembly.FullName);
			Console.WriteLine();

			try
			{
				TestClass.Test();
			}
			catch (Exception ex)
			{
				Console.WriteLine("Failed with unhandled exception: ");
				Console.WriteLine(ex);
				throw;
			}
		}
	}

​x
 
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
​
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Newtonsoft.Json.Converters;
using Newtonsoft.Json.Serialization;    
​
using NUnit.Framework; // Throws NUnit.Framework.AssertionException
​
//https://stackoverflow.com/questions/76853483/are-nested-filters-supported-by-newtonsoft-in-jsonpath-expressions
​
    class TestClass
    {
        public static void Test()
        {
            var jtokenRoot = JToken.Parse(GetJson());
            
            var titles = jtokenRoot
                .SelectTokens("store.book[?(@.authors[?(@.lastName =~ /^(?i)[\\s]*waugh[\\s]*$/)])].title")
                .ToList();
                        
            Console.WriteLine(JsonConvert.SerializeObject(titles, Formatting.Indented));
        }   
        
        static string GetJson() =>
            """
            {
                "store": {
                    "book": [
                        {
                            "category": "reference",
                            "authors": [
                                {
                                    "firstName": "Nigel",
                                    "lastName": "Rees"
                                },
                                {
                                    "firstName": "Evelyn",
                                    "lastName": "   Waugh   "
                                }
                            ],
                            "title": "Sayings of the Century",
                            "price": 8.95
                        },
                        {
                            "category": "fiction",
                            "authors": [
                                {
                                    "firstName": "Herman",
                                    "lastName": "Melville"
                                },
                                {
                                    "firstName": "Somebody",
                                    "lastName": "Else"
                                }
                            ],
                            "title": "Moby Dick",
                            "isbn": "0-553-21311-3",
                            "price": 8.99
                        },
                        {
                            "category": "fiction",
                            "authors": [
                                {
                                    "firstName": "Evelyn",
                                    "lastName": "WAUGH"
                                },
                                {
                                    "firstName": "Nigel",
                                    "lastName": "Rees"
                                }
                            ],
                            "title": "Sword of Honour",
                            "price": 12.99
                        },
                        {
                            "category": "fiction",
                            "authors": [
                                {
                                    "firstName": "J. R. R.",
                                    "lastName": "WaughTolkien"
                                }
                            ],
                            "title": "The Lord of the Rings",
                            "isbn": "0-395-19395-8",
                            "price": 22.99
                        }
                    ],
                    "bicycle": {
                        "color": "red",
                        "price": 19.95
                    }
                },
                "expensive": 10
            }
            
            """;
    }
​
    public class Program
    {
        public static void Main()
        {
            Console.WriteLine("Environment version: {0} ({1}), {2}", System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription , Environment.Version, Environment.OSVersion);
            Console.WriteLine("{0} version: {1}", typeof(JsonSerializer).Namespace, typeof(JsonSerializer).Assembly.FullName);
            Console.WriteLine();
​
            try
            {
                TestClass.Test();
            }
            catch (Exception ex)
            {
                Console.WriteLine("Failed with unhandled exception: ");
                Console.WriteLine(ex);
                throw;
            }
        }
    }
​

Kontrola:
Drak ma 100 zivotu? True

Hrdina zabil draka.
Kontrola:
Drak nema zadny zivot? True
Bylo odehrano presne 20 kol? True

Last Run:	12:55:03 pm
Compile:	0.172s
Execute:	0.016s
Memory:	8kb
CPU:	0.016s

View IL Code