Answers

• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  January 2022

  Currently you have this:

         searchPanes: {
              select: {
                      style: 'multi'
                  },
              layout: 'columns-3',
              columns: [6, 7, 9],
              dtOpts: {
                  scrollY: '300px'
              },
              cascadePanes: true
          },
          order: [
              [2, 'asc']
          ],
          rowGroup: {
              dataSrc: 19
          },
  

  Can you add column 19 so we can take a look at the issue?

  Also which column is column 19 - so we don't have to count

  Kevin
• pmconsulting Posts: 36Questions: 11Answers: 0

  January 2022

  Sorry! Please check it now.
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  January 2022

  This looks like an example of your category column:

  <td id='product_15'>Pre-filled Slant-Style Shippers (Season & Savor®)</td>

  Could be the &amp. See this recent thread about issues with ampersand and SearchPanes. Try the nightly version linked in the thread.

  Kevin
• pmconsulting Posts: 36Questions: 11Answers: 0

  January 2022

  I've removed all of the ampresands and registration symbols from that column. The only remaining characters are parenthesis. But it still hides all rows when any terms under the rowGrouped pane are selected.
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  January 2022

  You have this:

         columnDefs: [
  ....
              {
                  targets: [1, 2, 8],
                  visible: false,
                  searchable: false,
              }
          ],
  

  You added column 1 to the SearchPanes but you have searching disabled for that column.

  Kevin
• pmconsulting Posts: 36Questions: 11Answers: 0

  January 2022

  I'm hiding column 1 because it's being used for rowGroups. I'm guessing that I can't use it as a searchPane unless its visible? If that's the issue, can I set it to 0 width, or something?
• pmconsulting Posts: 36Questions: 11Answers: 0

  January 2022

  Yes - hiding the rowGroup column is the issue. Trying to adjust the width of that column as it's actually unnecessary when grouping and I'm tight on space.
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  January 2022

  You can hide the column and have it searchable. The problem is this searchable: false,. You can do something like this:

         columnDefs: [
  ....
              {
                  targets: [1],
                  visible: false,
              },
              {
                  targets: [2, 8],
                  visible: false,
                  searchable: false,
              }
          ],
  

  Kevin