field names

[draego]

is there any way to generate a list of all the field names – both stock and custom – that contain data from either patients, contacts, or clinic info? I would like to have a listing of all the names so i can try my hand at customizing reports.

thanks

Jason

[frispa]

I have exact the same question.

Please advise.

[Support]

Hi – you can click on the TOOLS tab and then ADVANCED DB OPERATION. The following code will give you all the standard patient fields :-

select * from per

and this code will get you all the custom fields :-

select * from custom_patient_fields

[Author]

Posts