Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Return unique include and revInclude resources per search filter match. #2544

Open
wants to merge 6 commits into
base: master
Choose a base branch
from

Conversation

aditya-07
Copy link
Collaborator

IMPORTANT: All PRs must be linked to an issue (except for extremely trivial and straightforward changes).

Fixes #2512

Description

  1. Return distinct included and revIncluded resource per searchIndex.
  2. When user updates a resource, if the resource has an meta.lastUpdated, use that for index value.

Alternative(s) considered
Have you considered any alternatives? And if so, why have you chosen the approach in this PR?

Type
Choose one: Bug fix
Screenshots (if applicable)

Checklist

  • I have read and acknowledged the Code of conduct.
  • I have read the Contributing page.
  • I have signed the Google Individual CLA, or I am covered by my company's Corporate CLA.
  • I have discussed my proposed solution with code owners in the linked issue(s) and we have agreed upon the general approach.
  • I have run ./gradlew spotlessApply and ./gradlew spotlessCheck to check my code follows the style guide of this project.
  • I have run ./gradlew check and ./gradlew connectedCheck to test my changes locally.
  • I have built and run the demo app(s) to verify my change fixes the issue and/or does not break the demo app(s).

@aditya-07 aditya-07 requested review from santosh-pingle and a team as code owners May 14, 2024 11:58
Copy link
Collaborator

@MJ1998 MJ1998 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM. NIT comment.

@aditya-07 aditya-07 enabled auto-merge (squash) May 30, 2024 09:35
@aditya-07 aditya-07 disabled auto-merge May 31, 2024 13:06
@@ -2369,7 +2369,7 @@ class SearchTest {
.isEqualTo(
"""
SELECT * FROM (
SELECT rie.index_name, rie.resourceUuid, re.serializedResource
SELECT DISTINCT rie.index_name, rie.resourceUuid, re.serializedResource
Copy link
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

discussed with aditya - i'm worried about what it means to be sorting by a field that is repeated.... for example if you have a patient with two given names aaron and charlie, and another one with two given names barry and david, then what order should this query actually produce, if it's deterministic at all?

do we know that the ordering here is perserved somehow (i.e. we take the first value)?

Comment on lines +4092 to +4093
// A person has multiple first names. Searching a group including Patient sorted by
// Patient.GIVEN should return single copy of of the Patient resource.
Copy link
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

can you explain a little bit more that the dupliatees of record are generated by the join sql statement for the sorting. and probably link to the issue as well.

Copy link
Collaborator

@jingtang10 jingtang10 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

can you double check on the performance impact of this? doesn't have to produce a comprehensive report - but would be godo at least for the dataset in the github issue this is not having an appreciatable impact.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: PR under Review
Development

Successfully merging this pull request may close these issues.

Several records of resources with same resource Id returned leading to duplication
4 participants