using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Runtime.Serialization.Formatters;

using System.IO;

using System.Data;

​

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using Newtonsoft.Json.Converters;

using Newtonsoft.Json.Serialization;    

​

// https://stackoverflow.com/questions/45297883/json-net-jsonpath-query-not-returning-expected-results

    class TestClass

    {

        public static void Test()

        {

            var json = JToken.Parse(GetJson());

​

            var path = @"$.projects[?(@.client.code == 'DEF')].client";

            var test = json.SelectTokens(path);

​

            Console.WriteLine("Path = \"{0}\", result: ", path);

            Console.WriteLine(JsonConvert.SerializeObject(test, Formatting.Indented));

            var path1 = "$.projects[*].client";

            var clients = json.SelectTokens(path1);

​

            Console.WriteLine("Path = \"{0}\", result: ", path1);

            Console.WriteLine(JsonConvert.SerializeObject(clients, Formatting.Indented));

        }

​

        static string GetJson()

        {

            var json = @"{  

   ""projects"":[  

      {  

         ""name"":""Project 1"",

         ""client"":{  

            ""code"":""ABC"",

            ""name"":""Client 1""

         }

      },

      {  

         ""name"":""Project 2"",

         ""client"":{  

            ""code"":""DEF"",

            ""name"":""Client 2""

         }

      },

      {  

         ""name"":""Project 3"",

         ""client"":{  

            ""code"":""GHI"",

            ""name"":""Client 3""

         }

      },

      {  

         ""name"":""Null Project"",

      }

   ]

}";

            return json;

        }

    }

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Environment version: " + Environment.Version);

            Console.WriteLine("Json.NET version: " + typeof(JsonSerializer).Assembly.FullName);

            Console.WriteLine();

​

            try

            {

                TestClass.Test();

            }

            catch (Exception ex)

            {

                Console.WriteLine(ex);

                throw;

            }

        }

    }

​