Syntax for Searching by Period

[ren...@gmail.com]

Hi All,

What's the correct syntax for searching by period ? I tried Period (and period) and Period.start with the below syntax

SELECT fhir_search('{"resourceType": "Encounter", "queryString": "Period=ge2016-06-24"}');

but I get the not found search parameter error
ERROR:  Error: Not found SearchParameter {"base":"Encounter","name":"Period"}

on https://github.com/fhirbase/fhirbase-plv8/blob/master/src/fhir/search_date.litcoffee , the search parameter of Period looks like its supposed to be accepted ?

Searching by date
SELECT fhir_search('{"resourceType": "Encounter", "queryString": "date=ge2016-06-24"}');
gives all the encounters.. even those lesser than 2016-06-24

e.g

{
    "resourceType": "Bundle",
    "type": "searchset",
    "total": 5,
    "link": [{
        "relation": "self",
        "url": "\/Encounter?date=ge2016-06-24&_page=0"
    }],
    "entry": [{
        "resource": {
            "id": "8c40a107-899f-4773-8088-a2b73de6c3bf",
            "meta": {
                "extension": [{
                    "valueString": "POST",
                    "url": "fhir-request-method"
                },
                {
                    "valueUri": "Encounter",
                    "url": "fhir-request-uri"
                }],
                "versionId": "b3f6b649-0a28-4961-9afc-44a4508db6ab",
                "lastUpdated": "2016-06-21T04:09:26.730Z"
            },
            "resourceType": "Encounter",
            "identifier": [{
                "system": "SGH",
                "value": 1466482166
            }],
            "status": "inprogress",
            "class": "private",
            "type": [{
                "coding": [{
                    "system": "http:\/\/snomed.info\/sct",
                    "code": "270427003",
                    "display": "Patient-initiated encounter"
                }]
            }],
            "participant": [{
                "individual": {
                    "reference": "Practitioner\/1000",
                    "display": " Doctor1 Lim MD (874635264)"
                }
            }],
            "period": {
                "start": "2016-06-21T04:09"
            },
            "reason": [{
                "coding": [{
                    "system": "http:\/\/snomed.info\/sct",
                    "code": 11429006,
                    "display": "Consultation (procedure)"
                }]
            }],
            "location": [{
                "location": {
                    "reference": "Location\/1",
                    "display": "S"
                }
            }],
            "serviceProvider": {
                "reference": "Organization\/1000"
            }
        }
    },
    {
        "resource": {
            "id": "89fa313c-277c-49b2-8a54-21f6e0134509",
            "meta": {
                "extension": [{
                    "valueString": "POST",
                    "url": "fhir-request-method"
                },
                {
                    "valueUri": "Encounter",
                    "url": "fhir-request-uri"
                }],
                "versionId": "ea5444e9-094a-4319-8f70-7b10d1d50d51",
                "lastUpdated": "2016-06-22T03:53:42.615Z"
            },
            "resourceType": "Encounter",
            "identifier": [{
                "system": "SGH",
                "value": 1466567622
            }],
            "status": "inprogress",
            "class": "private",
            "type": [{
                "coding": [{
                    "system": "http:\/\/snomed.info\/sct",
                    "code": "270427003",
                    "display": "Patient-initiated encounter"
                }]
            }],
            "patient": {
                "reference": "Patient\/30BCC1E3-321F-30C9-6945-CF51CB",
                "display": "{\"insname\":\"\",
                \"inspkg\":\"\",
                \"insaccnum\":\"\",
                \"inslimit\":\"\",
                \"insremarks\":\"\"
            }"},"participant":[{"individual":{"reference":"Practitioner\/1000","display":"Doctor1LimMD(874635264)"}}],"period":{"start":"2016-06-22T03: 53"},"reason":[{"coding":[{"system":"http: \/\/snomed.info\/sct","code":11429006,"display":"Consultation(procedure)"}]}],"location":[{"location":{"reference":"Location\/1","display":"SouthWing,
            secondfloor"}}],"serviceProvider":{"reference":"Organization\/1000"}}},{"resource":{"id":"ddec9236-b366-4d36-9466-2c93748ff78c","meta":{"extension":[{"valueString":"POST","url":"fhir-request-method"},{"valueUri":"Encounter","url":"fhir-request-uri"}],"versionId":"397f6431-30bb-437b-a416-4d1894f4a0df","lastUpdated":"2016-06-22T09: 03: 33.693Z"},"resourceType":"Encounter","identifier":[{"system":"SGH","value":1466586213}],"status":"inprogress","class":"private","type":[{"coding":[{"system":"http: \/\/snomed.info\/sct","code":"270427003","display":"Patient-initiatedencounter"}]}],"patient":{"reference":"Patient\/382B8C00-9A21-5024-F929-4F16E7","display":"{
                \"insname\":\"\",
                \"inspkg\":\"\",
                \"insaccnum\":\"\",
                \"inslimit\":\"\",
                \"insremarks\":\"\"
            }"},"participant":[{"individual":{"reference":"Practitioner\/1000","display":"Doctor1LimMD(874635264)"}}],"period":{"start":"2016-06-22T09: 03"},"reason":[{"coding":[{"system":"http: \/\/snomed.info\/sct","code":11429006,"display":"Consultation(procedure)"}]}],"location":[{"location":{"reference":"Location\/1","display":"SouthWing,
            secondfloor"}}],"serviceProvider":{"reference":"Organization\/1000"}}},{"resource":{"id":"8e3c88e4-75b9-4ab2-8624-253b1f5745e1","meta":{"extension":[{"valueString":"POST","url":"fhir-request-method"},{"valueUri":"Encounter","url":"fhir-request-uri"}],"versionId":"55e081c3-2cc5-43cd-bd0f-01481d61abe9","lastUpdated":"2016-06-22T09: 17: 38.942Z"},"resourceType":"Encounter","identifier":[{"system":"SGH","value":1466587058}],"status":"inprogress","class":"private","type":[{"coding":[{"system":"http: \/\/snomed.info\/sct","code":"270427003","display":"Patient-initiatedencounter"}]}],"patient":{"reference":"Patient\/CC62D8D1-106F-7296-E8AF-051666","display":"{
                \"insname\":\"\",
                \"inspkg\":\"\",
                \"insaccnum\":\"\",
                \"inslimit\":\"\",
                \"insremarks\":\"\"
            }"},"participant":[{"individual":{"reference":"Practitioner\/1000","display":"Doctor1LimMD(874635264)"}}],"period":{"start":"2016-06-22T09: 17"},"reason":[{"coding":[{"system":"http: \/\/snomed.info\/sct","code":11429006,"display":"Consultation(procedure)"}]}],"location":[{"location":{"reference":"Location\/1","display":"SouthWing,
            secondfloor"}}],"serviceProvider":{"reference":"Organization\/1000"}}},{"resource":{"id":"e55b8adc-af7c-4e6f-a861-b60927db0096","meta":{"extension":[{"valueString":"POST","url":"fhir-request-method"},{"valueUri":"Encounter","url":"fhir-request-uri"}],"versionId":"42cb0bde-b135-4858-8b40-b1d17994fae7","lastUpdated":"2016-06-23T02: 17: 08.874Z"},"resourceType":"Encounter","identifier":[{"system":"SGH","value":1466648228}],"status":"inprogress","class":"private","type":[{"coding":[{"system":"http: \/\/snomed.info\/sct","code":"270427003","display":"Patient-initiatedencounter"}]}],"patient":{"reference":"Patient\/CC62D8D1-106F-7296-E8AF-051666","display":"{
                \"insname\":\"\",
                \"inspkg\":\"\",
                \"insaccnum\":\"\",
                \"inslimit\":\"\",
                \"insremarks\":\"\"
            }"},"participant":[{"individual":{"reference":"Practitioner\/1000","display":"Doctor1LimMD(874635264)"}}],"period":{"start":"2016-06-23T02: 17"},"reason":[{"coding":[{"system":"http: \/\/snomed.info\/sct","code":11429006,"display":"Consultation(procedure)"}]}],"location":[{"location":{"reference":"Location\/1","display":"SouthWing,
            secondfloor"}}],"serviceProvider":{"reference":"Organization\/1000"}}}]}

[ren...@gmail.com]

Ok just went thru the searchparameters table, parameter for encounter period is date,
but when there's no period.end , all the results get selected,

I changed the code in the pvl8_init() line 5279 from
upper = value.end ? date.to_upper_date(value.end) : 'infinity';
to
upper = value.end ? date.to_upper_date(value.end) : date.to_upper_date(value.start);

and the search now works for period's without end date.

Rama