hello @yaqeen
This question is related to the other one you posted yesterday,
I can’t speak to the usefulness of the code in the earlier post of this thread (from 2022), but your quest to use the Finder to locate data from other tables will not work: the Finder is coded to only look in the patient_data table, and the data you want is not kept there.
https://www.open-emr.org/wiki/index.php/HOWTO:_Change_Search_Columns_in_Patient_Finder
If you really need to have those data displayed in the Finder screen you would need to add columns for them on the page, and re-write the MySQL query that the Finder executes. You would need to add a JOIN on the the pid value between patient_data and insurance_data to pull those columns out of insurance_data.
That is the programming that the OP in the other post said would be needed. But the Finder is not capable of doing what you want in its current state.
Good luck!
- Harley