CredentialEngine / CredentialRegistry

Repository for development of the Credential Registry
Apache License 2.0
12 stars 10 forks source link

Search query error #700

Closed siuc-nate closed 4 months ago

siuc-nate commented 4 months ago

The competency framework search in the Finder generates this query:

{
    "@type": "ceasn:CompetencyFramework",
    "search:termGroup": {
        "search:value": [
            {
                "search:operator": "search:orTerms",
                "^ceasn:isPartOf": {
                    "search:operator": "search:orTerms",
                    "ceasn:competencyLabel": "test",
                    "ceasn:competencyText": "test",
                    "ceasn:comment": "test",
                    "ceasn:conceptKeyword": "test",
                    "ceasn:codedNotation": "test"
                },
                "ceasn:creator": {
                    "ceterms:subjectWebpage": "test"
                },
                "ceasn:publisher": {
                    "ceterms:subjectWebpage": "test"
                },
                "ceasn:name": "test",
                "ceasn:description": "test",
                "ceasn:source": "test",
                "ceasn:conceptKeyword": "test"
            }
        ],
        "search:operator": "search:andTerms"
    }
}

Previously, it worked. However, it has started to throw an error: image

{
    "error": "PG::UndefinedTable: ERROR:  missing FROM-clause entry for table \"indexed_envelope_resources\"\nLINE 1: ...eferences\" LEFT OUTER JOIN \"t9e\" ON \"t9e\".\"@id\" = \"indexed_e...\n                                                             ^\n"
}

This is leading to the Finder showing 0 search results when the user first comes to the page (blind search) or does a keyword-based query.

excelsior commented 4 months ago

@siuc-nate The fix is deployed to production.

siuc-nate commented 4 months ago

This is working now, thanks.