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.

Sign up for GitHub

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

Jump to bottom

bug: Insurance Company Service does not load records that have no address entry #7226

Closed
adunsulag opened this issue Feb 13, 2024 · 0 comments · Fixed by #7227
Closed

bug: Insurance Company Service does not load records that have no address entry #7226

adunsulag opened this issue Feb 13, 2024 · 0 comments · Fixed by #7227
Assignees
@adunsulag
Labels
developers This issue targets an issue that is for developers/collaborators/module writers/technical users
Milestone
7.0.2.1

Comments

@adunsulag
Copy link
Member

If an insurance company is created / imported that has no city or state then a corresponding address record is not created. However, when we retrieve the record there is a JOIN clause on the address table which will exclude insurance company records inadvertently.

We need to change this so that records are still returned even if there are no created address records. This functions similar to the work and fax phone numbers.
@adunsulag adunsulag self-assigned this Feb 13, 2024
adunsulag added a commit to DiscoverAndChange/openemr that referenced this issue Feb 13, 2024
@adunsulag
Fixes openemr#7226 Insurance company address query
a310cc6 
Make it so that we still return records even if there is no
corresponding address record.  This happens because city and street if
they are empty forces an address record to be skipped in creation.

Fixes openemr#7226
@adunsulag adunsulag mentioned this issue Feb 13, 2024
Merged
adunsulag added a commit that referenced this issue Feb 14, 2024
@adunsulag
Fixes #7226 Insurance company address query (#7227)
daaf91f 
Make it so that we still return records even if there is no
corresponding address record.  This happens because city and street if
they are empty forces an address record to be skipped in creation.

Fixes #7226
sjpadgett added a commit to sjpadgett/openemr that referenced this issue Feb 15, 2024
@sjpadgett
Merge branch 'master' of https://github.com/openemr/openemr into weno…
06a2fd8 
…_daily

* 'master' of https://github.com/openemr/openemr:
  Fixes openemr#7224, openemr#7217 insurance company changes (openemr#7225)
  fix: bug fix (openemr#7230)
  bug: fix bug (openemr#7229)
  Fixes openemr#7226 Insurance company address query (openemr#7227)
  fix: possible fix of logic in jquery-datetimepicker-2-5-4-translated.js (openemr#7223)
stephenwaite pushed a commit to stephenwaite/openemr that referenced this issue Mar 11, 2024
@adunsulag @stephenwaite
Fixes openemr#7226 Insurance company address query (openemr#7227)
e91f863 
Make it so that we still return records even if there is no
corresponding address record.  This happens because city and street if
they are empty forces an address record to be skipped in creation.

Fixes openemr#7226
@adunsulag adunsulag added this to the 7.0.2.1 milestone Apr 2, 2024
@adunsulag adunsulag added the developers This issue targets an issue that is for developers/collaborators/module writers/technical users label May 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@adunsulag adunsulag

Labels
developers This issue targets an issue that is for developers/collaborators/module writers/technical users
Projects
None yet
Milestone
7.0.2.1
Development

Successfully merging a pull request may close this issue.

Fixes #7226 Insurance company address query DiscoverAndChange/openemr
1 participant
@adunsulag