LBV data type ProviderID alter option displayed

OpenEMR Development
1

Good Morning,
OK I give up after umpteen hours of digging.

The LBV data type ProviderID take it’s choices from the user table where the user is active and has an NPI number entered.

It displays the options to choose from as Lname, Fname.

I thought it would be a fairly easy matter to alter that so the choice would be by username.(I customized the username to include lname,fname and address fragment)

I did track down the options.inc.php file which creates the sql for numerous data_types in a series of elseif statements in
function generate_form_field
but NOT for data_type = 11 which is the ProviderID data_type.

I think my problem/question boils down to:

  • Where id the sql for data_type 11 generated ?
    OR
  • Where is the LBV layout options for each data_type created? Could I copy whatever defines it into another data_type and then munge option.inc.php to produce the sql I’d prefer ?

Thanks for the help

Bob

openemr 7.0.2
php 8.2.22
ubuntu 20.04
11.2.4-MariaDB-