# Insurance smart lookup not working in v7 **URL:** \ **Category:** Day-to-Day Users\ **Tags:** billing, infrastructure\ **Created:** [January 7, 2023, 10:26pm UTC](https://community.open-emr.org/t/insurance-smart-lookup-not-working-in-v7/19774 "2023-01-07T22:26:03Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![juggernautsei](https://community.open-emr.org/user_avatar/community.open-emr.org/juggernautsei/32/10764_2.png) [@juggernautsei](https://community.open-emr.org/u/juggernautsei)\ **Post date:** [January 7, 2023, 10:26pm UTC](https://community.open-emr.org/t/insurance-smart-lookup-not-working-in-v7/19774/1 "2023-01-07T22:26:03Z")
Hi, I got a report today that this feature is not working. I have talked about this in another thread. It is not working in any of the v7 installs that I have access to (more than 2). @stephenwaite Is there anything you can point me to? ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [January 8, 2023, 3:03pm UTC](https://community.open-emr.org/t/insurance-smart-lookup-not-working-in-v7/19774/2 "2023-01-08T15:03:35Z")
hi @juggernautsei , in [that thread](https://community.open-emr.org/t/patient-insurance-history-build/17416/21) the smart look up referred to how the insurance is chosen by a `sql` statement . There’s also this [PR](https://github.com/openemr/openemr/pull/5954). Demographics insurance display and edit/save will be helped along now that there’s a [date\_end](https://github.com/openemr/openemr/commit/cd84f594681054216540a79c724b38dc11887db4) in the insurance\_data table. ---
**Author:** ![juggernautsei](https://community.open-emr.org/user_avatar/community.open-emr.org/juggernautsei/32/10764_2.png) [@juggernautsei](https://community.open-emr.org/u/juggernautsei)\ **Post date:** [January 9, 2023, 3:24pm UTC](https://community.open-emr.org/t/insurance-smart-lookup-not-working-in-v7/19774/3 "2023-01-09T15:24:59Z")
Here is the patch to fix this issue before the official patch. We tested and it is working. [insurance\_bug\_fix.zip](https://community.open-emr.org/uploads/short-url/AgSn37uQr4LG6rZOBlJwfecGnEV.zip) (34.8 KB)