Queries Need to Work Dependably

[jeannekitchens]

We have an API guide https://credreg.net/registry/searchapi with numerous examples of queries that has been around for a long time. The issue is that customers keep finding queries defined in the guide may not work or seem to work intermittently. This is a blocker.

This is an example of a situation where it's unclear if the queries are working properly and causing confusing for a customer.

@excelsior (https://credential-engine.slack.com/team/U09SXAGRM) possibly more query issues. There's a ceterms:Organization published to the Registry with the ceterm:name "Project Management Institute (PMI).
The following query, brings back 726 results, any Organization name that contains either Project or Management.
{
"ceterms:name": {
"search:value": "Project Management",
"search:matchType": "search:contains"
}
}
This query brings back 0 results. Why would there be 0 results when there's "Project" "Management" and "PMI" included with the name of two organizations?
https://credentialengineregistry.org/resources/ce-d63e18dd-ec71-4453-9297-74b990037df0
https://credentialengineregistry.org/resources/ce-df242b97-167f-4a19-8317-cc59c8997b80
{
"ceterms:name": {
"search:value": "Project Management (PMI)",
"search:matchType": "search:contains"
}
}
This query, brings back 2 results, both having all of the words in the name.
"ceterms:name": {
"search:value": "Project Management Institute (PMI)",
"search:matchType": "search:contains"
}
}

[excelsior]

@jeannekitchens That's the expected behavior. A condition with the search:contains modificator only matches if the given property contains an exact case-insensitive match to the provided value, as documented here:

https://credreg.org/registry/searchapi#ctdlquerystructure_basics_text

All string conditions use fuzzy matching by default, i.e. that this query

{ "ceterms:name": "Project Management (PMI)" }

will return all resources whose name contains project OR management OR pmi.

[jeannekitchens]

@excelsior @rohit-joy should search:contains be searching for the presence of a specified string or substring not the entire not the entirety of the property. E.g., if you seach a name for string:contains "Project Management", and there's a name Project Management Institute. This search would bring back the organization with the name Project Management Institute. Exact match is the entire text or data field.