Answers

• rf1234 Posts: 2,991Questions: 87Answers: 421

  July 2022

  I would now like to list all directories and subdirectories and see the content of each.
  Is this possible in a datatable?

  Well, you are loading the current rows using ajax. All you need to do is to load all directories and subdirectories in your ajax call. How to do this? That will depend on the programming language you are using on the server. And it will also depend on whether or not you have saved the paths of your documents in a database.

  I save all document paths uploaded to the server or programmatically generated in this database table called "file". Then there are many link tables to the various objects that can have files.

  
• SBD999 Posts: 36Questions: 1Answers: 0

  July 2022 edited July 2022

  Hi,
  I use c# aspnet core. The data is in File Table from sql

  All you need to do is to load all directories and subdirectories in your ajax call. How to do this?
  

  I've created a sql view where there is a path of the directories and the file. I've put level of each row in the sql view.
  So the sql view is created from FileTable which is structured as a tree view

  After that I defined the service api which define the datatable.
  It's a bit clumsy but I put a search of the path and this poses some problems which I will describe below

    query = query.Where(m => m.Name.Contains(searchValue) || m.Path.Contains(searchValue));
  

  I define the jquery as below

  function setSearch(value) {
      $("#table2").dataTable().fnFilter(decodeURI(value));
  }
  $(document).ready(function () {
         $('#table2.table').dataTable({
          "processing": true,
          "serverSide": true,
          "filter": true,
          "ajax": {
              "type": "POST",
              "url": "/api/wPreliminaire/docp",
             "datatype": "data.json"
          },
         //...
          "columns": [
         //..
              {
                  "data": "path", "name": "path", 'render': function (data, type, row, meta) {
                      if (row.isDirectory) {
                          return '<a href="javascript:void" onclick="setSearch(\'' + encodeURI(row.path) + '\'); return false;">' + row.name + '</a>';
                      } else {
                          return '<a href="/api/wPreliminaire/?relativePath=' + row.path + '" >' + row.name + '</a>';
                      }
                  }
             },           
             //...
              {"data": "created", "name": "created", "autoWidth": true}            
          ]
      });     
  });
  

  I'm not satisfy of the result
  1- as you can see in the image below the path of the directory is put in the "search" area when I click on a directory; how could I not have the path in the search area. It's due to the definition of service api. I don't know how I can improve it?

  2- one problem is that when I'm at one level in a directory I can't go up to the upper level. I've to define in jquery an URL to going up one level.

  

  I've seen here : https://datatables.net/forums/discussion/65271/datatables-plugin-with-directory-listing-not-working-when-switching-folders that is possible.

  In the image below this is exactly what I want to do (from the link above)