How can I get a list of values for a specific field in the Registry?

[plawton-umd]

@tloubrieu-jpl @jordanpadams
How do I obtain a list of all the values used for ops:Tracking_Meta/ops:archive_status in a specific registry please?
How do I determine what the value is when it is not "staged", "certified", "restricted", or "archived"?

[jordanpadams]

@alexdunnjpl Can you provide some help here? Q1 is basically the faceting you are implementing now, and Q2 is a multiple not query.

[plawton-umd]

@jordanpadams @alexdunnjpl
Well the link @tloubrieu-jpl supplied at the meeting, https://nasa-pds.github.io/registry-client/usage/index.html#get-all-the-distinct-values-for-one-property, returned the same count results as I was getting querying each known value individually. It did not return an "additional" value for the 1 "extra" product in the "all" count. Hopefully a multiple "not" query will help find it.

[plawton-umd]

Whatever happened was on or after March 7th.

[plawton-umd]

@jordanpadams @tloubrieu-jpl @alexdunnjpl
I found the mystery product! Thank you for reminding me of how to do that. No idea what the existence of this product means. The collection referenced was loaded in the single tenant registry.

{
  "took": 14,
  "timed_out": false,
  "_shards": {
    "total": 0,
    "successful": 0,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 1,
      "relation": "eq"
    },
    "max_score": 0.0,
    "hits": [
      {
        "_index": "sbnumd-registry",
        "_id": "HtBP3pUBQiXH3idKwdsl",
        "_score": 0.0,
        "_source": {
          "query": {
            "match": {
              "_id": "urn:nasa:pds:nh_derived:lorri_cob::1.0"
            }
          },
          "ops:Provenance/ops:registry_sweepers_repairkit_version": 3
        }
      }
    ]
  }
}

[plawton-umd]

@jordanpadams Reload? I never loaded that product "_id". The output was from a search. The product returned does not have a lid, lidvid, or package_id, so registry_manager may not be able to delete it. The lid that it lists exists and looks ok and it has an archive_status of "archived". This looks like some meta data inserted by the sweeper. I will plan to delete and reload that collection and possibly bundles. I am not sure that I can delete "_id": "HtBP3pUBQiXH3idKwdsl".

[jordanpadams]

@plawton-umd copy. Thanks for catching this. We will check it out.

[plawton-umd]

@jordanpadams

On March 28th, 2025 I did a query looking for information related to when the sweeper had last run on a product.

Making POST request to url: https://b3rqys09xmx9i19yn64i.us-west-2.aoss.amazonaws.com/sbnumd-registry/_doc
Including body: {"query": {"match": {"_id": "urn:nasa:pds:nh_derived:lorri_cob::1.0"}}}

It returned

Including headers: {"Content-Type": "application/json"}
Response returned HTTP201 Created: b'{"_index":"sbnumd-registry","_id":"HtBP3pUBQiXH3idKwdsl","_version":1,"result":"created","_shards":{"total":0,"successful":0,"failed":0},"_seq_no":0,"_primary_term":0}'

Which provided no other (local) output. How it ended up as a POST request, I am not currently clear about.
I guess I did make it, but it was not what I wanted. Please delete it.

The query that did supply the wanted information was

Making GET request to url:
https://b3rqys09xmx9i19yn64i.us-west-2.aoss.amazonaws.com/sbnumd-registry/_doc/urn%3Anasa%3Apds%3Anh_derived%3Alorri_cob%3A%3A1.0
Including body: {}
Including headers: {"Content-Type": "application/json"}

[alexdunnjpl]

@plawton-umd @jordanpadams I can remove the offending document once I've sorted out the new privilege escalation procedure for prod

[plawton-umd]

@alexdunnjpl @jordanpadams
FYI: It was deleted. See #375