ISPatientLookupParam.PatientField

Description

This lookup parameter property is used to load the collection of patients by the value from the database column with the specified name.

Syntax

object.PatientField

Part	Attribute	Type	Description
`object`	Required	ISPatientLookupParam	The `object` always implements the ISPatientLookupParam interface

Return Value

string

Example

Display the number of the patients loaded on the basis of the selected Lookup Parameter and their full names.

Dim aParam
Dim aList
Dim aPatientLookupItem 
Dim aLookupType
Dim aMessage 

Set aParam = Profile.MakePatientLookupParam 'ISPatientLookupParam
aParam.PatientField = "PTNT_SURNAME"
aParam.Value = "Smith" 
 
aLookupType = 23 'patient lookup 
set aList = Profile.LoadLookupList2(aLookupType, aParam)  'ISPatientLookupItem collection

aMessage = "Patients Count = " & aList.Count & vbNewLine & vbNewLine  

for each aPatientLookupItem in aList 
  aMessage = aMessage & "Name: " & aPatientLookupItem.Name & vbNewLine
next
  
Profile.MsgBox(aMessage)

Note: This lookup parameter property cannot be used without ISPatientLookupParam.Value.

In Profile Client v8 on User Interface the names of the database columns can be found in Organisation > Preferences > Patient > Patient Status & Select.

Version information

Added in v7.8.0