Sorting of entries in Webservice Debugger

[bschmalhofer]

Entries in the Webservice Debugger are sorted per default by creation time. But it is often the case that there are multiple requests per second and it is not obvious which request came first. An example is the autocompletion search with Elasticsearch. This search fires three requests per typed character. When typing arbitrary characters, the following debug entries were shown as the latest entries:

$VAR1 = {
  'Filter' => [],
  'IndexName' => 'ticket',
  'Limit' => '10',
  'Must' => [
    {
      'query_string' => {
        'fields' => [
          'Title',
          'TicketNumber',
          'ArticlesExternal.From',
          'ArticlesExternal.To',
          'ArticlesExternal.Body',
          'ArticlesExternal.Subject',
          'AttachmentsExternal.Content',
          'AttachmentsExternal.Filename',
          'ArticlesInternal.From',
          'ArticlesInternal.To',
          'ArticlesInternal.Body',
          'ArticlesInternal.Subject',
          'AttachmentsInternal.Content',
          'AttachmentsInternal.Filename'
        ],
        'query' => '*asdfghj*'
      }
    }
  ],
  'Return' => '',
  'Sort' => [
    {
      '_score' => 'desc'
    },
    {
      'Created' => 'desc'
    }
  ]
};

and

$VAR1 = {
  'Filter' => [],
  'IndexName' => 'ticket',
  'Limit' => '10',
  'Must' => [
    {
      'query_string' => {
        'fields' => [
          'Title',
          'TicketNumber',
          'ArticlesExternal.From',
          'ArticlesExternal.To',
          'ArticlesExternal.Body',
          'ArticlesExternal.Subject',
          'AttachmentsExternal.Content',
          'AttachmentsExternal.Filename',
          'ArticlesInternal.From',
          'ArticlesInternal.To',
          'ArticlesInternal.Body',
          'ArticlesInternal.Subject',
          'AttachmentsInternal.Content',
          'AttachmentsInternal.Filename'
        ],
        'query' => '*asdfghjk*'
      }
    }
  ],
  'Return' => '',
  'Sort' => [
    {
      '_score' => 'desc'
    },
    {
      'Created' => 'desc'
    }
  ]
};

The expected result would have been that asdfghj was searched before asdfghjk.

TODO:

• order by gi_debugger_entry.id instead of gi_debugger_entry.create_time

[bschmalhofer]

See also #1471.
Changed the search. A test with the Elasticsearch-Box gave the expected order of the the debug entries. Issue can be closed when PR is merged.