project-lux / lux-marklogic

Code, issues, and resources related to LUX MarkLogic
Other
3 stars 2 forks source link

Provide script to return the most or least frequent values in field range indexes #69

Closed brent-hartwig closed 3 months ago

brent-hartwig commented 3 months ago

Problem Description: Discover the most and least frequent values in the field range indexes.

Expected Behavior/Solution: Copy a script into query console, configure, and run.

Requirements: Field range indexes.

Needed for promotion: If an item on the list is not needed, it should be crossed off but not removed.

UAT/LUX Examples:

{
  "agentActiveEndDateFloat": "Skipped",
  "agentActivePlaceId": [
    "https://lux.collections.yale.edu/data/place/debc4725-f5d1-416f-a22e-c899a3e908e4 (East Berlin)",
    "https://lux.collections.yale.edu/data/place/a52d0f47-f894-4134-b990-8291bead400f (LON)",
    "https://lux.collections.yale.edu/data/place/2c772931-c847-43e7-bd8d-da3db864c866 (Thalkirchen)",
    "https://lux.collections.yale.edu/data/place/8e117529-3872-494c-ab5f-8d7800be2c64 (Paris)",
    "https://lux.collections.yale.edu/data/place/cfda276e-fddd-4d58-aab5-25894ba991dd (Wien)",
    "https://lux.collections.yale.edu/data/place/f23964ce-4599-4029-afa3-c6df68871ddc (Bigapple)",
    "https://lux.collections.yale.edu/data/place/f09ef029-7032-4a68-bbfa-3efa066f8204 (Leipzig)",
    "https://lux.collections.yale.edu/data/place/3fb50fe5-7ec5-40de-928b-3e456f9bcbf4 (Hamburg)",
    "https://lux.collections.yale.edu/data/place/1d716873-be3c-40c1-a1fb-0c8521d8185b (Heidelberg)",
    "https://lux.collections.yale.edu/data/place/db2f7648-e509-4c50-860f-f97e61bbdc14 (Platì)"
  ],
  "agentActiveStartDateFloat": "Skipped",
  "agentActiveStartDateStr": [
    "1850-01-01T00:00:00",
    "1950-01-01T00:00:00",
    "1750-01-01T00:00:00",
    "1550-01-01T00:00:00",
    "1950-01-01T00:00:00Z",
    "1900-01-01T00:00:00Z",
    "1650-01-01T00:00:00",
    "1800-01-01T00:00:00Z",
    "1450-01-01T00:00:00",
    "1500-01-01T00:00:00"
  ],
  "agentBornEndDateFloat": "Skipped",
  "agentBornStartDateFloat": "Skipped",
  "agentBornStartDateStr": [
    "1950-01-01T00:00:00",
    "1947-01-01T00:00:00",
    "1949-01-01T00:00:00",
    "1946-01-01T00:00:00",
    "1948-01-01T00:00:00",
    "1954-01-01T00:00:00",
    "1953-01-01T00:00:00",
    "1952-01-01T00:00:00",
    "1951-01-01T00:00:00",
    "1955-01-01T00:00:00"
  ],
  ...
}

Dependencies/Blocks:

Related Github Issues:

None

Related links:

None

Wireframe/Mockup:

No need.

brent-hartwig commented 3 months ago

Implemented within PR https://github.com/project-lux/lux-marklogic/pull/70.