Use this strategy to get documents from the view by key. The view will be searched by the first sorted column.


Allowed method



Let's assume our database has view called (ByTopic), that contains first sorted column displaying Topic field.

Notice the {filterValue} part of the first line bellow. This is placeholder for where SmartNSF expects to read parameter value for keyVariableName from, see line 4.

router.GET('topics/filter/{filterValue}') {
   mapJson 'id', json:'id', type:'STRING', isformula:true, formula:'@DocumentUniqueID'
   mapJson 'date_created', json:'date_created', type:'DATETIME', isformula:true, formula:'@Created'
   mapJson 'topic', json:'topic', type:'STRING'
   mapJson 'author', json:'author', type:'STRING', isformula:true, formula:'@Name([CN]; @Author)'


URL parameters:


With route defined above, URL will return all documents from view (ByTopic) with field Topic starting with "test". If mode('exact') was specified, it would return just those document with Topic "test".


For example, if only one document matches this filter, we'll get this JSON:

    "entries": [
            "date_created": "2017-03-03T18:28+00:00",
            "author": "Martin Jinoch",
            "id": "54502859C07299C7C12580D8006404F4",
            "topic": "test"
    "start": 1,
    "total": 1,
    "count": 1


Related articles

Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.

Related issues