.. _student_restfulsimplifiedrelatedstudentkeyvalue_details_search: ============================================================================= GET /student/restfulsimplifiedrelatedstudentkeyvalue/ ============================================================================= Search for related student key values. The underlying data model searched is defined in :class:`devilry.apps.core.models.relateduser.RelatedStudentKeyValue`. The :ref:`simplified` that the server forwards this request to is :meth:`devilry.apps.student.simplified.simplifiedrelatedstudentkeyvalue.SimplifiedRelatedStudentKeyValue.search`. The request parameters (below) all modify the result of the search. They are applied in the following order: 1. The ``query`` is executed. 2. The result of the query is filtered through the ``filters``. 3. The result of the filtering is ordered as specified in ``orderby``. 4. The result of the ordering is limited by ``start`` and ``limit``. ************************** Request ************************** Request example ############### .. code-block:: javascript GET /student/restfulsimplifiedrelatedstudentkeyvalue/ { query: 'a query string', filters: [{field:"application", comp:"exact", value:"My example value"}, {field:"id", comp:"exact", value:15}, {field:"key", comp:"exact", value:"My example value"}], orderby: ["relatedstudent", "-relatedstudent__period", "id", "application", "key", "value"], start: 10, limit: 100 } Optional request parameters ########################### Optional request parameters are encoded as a JSON object and sent as the request body as shown in the example above. query ----- A string to search for. If this is empty or not given, all related student key values that the authenticated user has access to is returned. If the string is not empty, the ``query``-string is split on whitespace, resulting in a list of words. Every *word* in the list is searched for *case-insensitive* matches within the following fields: application Actual location of the field: :class:`devilry.apps.core.models.relateduser.RelatedStudentKeyValue` About the field: Application identifier. Max 300 chars. Type String key Actual location of the field: :class:`devilry.apps.core.models.relateduser.RelatedStudentKeyValue` About the field: Key. Max 300 chars. Type String value Actual location of the field: :class:`devilry.apps.core.models.relateduser.RelatedStudentKeyValue` About the field: Value. Type String filters ------- Filters can be used to perform complex queries. The ``filters`` parameter is a list of filters, where each filter is a map with the following entries: field A field name. comp A comparison operator. value The value to filter on. Example: .. code-block:: javascript [{field:"application", comp:"exact", value:"My example value"}, {field:"id", comp:"exact", value:15}, {field:"key", comp:"exact", value:"My example value"}] related student key values can be filtered on the following *fields*: application Actual location of the field: :class:`devilry.apps.core.models.relateduser.RelatedStudentKeyValue` About the field: Application identifier. Max 300 chars. Type String Supported comparison operators: ``exact``. id Actual location of the field: :class:`devilry.apps.core.models.relateduser.RelatedStudentKeyValue` About the field: Autogenerated identifier. Type Integer Supported comparison operators: ``exact``. key Actual location of the field: :class:`devilry.apps.core.models.relateduser.RelatedStudentKeyValue` About the field: Key. Max 300 chars. Type String Supported comparison operators: ``exact``. relatedstudent__period Actual location of the field: :class:`devilry.apps.core.models.Period` About the field: Autogenerated identifier. Type Integer Supported comparison operators: ``exact``. exact_number_of_results ----------------------- If given, this must be a positive integer (including 0), which specifies the exact number of expected results. This enables searches that you know should fail if they do not get this exact number of results, such as filtering for a User by unique username instead of its numeric ID (where you should expect exactly one result). orderby ------- List of fieldnames. Order the result by these fields. Fieldnames can be prefixed by ``'-'`` for descending ordering. start ----- After query, filters and orderby have been executed, the result is limited to the values from *start* to *start+limit*. Start defalts to ``0``. limit ----- Limit results to this number of items. Defaults to ``50``. ********************* Response ********************* On success ########## Example ------------------------ *note that the is wrong in the example. The id is always unique. However, the example is generated from a non-varying dataset.* .. code-block:: javascript 200 OK { total: 20, items: [ { relatedstudent: 15, relatedstudent__period: 15, id: 15, application: "My example value", key: "My example value", value: "myvalue" }, { relatedstudent: 15, relatedstudent__period: 15, id: 15, application: "My example value", key: "My example value", value: "myvalue" }, ... ] } Success response details ------------------------ Responds with HTTP code *200* and a *JSON encoded* dict containing the list of results and the *total* number of items found before applying ``limit`` and ``start``. Each result in the list is a JSON object where the *key* is a fieldname and the associated value is the *value* for that field. The result always contains the following fields: relatedstudent Actual location of the field: :class:`devilry.apps.core.models.relateduser.RelatedStudent` About the field: Autogenerated identifier. Type Integer relatedstudent__period Actual location of the field: :class:`devilry.apps.core.models.Period` About the field: Autogenerated identifier. Type Integer id Actual location of the field: :class:`devilry.apps.core.models.relateduser.RelatedStudentKeyValue` About the field: Autogenerated identifier. Type Integer application Actual location of the field: :class:`devilry.apps.core.models.relateduser.RelatedStudentKeyValue` About the field: Application identifier. Max 300 chars. Type String key Actual location of the field: :class:`devilry.apps.core.models.relateduser.RelatedStudentKeyValue` About the field: Key. Max 300 chars. Type String value Actual location of the field: :class:`devilry.apps.core.models.relateduser.RelatedStudentKeyValue` About the field: Value. Type String On error ######## On errors, we respond with one of the :ref:`restful_api_error_statuscodes`.