Replies

• kthorngren Posts: 21,980Questions: 26Answers: 5,076

  March 10

  I'm not sure what specifically your question is. The order option is used to set the initial table order. You can use the order API to change the prder programmatically. If this doesn't help please provide more details about the problem you are trying to solve.

  Kevin
• bur Posts: 33Questions: 2Answers: 3

  March 10 edited March 10

  I'm also not sure what you're asking exactly, maybe this helps:
  Order by column name on init:

  let table = new DataTable('#tableId', function() {
      // other options
      order: [{ name: 'column_name', dir: 'desc' }],
  });
  

  Order by column name using order API:

  table.order([{ name: 'column_name', dir: 'desc' }]);
  

  Note that there's currently a small bug with ordering by name using the API. For now you can work around it like this:

  table.order([[ table.column('column_name:name').index(), 'desc' ]]);
  
• arvindg82 Posts: 21Questions: 4Answers: 0

  March 10 edited March 10

  But column name is coming dynamically from multiple accounts in same table. Column name is fixed for each account.
  So, how can we use condition?
• kthorngren Posts: 21,980Questions: 26Answers: 5,076

  March 10

  The name value passed is a string. You can set a varaible before initializing Datatabes and use that instead of a literal string, for example:

  lat myColumnName = 'column_name';
  
  let table = new DataTable('#tableId', function() {
      // other options
      order: [{ name:MyColumnName, dir: 'desc' }],
  });
  

  Kevin
• bur Posts: 33Questions: 2Answers: 3

  March 10 edited March 10

  I don't really understand what you mean. Can you provide a test case?

  Potentially you could do something like:

  let table = new DataTable('#tableId', function() {
      // other options
      order: [{
          name: condition1 ? 'column_name1'
                  : condition2 ? 'column_name2'
                  : 'default_column_name',
          dir: 'desc'
      }],
  });
  

  Or if you can't define your condition until the table is initialized you could do:

  let table = new DataTable('#tableId', function() {
      // options
  });
  
  $(document).ready(function() {
      let column_name = 'default_column_name';
  
      if (condition1) column_name = 'column_name1';
      else if (condition2) column_name = 'column_name2';
  
      table.order([{ name: column_name, dir: 'desc' }]);
  });
  
• FireNet999 Posts: 11Questions: 3Answers: 0

  April 8

  I am researching something which I think may be along the same lines.
  I have a column with dates of seniority of membership with the earliest date being
  1 01/01/2020
  2 02/03/2021
  3 03/04/2022

  I can sort the dates no problem and I would like another column that would do the count 1-3 so if 2 was to leave 3 would become 2 and so on
• kthorngren Posts: 21,980Questions: 26Answers: 5,076

  April 8

  @FireNet999 Sounds like you want an index column like this example.

  Kevin
• FireNet999 Posts: 11Questions: 3Answers: 0

  April 9

  Many thanks Kevin
  That looks like it fits my needs
  I will give it a go
  Colin