using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using System.Data;

using System.Globalization;

using System.Reflection;

​

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/72337900/c-newtonsoft-need-to-get-array-items-not-already-handled

​

    class TestClass

    {

        public static void Test()

        {

                    JObject json = JObject.Parse(GetJson());

​

        string[] tableNames = {"TableStart:equipment:defectNow:Filter:defect_type=DN","TableStart:equipment:defectFuture:Filter:defect_type=DF","TableStart:equipment:defectNone"};

            List<JObject> test = new List<JObject>();

        for (int j = 0; j <= 2; j++)

        {

            // Note, some table name parts won't have the "Filter..." aspect

            // the string below will change depending on which loop we are in.

            string[] tableNameParts = tableNames[j].Split(':');

​

            string tableNameJson = tableNameParts[1].Replace("»", "");

​

            var jsonRows = json[tableNameJson];

​

            if (tableNameParts.Count() > 3)

            {

                // We probably have a filter set.

​

                if (tableNameParts[3].Replace("»", "").ToLower() == "filter" && tableNameParts.Count() > 4)

                {

                    // These values are not set in stone. It is what values have been set in the JSON, and then matched.

                    // for example... TableStart:<subform name>:<differentiator>:Filter:<field name>=<field value>

​

                    string[] FilterParts = tableNameParts[4].Split('=');

                    // Get the filter field and value to filter by

​

                    if (FilterParts.Count() > 1)

                    {

                        string FilterField = FilterParts[0].Replace("»", "");

                        string FilterValue = FilterParts[1].Replace("»", "");

​

                        JArray filteredArray = new JArray();

​

                        if (jsonRows[0].GetType() == typeof(JObject))

                        {

​

                            foreach (JObject arrayObject in jsonRows) // Each group can have a set of arrays. (each  record has multiple sub records)

                            {

​

                                foreach (var objectItem in arrayObject)

                                {

                                    string objectItemValue = string.Empty;

​

                                    if (objectItem.Value.GetType() == typeof(JArray))

                                    {

                                        foreach (var item in objectItem.Value)

                                        {

                                            objectItemValue += item;

                                        }

                                    }

                                    else

                                    {

                                        objectItemValue = (string)objectItem.Value;

                                    }

​

                                    if (objectItem.Key == FilterField && objectItemValue == FilterValue)

                                    {

                                        // We need to save the item.

                                        filteredArray.Add(arrayObject);

                                        test.Add(arrayObject);

                                    }

​

                                }

                            }

                        }

                        else

                        {

                            foreach (JArray arrayGroup in jsonRows) // The array group (e.g. fault_record_subform)

                            {

                                // We are looking through the json array, to find any rows that match our filter key and filter value.

                                // We will then add that into our jsonRows

​

                                foreach (JObject arrayObject in arrayGroup) // Each group can have a set of arrays. (each  record has multiple sub records)

                                {

​

                                    foreach (var objectItem in arrayObject)

                                    {

                                        string objectItemValue = string.Empty;

​

                                        if (objectItem.Value.GetType() == typeof(JArray))

                                        {

                                            foreach (var item in objectItem.Value)

                                            {

                                                objectItemValue += item;

                                            }

                                        }

                                        else

                                        {

                                            objectItemValue = (string)objectItem.Value;

                                        }

​

                                        if (objectItem.Key == FilterField && objectItemValue == FilterValue)

                                        {

                                            // We need to save the item.

                                            filteredArray.Add(arrayObject);

                                            test.Add(arrayObject);

                                        }

​

                                    }

                                }

                            }

                        }

​

​

                        jsonRows = filteredArray;   // limit the jsonRows to the filtered set (overwrite the jsonRows)

​

                    }

                }

​

            }

            else

            {

                // This is not a filter set

                JArray singleArray = new JArray();

​

                foreach(var arraySet in jsonRows)

                {

                    if (!test.Contains(arraySet))

                    {

                        if (arraySet.GetType() == typeof(JObject))

                        {

                            singleArray.Add(arraySet);

                        }

                        else

                        {

                            foreach (JObject arrayObject in arraySet)

                            {

                                singleArray.Add(arrayObject);

                            }

                        }

                    }

                }

​

                jsonRows = singleArray;

            }

            Console.WriteLine("");Console.WriteLine("");Console.WriteLine("");

            Console.WriteLine(tableNameParts[2]);

            Console.Write(jsonRows);

        }         

        }   

        static string GetJson() => @"  {

    ""equipment"": [{

        ""date_of_examination"": ""2022-05-20T14:08:38.072965"",

        ""defect_type"": [""DN""],

        ""eqpt_ref"": ""AA1"",

        ""eqpt_name"": [""2 Leg Chain Sling""],

        ""eqpt_manufacturer"": ""Merc"",

        ""eqpt_model"": ""edes"",

        ""part_no"": ""A1"",

        ""serial_no"": ""A1"",

        ""year"": ""2019"",

        ""swl"": ""32 tons"",

        ""exam_type"": [""6 Months""],

        ""date_of_last_examination"": ""2021-11-20T00:00:00"",

        ""date_of_next_examination"": ""2022-11-20T00:00:00"",

        ""defect"": ""sling is torn"",

        ""action_required"": ""replace""

    }, {

        ""date_of_examination"": ""2022-05-20T14:12:23.997004"",

        ""eqpt_ref"": ""AA2"",

        ""eqpt_name"": [""Other - ""],

        ""eqpt_name_other"": ""widget"",

        ""eqpt_manufacturer"": ""merc"",

        ""eqpt_model"": ""edes"",

        ""part_no"": ""B1"",

        ""serial_no"": ""B1"",

        ""year"": ""2019"",

        ""swl"": ""32 tons"",

        ""exam_type"": [""6 Months""]

    }, {

        ""date_of_examination"": ""2022-05-20T14:13:24.795136"",

        ""defect_type"": [""DF""],

        ""eqpt_ref"": ""CC1"",

        ""eqpt_name"": [""Endless Round Sling (2.5m)""],

        ""eqpt_manufacturer"": ""merc"",

        ""eqpt_model"": ""edes"",

        ""part_no"": ""c1"",

        ""serial_no"": ""c1"",

        ""year"": ""2019"",

        ""swl"": ""42 tons"",

        ""exam_type"": [""6 Months""],

        ""defect"": ""stitching is coming undone"",

        ""danger_value"": ""6"",

        ""danger_units"": [""Weeks""],

        ""action_required"": ""needs to be stitched again""

    }]

}

";

    }

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Environment version: {0} ({1})", System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription , Environment.Version);

            Console.WriteLine("{0} version: {1}", typeof(JsonSerializer).Assembly.GetName().Name,  typeof(JsonSerializer).Assembly.FullName);

            Console.WriteLine();

​

            try

            {

                TestClass.Test();

            }

            catch (Exception ex)

            {

                Console.WriteLine("Failed with unhandled exception: ");

                Console.WriteLine(ex);

                throw;

            }

        }

    }

​