multi filter to apply only two columns Field1 and Field2

RAVI 1,056

Hello This is my code

<html xmlns="http://www.w3.org/1999/xhtml"> <head> <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script> <link href="https://nightly.datatables.net/css/jquery.dataTables.css" rel="stylesheet" type="text/css" /> <script src="https://nightly.datatables.net/js/jquery.dataTables.js"></script> <!-- Select2 plugin --> <link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/css/select2.min.css"/> <!-- Select2 plugin --> <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/js/select2.min.js"></script> <meta charset="utf-8" /> <title>DataTables - JS Bin</title> <script> $(document).ready(function () { var table = $('#list').DataTable({ initComplete: function () { count = 0; this.api().columns().every(function () { var title = this.header(); //replace spaces with dashes title = $(title).html().replace(/[\W]/g, '-'); var column = this; var select = $('<select id="' + title + '" class="select2" style="width:100%;" ></select>') .appendTo($(column.header()).empty()) .on('change', function () { //Get the "text" property from each selected data //regex escape the value and store in array var data = $.map($(this).select2('data'), function (value, key) { return value.text ? '^' + $.fn.dataTable.util.escapeRegex(value.text) + '$' : null; }); //if no data selected use "" if (data.length === 0) { data = [""]; } //join array into string with regex or (|) var val = data.join('|'); //search for the option(s) selected column .search(val ? val : '', true, false) .draw(); }); column.data().unique().sort().each(function (d, j) { select.append('<option value="' + d + '">' + d + '</option>'); }); //use column title as selector and placeholder $('#' + title).select2({ multiple: true, closeOnSelect: false, placeholder: "Select a " + title }); //initially clear select otherwise first option is selected $('.select2').val(null).trigger('change'); }); } }); }); </script> <style> table { margin: 0 auto; margin-top: 20px; width: 100%; position: relative; overflow: auto; overflow-y: overlay; } th, thead { position: sticky; top: 0; border: 1px solid #dddddd; background-color: #1f2d54; text-align: center; table-layout: fixed; word-break: break-word; height: 45px; } </style> </head> <body> <div class="container"> <table cellspacing="0" class="myClass" id="list" style="width: 500px; font-family: Calibri; font-size: 11px; border-collapse: collapse; border: 1px solid black;"> <thead> <tr> <th>Field1</th> <th>Field2</th> <th>Field3</th> <th>Field4</th> </tr> </thead> <tbody style="border-collapse: collapse; border: 1px solid black;"> <asp:Repeater ID="Repeater1" runat="server"> <ItemTemplate> <tr> <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field1")%></td> <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field2")%></td> <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field3")%></td> <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field4")%></td> </tr> </ItemTemplate> </asp:Repeater> </tbody> </table> </div> </body> </html>

I want to apply Field1 and Field2 column filter only not for all columns
i want to Field4 total to be shown in footer whenever filter happens the total should be change accordingly Database data like this

   /****** Object: Table [dbo].[Table_1] Script Date: 11/30/2023 18:37:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Table_1]( [ID] [int] IDENTITY(1,1) NOT NULL, [Field1] [varchar](50) NULL, [Field2] [varchar](50) NULL, [Field3] [varchar](50) NULL, [Field4] [float] NULL, CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO SET IDENTITY_INSERT [dbo].[Table_1] ON INSERT [dbo].[Table_1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (1, N'Apple', N'AA', N'BB', 100) INSERT [dbo].[Table_1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (2, N'Mango', N'AA', N'CC', 200) INSERT [dbo].[Table_1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (3, N'Orange', N'CC', N'DD', 50) INSERT [dbo].[Table_1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (4, N'Apple', N'CC', N'KK', 100) INSERT [dbo].[Table_1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (5, N'Mango', N'JJ', N'UP', 10) INSERT [dbo].[Table_1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (6, N'Mango', N'GG', N'EE', 90) INSERT [dbo].[Table_1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (7, N'Apple', N'AA', N'BB', 100) INSERT [dbo].[Table_1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (8, N'Mango', N'AA', N'C', 200) INSERT [dbo].[Table_1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (9, N'Orange', N'CC', N'T', 50) INSERT [dbo].[Table_1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (10, N'Apple', N'CC', N'R', 100) INSERT [dbo].[Table_1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (11, N'Mango', N'JJ', N'R', 10) INSERT [dbo].[Table_1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (12, N'Mango', N'GG', N'T', 90) SET IDENTITY_INSERT [dbo].[Table_1] OFF

Accepted answer

Lan Huang-MSFT 29,251 Microsoft Vendor

Hi @RAVI,

multi filter to apply only two columns Field1 and Field2

Write examples based on your needs for your reference. Only two columns are needed to implement filtering, just define columns([0, 1]).

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
    <script type="text/javascript" src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.min.js"></script>
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.13.7/css/jquery.dataTables.min.css" />
    <script type="text/javascript">
        $(document).ready(function () {
            var rowCount = $('table#list tbody tr').length;
            sessionStorage.setItem("rowCount", rowCount);
            // Remove the formatting to get integer data for summation
            var intVal = function (i) {
                return typeof i === 'string' ?
                    i.replace(/[\$,]/g, '') * 1 :
                    typeof i === 'number' ?
                        i : 0;
            };
            $('#list').DataTable({
                initComplete: function () {
                    this.api().columns([0, 1]).every(function () {
                        var column = this;
                        var colTitle = this.header().innerHTML;
                        var select = $('<select><option value="">' + colTitle + '</option></select>')
                            .appendTo($(column.header()).empty())
                            .on('change', function () {
                                var val = $.fn.dataTable.util.escapeRegex(
                                    $(this).val()
                                );
                                column
                                    .search(val ? '^' + val + '$' : '', true, false)
                                    .draw();
                            });
                        column.data().unique().sort().each(function (d, j) {
                            select.append('<option value="' + d + '">' + d + '</option>')
                        });
                    });
                },
                footerCallback: function (tfoot, data, start, end, display) {
                    let api = this.api();
                    api.column(2).footer().innerHTML = "Grand total";
                    // Total over all pages
                    total = api
                        .column(3, { search: 'applied' })
                        .data()
                        .reduce((a, b) => intVal(a) + intVal(b), 0);
                    // Update footer
                    api.column(3).footer().innerHTML = total;
                }
            });
        });
    </script>
</head>
<body>
    <div class="container">
        <table cellspacing="0" class="myClass" id="list" style="width: 500px; font-family: Calibri; font-size: 11px; border-collapse: collapse; border: 1px solid black;">
            <thead>
                <tr>
                    <th>Field1</th>
                    <th>Field2</th>
                    <th>Field3</th>
                    <th>Field4</th>
                </tr>
            </thead>
            <tbody style="border-collapse: collapse; border: 1px solid black;">
                <asp:Repeater ID="Repeater1" runat="server">
                    <ItemTemplate>
                        <tr>
                            <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field1")%></td>
                            <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field2")%></td>
                            <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field3")%></td>
                            <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field4")%></td>
                        </tr>
                    </ItemTemplate>
                </asp:Repeater>
            </tbody>
            <tfoot>
                <tr>
                    <td></td>
                    <td></td>
                    <td style="border-collapse: collapse; background: sandybrown; border: 1px solid black; font-size: larger; font-weight: bold;"></td>
                    <td style="border-collapse: collapse; background: sandybrown; border: 1px solid black; font-size: larger; font-weight: bold;"></td>
                </tr>
            </tfoot>
        </table>
    </div>
</body>
</html>

User's image

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

RAVI 1,056 Reputation points

2024-02-19T06:42:47.5+00:00

I need multiple filter like excel column filter not single filter Please help

Lan Huang-MSFT 29,251 Microsoft Vendor

Hi @RAVI, I gave you a similar method before, you can change it to the following code. https://learn.microsoft.com/en-us/answers/questions/1360792/multi-select-filter-for-my-gridview

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
    <script type="text/javascript" src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.min.js"></script>
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.13.7/css/jquery.dataTables.min.css" />
    <script type="text/javascript">
        $(document).ready(function () {
            function cbDropdown(column) {
                return $('<ul>', {
                    'class': 'cb-dropdown'
                }).appendTo($('<div>', {
                    'class': 'cb-dropdown-wrap'
                }).appendTo(column));
            }
            var rowCount = $('table#list tbody tr').length;
            sessionStorage.setItem("rowCount", rowCount);
            // Remove the formatting to get integer data for summation
            var intVal = function (i) {
                return typeof i === 'string' ?
                    i.replace(/[\$,]/g, '') * 1 :
                    typeof i === 'number' ?
                        i : 0;
            };
            $('#list').DataTable({
                initComplete: function () {
                    this.api().columns([0, 1]).every(function () {
                        var column = this;
                        var ddmenu = cbDropdown($(column.header()).empty())
                            .on('change', ':checkbox', function () {
                                var active;
                                var vals = $(':checked', ddmenu).map(function (index, element) {
                                    active = true;
                                    return $.fn.dataTable.util.escapeRegex($(element).val());
                                }).toArray().join('|');
                                column
                                    .search(vals.length > 0 ? '^(' + vals + ')$' : '', true, false)
                                    .draw();
                                // -------------------------------------------------------
                                // Highlight the current item if selected.
                                if (this.checked) {
                                   
                                    $(this).closest('li').addClass('active');
                                    // If 'Select all / none' clicked ON
                                    if ($(this).val() === "1") {
                                        $(ddmenu).find('input[type="checkbox"]').prop('checked', this.checked)
                                    }
                                } else // 'Select all / none' clicked OFF
                                {
                                    $(this).closest('li').removeClass('active');
                                    // test if select none
                                    if ($(this).val() === "1") {
                                        // code to untick all
                                        $(ddmenu).find('input[type="checkbox"]').prop('checked', false)
                                    }
                                }
                                // Highlight the current filter if selected.
                                var active2 = ddmenu.parent().is('.active');
                                if (active && !active2) {
                                    ddmenu.parent().addClass('active');
                                    // Change Container title to "Filter on" and green
                                    //$(this).parent().find('.cb-dropdown li:nth-child(n+1)').css('color','red');   
                                    $('active2 li label:contains("Filter OFF")').text('Yeees');
                                } else if (!active && active2) {
                                    ddmenu.parent().removeClass('active');
                                }
                            });
                        // -------------------------------------------------------
                        var mytopcount = '0'; // Counter that ensures only 1 entry per container
                        // loop to assign all options in container filter
                        column.data().unique().sort().each(function (d, j) {
                            // Label
                            var $label = $('<label>'),
                                $text = $('<span>', {
                                    text: d
                                }),
                                // Checkbox
                                $cb = $('<input>', {
                                    type: 'checkbox',
                                    value: d
                                });
                            $text.appendTo($label);
                            $cb.appendTo($label);
                            ddmenu.append($('<li>').append($label));
                            // -----------------
                            // Add 'Select all / none' to each dropdown container
                            if (mytopcount == '0') // Counter that ensures only 1 entry per container
                            {
                                $label = $('<label>'), $text = $('<span>', {
                                    text: "All/none"
                                }),
                                    $cb = $('<input>', {
                                        type: 'checkbox',
                                        value: 1
                                    });
                                $text.prependTo($label).css('margin-bottom', '6px');
                                $cb.prependTo($label);
                                ddmenu.prepend($('<li>').prepend($label).css({
                                    'border-bottom': '1px solid grey',
                                    'margin-bottom': '6px'
                                }));
                                mytopcount = '1' // This stops this section running again in cotainer 
                            }
                        });
                    });
                },
                footerCallback: function (tfoot, data, start, end, display) {
                    let api = this.api();
                    api.column(2).footer().innerHTML = "Grand total";
                    // Total over all pages
                    total = api
                        .column(3, { search: 'applied' })
                        .data()
                        .reduce((a, b) => intVal(a) + intVal(b), 0);
                    // Update footer
                    api.column(3).footer().innerHTML = total;
                }
            });
        });
    </script>
    <style>
        .cb-dropdown-wrap {
            max-height: 80px;
            position: relative;
            height: 219px;
            /* Temporary to fix dropdown */
        }
        .cb-dropdown,
        .cb-dropdown li {
            margin: 0;
            padding: 0;
            list-style: none;
            transition: 0.2s 0.23s height ease-in-out;
        }
        .cb-dropdown {
            position: absolute;
            z-index: 1;
            width: 100%;
            height: 100%;
            overflow: hidden;
            background: white;
            border: 1px solid red;
        }
        .cb-dropdown-wrap:hover .cb-dropdown {
            height: 100px;
            overflow: auto;
            transition: 0.15s 0.1s height ease-in-out;
        }
        .cb-dropdown li.active {
            background: lightgreen;
        }
        .cb-dropdown li label {
            display: block;
            position: relative;
            cursor: pointer;
            line-height: 19px;
        }
            .cb-dropdown li label > input {
                position: absolute;
                left: 0;
                top: 0;
                width: 16px;
            }
            .cb-dropdown li label > span {
                display: block;
                margin-left: 24px;
                /* At least, width of the checkbox. */
                font-family: sans-serif;
                font-size: 12px;
                font-weight: normal;
                text-align: left;
            }
        .cb-dropdown li:hover {
            background: lightgrey;
        }
    </style>
</head>
<body>
    <div class="container">
        <table cellspacing="0" class="myClass" id="list" style="width: 500px; font-family: Calibri; font-size: 11px; border-collapse: collapse; border: 1px solid black;">
            <thead>
                <tr>
                    <th>Field1</th>
                    <th>Field2</th>
                    <th>Field3</th>
                    <th>Field4</th>
                </tr>
            </thead>
            <tbody style="border-collapse: collapse; border: 1px solid black;">
                <asp:Repeater ID="Repeater1" runat="server">
                    <ItemTemplate>
                        <tr>
                            <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field1")%></td>
                            <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field2")%></td>
                            <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field3")%></td>
                            <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field4")%></td>
                        </tr>
                    </ItemTemplate>
                </asp:Repeater>
            </tbody>
            <tfoot>
                <tr>
                    <td></td>
                    <td></td>
                    <td style="border-collapse: collapse; background: sandybrown; border: 1px solid black; font-size: larger; font-weight: bold;"></td>
                    <td style="border-collapse: collapse; background: sandybrown; border: 1px solid black; font-size: larger; font-weight: bold;"></td>
                </tr>
            </tfoot>
        </table>
    </div>
</body>
</html>

User's image

RAVI 1,056 Reputation points

2024-02-21T18:07:33.1566667+00:00
hello this works okay

i need four things

my Repeater Filed1 column has more then 2000 records so it possible to keep search somthing like this

in filter if i type ball it should show related avilable data

fixed header on scroll.

remove sort icon

remove this write column name example Field1 if its filed1

Thanking you

Lan Huang-MSFT 29,251 Microsoft Vendor

Hi @RAVI,

remove sort icon

Just set "ordering": false in datatable js.

  $('#list').DataTable({
      "ordering": false,

For the other three requirements, I think it is necessary to combine the dataTables.js library and the select2.js library for better and simpler implementation. Details can be found in the following code:

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
    <script type="text/javascript" src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.min.js"></script>
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.13.7/css/jquery.dataTables.min.css" />
    <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
    <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            var rowCount = $('table#list tbody tr').length;
            sessionStorage.setItem("rowCount", rowCount);
            // Remove the formatting to get integer data for summation
            var intVal = function (i) {
                return typeof i === 'string' ?
                    i.replace(/[\$,]/g, '') * 1 :
                    typeof i === 'number' ?
                        i : 0;
            };
            $('#list').DataTable({
                "ordering": false,
                initComplete: function () {
                    this.api().columns([0, 1]).every(function () {
                        var title = this.header();
                        //replace spaces with dashes
                        title = $(title).html().replace(/[\W]/g, '-');
                        var column = this;
                        var select = $('<select id="' + title + '" class="select2" ></select>')
                            .appendTo($(column.header()).empty())
                            .on('change', function () {
                                //Get the "text" property from each selected data 
                                //regex escape the value and store in array
                                var data = $.map($(this).select2('data'), function (value, key) {
                                    return value.text ? '^' + $.fn.dataTable.util.escapeRegex(value.text) + '$' : null;
                                });
                                //if no data selected use ""
                                if (data.length === 0) {
                                    data = [""];
                                }
                                //join array into string with regex or (|)
                                var val = data.join('|');
                                //search for the option(s) selected
                                column
                                    .search(val ? val : '', true, false)
                                    .draw();
                            });
                        column.data().unique().sort().each(function (d, j) {
                            select.append('<option value="' + d + '">' + d + '</option>');
                        });
                        //use column title as selector and placeholder
                        $('#' + title).select2({
                            multiple: true,
                            closeOnSelect: false,
                            width: '100%',
                            placeholder: "Select a " + title
                        });
                        //initially clear select otherwise first option is selected
                        $('.select2').val(null).trigger('change');
                    });
                },
                footerCallback: function (tfoot, data, start, end, display) {
                    let api = this.api();
                    api.column(2).footer().innerHTML = "Grand total";
                    // Total over all pages
                    total = api
                        .column(3, { search: 'applied' })
                        .data()
                        .reduce((a, b) => intVal(a) + intVal(b), 0);
                    // Update footer
                    api.column(3).footer().innerHTML = total;
                }
            });
        });
    </script>
    <style>
        .select2-results__options[aria-multiselectable="true"] li {
            padding-left: 30px;
            position: relative;           
        }
            .select2-results__options[aria-multiselectable="true"] li:before {
                position: absolute;
                left: 8px;
                opacity: .6;
                top: 6px;
                font-family: "FontAwesome";
                content: "\f0c8";
            }
            .select2-results__options[aria-multiselectable="true"] li[aria-selected="true"]:before {
                content: "\f14a";
            }
    </style>
</head>
<body>
    <div class="container">
        <table cellspacing="0" class="myClass" id="list" style="width: 500px; font-family: Calibri; font-size: 11px; border-collapse: collapse; border: 1px solid black;">
            <thead>
                <tr>
                    <th>Field1</th>
                    <th>Field2</th>
                    <th>Field3</th>
                    <th>Field4</th>
                </tr>
            </thead>
            <tbody style="border-collapse: collapse; border: 1px solid black;">
                <asp:Repeater ID="Repeater1" runat="server">
                    <ItemTemplate>
                        <tr>
                            <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field1")%></td>
                            <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field2")%></td>
                            <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field3")%></td>
                            <td style="border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("Field4")%></td>
                        </tr>
                    </ItemTemplate>
                </asp:Repeater>
            </tbody>
            <tfoot>
                <tr>
                    <td></td>
                    <td></td>
                    <td style="border-collapse: collapse; background: sandybrown; border: 1px solid black; font-size: larger; font-weight: bold;"></td>
                    <td style="border-collapse: collapse; background: sandybrown; border: 1px solid black; font-size: larger; font-weight: bold;"></td>
                </tr>
            </tfoot>
        </table>
    </div>
</body>
</html>

User's image

RAVI 1,056 Reputation points

2024-02-22T07:05:05.5666667+00:00
Hello thank you for the help I have two issues

your css look perfect

but my looking like this why

what to do in css <style> so that it can show same like yours

how to set fix header so that while scrolling header should be fixed thanks
Lan Huang-MSFT 29,251 Reputation points Microsoft Vendor

2024-02-22T07:44:16.6533333+00:00

Hi @RAVI, You'd better provide your code, otherwise I don't know where your problem is, this is the CSS I use.

how to set fix header so that while scrolling header should be fixed thanks

I don't quite understand your needs, I have already set the placeholder of the selection box.
RAVI 1,056 Reputation points

2024-02-22T08:57:46.87+00:00

fixed header example Field1, Field2, Field3 while scrolling thanks
Lan Huang-MSFT 29,251 Reputation points Microsoft Vendor

2024-02-23T03:29:30.4066667+00:00

Hi @RAVI, I don't know if the method I provided is not clear enough. Maybe you can describe it in more detail. If you want to set the title to a search box, your title will only appear as a placeholder.

You can set placeholder: title.
RAVI 1,056 Reputation points

2024-02-24T11:42:22.3466667+00:00

hello kindly check this firstname, lastname, postion,office,age,startdate,salary all this fixed while scrolling down same i want for the above code fix header while scrolling down

Thanking you
Lan Huang-MSFT 29,251 Reputation points Microsoft Vendor

2024-02-26T02:54:50.73+00:00

Hi @RAVI,

This question has nothing to do with your original question. Not sure if your original problem has been solved.

This post generated so many comments and questions. I suggest you repost and provide your code so we can help you resolve the issue.

Share via

multi filter to apply only two columns Field1 and Field2

0 additional answers

Your answer