[parameter]=|[code] search does not return results

[Andrzej-Pietrzak]

SELECT fhir_create_resource('{"allowId": true, "resource": {"id": "id3", "identifier": [{"use": "official", "value": "12-asd", "system": "http://www.bugrers-hosp.com/patients"}, {"use": "temp", "value": "s2-567", "system": "second-system"}, {"use": "temp", "value": "hjkl"}], "resourceType": "Patient"}}');

SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=|hjkl"}'); -- nok, expected 1 res (id3), got none

[Andrzej-Pietrzak]

Still present in 1.3.0.11

Examples:

SELECT fhir_create_resource('{"allowId": true, "resource": {"id": "id1", "identifier": [{"use": "official", "type": {"text": "Social Beneficiary Identifier Text", "coding": {"value": "Social Beneficiary Identifier", "system": "http://hl7.org/fhir/identifier-type", "display": "SB"}}, "value": "12345", "period": {"start": "2015-12-12"}, "system": "http://www.bugrers-hosp.com/patients", "assigner": {"display": "Burgers University Medical Center", "reference": "Oraganization/f001"}}], "resourceType": "Patient"}}'); SELECT fhir_create_resource('{"allowId": true, "resource": {"id": "id2", "identifier": [{"use": "official", "value": "12345", "system": "test-patients"}], "resourceType": "Patient"}}'); SELECT fhir_create_resource('{"allowId": true, "resource": {"id": "id3", "identifier": [{"use": "official", "value": "12-asd", "system": "http://www.bugrers-hosp.com/patients"}, {"use": "temp", "value": "s2-567", "system": "second-system"}, {"use": "temp", "value": "hjkl"}], "resourceType": "Patient"}}'); SELECT fhir_create_resource('{"allowId": true, "resource": {"id": "id4", "identifier": [{"use": "temp", "value": "hjkl", "system": "test-patients"}], "resourceType": "Patient"}}'); SELECT fhir_create_resource('{"allowId": true, "resource": {"id": "id5", "identifier": [{"use": "temp", "value": "ABC-876", "system": "test-patients"}], "resourceType": "Patient"}}'); SELECT fhir_create_resource('{"allowId": true, "resource": {"id": "id6", "active": false, "resourceType": "Patient"}}');

SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=nonexisting"}'); -- ok, 0 res SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=nonexisting|nonexisting"}'); -- ok, 0 res SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=test-patient|nonexisting"}'); -- ok, 0 res

SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=12"}'); -- ok, 0 res SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=asd"}'); -- ok, 0 res

SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=12345"}'); -- ok, 2 res, id1, id2 SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=test-patients|12345"}'); -- ok, 1 res, id2 SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=http://www.bugrers-hosp.com/patients|12345"}'); -- ok, 1 res, id1 SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=|12345"}'); -- ok, 0 res

SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=s2-567"}'); -- ok, 1 res, id3 SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=second-system|s2-567"}'); -- ok, 1 res, id3

SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=hjkl"}'); -- ok, 2 res, id3, id4 SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=|hjkl"}'); -- nok, expected 1 res (id3), got none SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=test-patients|hjkl"}'); --ok, 1 res, id4

SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=ABC-876"}'); --ok, 1 re, id5 SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=abc-876"}'); --ok, 1 res, id5 SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=test-patients|ABC-876"}'); --ok, 1 re, id5 SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=test-patients|ABC-876"}'); --ok, 1 res, id5 SELECT fhir_search('{"resourceType": "Patient", "queryString": "identifier=TEST-PATIENTS|abc-876"}'); --ok, 1 res, id5

[szymonp-kainos]

What's the status on this issue ?

[danil]

@szymonp-kainos

What's the status on this issue ?

open

[szymonp-kainos]

I meant: is it in progress or not started or left for later ?

[danil]

not started (no one assigned)