Service Point Completed statutes not listed

Products

• CA Service Catalog

Issue/Introduction

Completed status from CA service catalog not appear in CA service point , all tickets closed any related to CA service catalog request not appear in closed ticket in service point.

Environment

Release : 17.3

Component : Catalog - Service Point/BUI

Cause

This is a know issue and some code changes were identified i.e.

Checking application.conf in searchmicroservice/conf folder you can find
Default xFlow installed directory path:(environment specific) "C:\Program Files\CA\xFlow\APPS\Services\searchmicroservice-17.0.479\conf"

searchQueryInactive = """{
      "from":%d,
      "size": %d,
      "sort" : [
        { "open_dt": { "order": "desc" } }
      ],
      "query": {
        "bool": {
          "must": {
            "match": {
              "requested_for.id": "%s"
            }
          },
          "must_not": {
               "bool": {
                "should": [
                    {
                      "match": {
                        "request_name.asis": "-1"
                      }
                    }
                ]
              }
             },
            "must": {
               "bool": {
                "should": [
                    {
                      "terms": {
                        "status.code": ["2", "4"]
                      }
                    }
                ]
              }
             }
        }
      },
      "stored_fields": ["request_id",    "request_name",    "requested_by", "priority", "last_mod_dt", "open_dt", "resolve_dt", "status.code"]
    }""",

 

Resolution

Work Around:
================

Update the entire block mentioned in the cause section to below code block

searchQueryInactive = """{
      "from":%d,
      "size": %d,
      "sort" : [
        { "open_dt": { "order": "desc" } }
      ],
  "query": {
   "bool": {
    "must_not": [
     {
      "match": {
       "request_name.asis": "-1"
      }
     }
    ],
    "must": [
     {
      "terms": {
       "status.code": ["2", "4"]
      }
     },
     {
      "match": {
       "requested_for.id": "%s"
      }
     }
    ]
   }
  },
      "stored_fields": ["request_id",    "request_name",    "requested_by", "priority", "last_mod_dt", "open_dt", "resolve_dt", "status.code"]
    }""",

Note: Recycle the Services of Catalog and xFlow services to clear any existing cache from old behavior.

Additional Information

This will be part of upcoming rollup patch as part of complete solution.