Answers

• Hareeom Posts: 2Questions: 1Answers: 0

  October 2022 edited October 2022

  How to Apply One Or More Database use in url

  <script>
      $(document).ready(function (e, row) {
          $("#Sector_PoliceStation_LocationWiseReport").DataTable(
              {
                  "processing": true,
                  "serverSide": false,
                  "filter": true,
                  "orderMulti": false,
                  "pageLength": 10,
                  "pagingType": 'full_numbers',
                  "scrollX": true,
                  "ordering": true,
                  "fixedColumns": {
                      leftColumns: 1,
                      rightColumns: 1
                  },
                  "ajax": {
                     ** url: "/SectorWiseReport/Getdetails",**
                      type: "get",
                      dataSrc: "Data",
                      dataType: "json",
                  },
  
                  columns: [
                      {
                          className: 'details-control',
                          orderable: false,
                          data: null,
                          defaultContent: '',
                          width: '1%'
                      },
                      { data: 'SectorName' },
                      { data: 'Present' },
                      { data: 'Absent' }
  
                  ],
                  "order": [[1, 'asc']]
              });
      });
  </script>
  

  Edited by Kevin: Syntax highlighting. Details on how to highlight code using markdown can be found in this guide
• kthorngren Posts: 21,330Questions: 26Answers: 4,951

  October 2022

  Your server script will need to be configured to fetch the data from the multiple databases using join methods for your particular databases or whatever is appropriate to get the data you want.

  Kevin