Keyword search in not working in System Logs

[Abhishek Singla]

In System logs keyword search does not return results for following query json.

"queryJSON": {
    "table": "MessageTable",
    "start_time": 1452205920000000,
    "end_time": 1452206520000000,
    "select_fields": [
      "Type",
      "Level",
      "MessageTS",
      "Source",
      "ModuleId",
      "Category",
      "Level",
      "NodeType",
      "Messagetype",
      "Xmlmessage"
    ],
    "filter": [
      [
        {
          "name": "Type",
          "value": "1",
          "op": 1
        },
        {
          "name": "Level",
          "value": "5",
          "op": 5
        }
      ],
      [
        {
          "name": "Type",
          "value": "10",
          "op": 1
        },
        {
          "name": "Level",
          "value": "5",
          "op": 5
        }
      ]
    ],
    "sort_fields": [
      "MessageTS"
    ],
    "sort": 2,
    "where": [
      [
        {
          "name": "Keyword",
          "value": "Administrator",
          "op": 1
        }
      ]
    ],
    "dir": 1,
    "limit": 50000
  }

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/18711
Submitter: ted ghose (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Reviewed: https://review.opencontrail.org/18711
Committed: http://github.org/Juniper/contrail-controller/commit/dd981367cbf07bcb57b149a68cd97f30293e1bfe
Submitter: Zuul
Branch: master

commit dd981367cbf07bcb57b149a68cd97f30293e1bfe
Author: Ted Ghose <email address hidden>
Date: Sun Mar 20 22:16:06 2016 -0700

Keyword search in not working in System Logs

- keyword parser refactoring
- changed to lowercase
- added uve & object-log

Closes-bug: 1532363

Change-Id: Ic9f15effa1a5ea14642276b3fc2af65dfd21b59b

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/19102
Submitter: Sundaresan Rajangam (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Reviewed: https://review.opencontrail.org/19102
Committed: http://github.org/Juniper/contrail-controller/commit/16b99f377ea1ac86b157e800d72ec6627757a2dd
Submitter: Zuul
Branch: R3.0

commit 16b99f377ea1ac86b157e800d72ec6627757a2dd
Author: Ted Ghose <email address hidden>
Date: Sun Mar 20 22:16:06 2016 -0700

Keyword search in not working in System Logs

- keyword parser refactoring
- changed to lowercase
- added uve & object-log

Closes-bug: 1532363

Change-Id: Ic9f15effa1a5ea14642276b3fc2af65dfd21b59b
(cherry picked from commit dd981367cbf07bcb57b149a68cd97f30293e1bfe)

Support for prefix match for all index fields in the system/object log
queries

This patch adds support for prefix match for key fields such as Source,
ModuleId, Messagetype and Category in the WHERE clause for system and
object log queries.
contrail-logs to support prefix match queries for --source,
--message-type and --category

Change-Id: I7afabe51a19766802981455fc7ebe3bb2b156acc
Partial-Bug: #1566449
(cherry picked from commit fe6c25151e8ad84a6c87f050dc9624ae9f520466)