Several records of resources with same resource Id returned leading to duplication about android-fhir HOT 9 OPEN

@aditya-07 are you available for us to have a debugging session? If yes, let me know when I can set one up.

Yes, that sounds like a good idea. Feel free to setup one today (Wednesday) or tomorrow between 11am-6pm IST.

from android-fhir.

Additional context

• As mentioned above when resources are updated and updateIndicesForResource() executed, there'll be multiple DateTimeIndexEntity entries for that resource.

• In this additional example, duplicate resource records are returned from the getIncludeQuery that's used in searchForwardReferencedResources()
  This is a result of the LEFT JOIN DateTimeIndexEntity

from android-fhir.

Hey @SebaMutuku. You are probably right in why duplicate resources are being returned in search - because of duplicate DateTimeIndexEntity records. However, I am not able to observe duplicate DateTimeIndexEntity records when updating same resource locally.

Can you provide steps to replicate it ?
Is it happening when the resource is synced and then one is making local changes ?

from android-fhir.

Hello @MJ1998? attached is the SQLite DB for patient shown on the screenshot below

Patient ID 119c3d24-123b-4719-b39d-5e9be05f8e85
Check the record on LocalChangeEntity and to answer your question, this only happens on local changes. When you sync data to the server, the issue is solved.
resources_duplication_db.zip

from android-fhir.

LocalChangeEntity has one record per resource. Do you mean to check DateTimeIndexEntity table ?

from android-fhir.

@MJ1998 yes, that's the entry causing duplication. If you check it on this line https://github.com/google/android-fhir/blob/master/engine/src/main/java/com/google/android/fhir/search/MoreSearch.kt#L58 you will see what the query returns

from android-fhir.

@SebaMutuku @allan-on Can you please add the Search Query passed into the fhirEngine.search<Resource>(search).

Also, can you specify the engine version that's being used.

from android-fhir.

@aditya-07 are you available for us to have a debugging session? If yes, let me know when I can set one up.

from android-fhir.

@aditya-07 here's the sample database we have had a look at together
resources_db.zip

from android-fhir.