The ODS/API supports a "Get search pattern" for retrieving documents for a resource using property values. However, the property values used for search often do not map neatly to properties in the resource document. This is because the search properties actually expose the column names of the underlying relational schema, and those names can follow very complex rules. The examples below are in order of increasing complexity.
Example 1: Simple and Role Naming with FeederSchoolAssociation
FeederSchoolAssociation provides two naming examples around schoolId. The document itself has two schoolIds, one as part of a standard School reference named schoolReference and one as part of a School reference with a Feeder role name, named feederSchoolReference:
These two schoolIds are searched on in the ODS/API as schoolId and feederSchoolId:
This is because in the database implementation these are the column names that refer to the two different Schools.
Example 2: Merging with Section
Section provides an example of a merge scenario where one search field maps to multiple document properties. A Section document has three schoolIds, one each for courseOfferingReference, locationReference, and locationSchoolReference:
These three schoolId document properties map to only two schoolIds in the search properties, schoolId and locationSchoolId:
This is because in the database implementation the schoolId column is unified as part of the foreign key reference to both the CourseOffering and Location tables.
Example 3: Prefix Variations with Grade
Grade provides an example of naming variations within a single reference. Grade has a reference to GradingPeriod