[FEATURE] Enhance explain API with query function like filtering, sorting

[bowenlan-amzn]

Add some query parameters to filter by certain fields in the explain API for managed indices Such as filtering for only failed managed indices or ones using specific policies or in specific states or on specific actions etc.

[Joshua152]

Can I be assigned to this task? Thanks!

[bowenlan-amzn]

Current support:

• Seach and sort by index name https://github.com/opensearch-project/index-management/blob/d42cc69f8202ea5c7732f6db6c2543a7376d0f30/src/main/resources/mappings/opendistro-ism-config.json#L650 Default search params are

  size: 20
  from: 0
  sortField: managed_index.index
  sortOrder: asc
  queryString: *

• Query string query on index name, it supports wildcard, regex, fuzziness, proximity

Requirements:

• Filter by the policy applied https://github.com/opensearch-project/index-management/blob/d42cc69f8202ea5c7732f6db6c2543a7376d0f30/src/main/resources/mappings/opendistro-ism-config.json#L776
• Filter by metadata.state https://github.com/opensearch-project/index-management/blob/d42cc69f8202ea5c7732f6db6c2543a7376d0f30/src/main/resources/mappings/opendistro-ism-config.json#L807
• Filter by metadata.action https://github.com/opensearch-project/index-management/blob/d42cc69f8202ea5c7732f6db6c2543a7376d0f30/src/main/resources/mappings/opendistro-ism-config.json#L824
• Filter by failed/not failed https://github.com/opensearch-project/index-management/blob/d42cc69f8202ea5c7732f6db6c2543a7376d0f30/src/main/resources/mappings/opendistro-ism-config.json#L824 https://github.com/opensearch-project/index-management/blob/d42cc69f8202ea5c7732f6db6c2543a7376d0f30/src/main/resources/mappings/opendistro-ism-config.json#L842 https://github.com/opensearch-project/index-management/blob/d42cc69f8202ea5c7732f6db6c2543a7376d0f30/src/main/resources/mappings/opendistro-ism-config.json#L900