ISCase.Source2Code

Example

Display the number of the cases loaded on the basis of the selected filter, their titles, the codes and descriptions of their referral sources, the dates and time of these sources, the dates and time when the cases were opened.

Dim aPatient 
Dim aFilter
Dim aCases, aCase
Dim aSource
Dim i
Dim aMessage
  
Set aPatient = Profile.SelectPatient
set aFilter = Profile.CreateCasesFilter
aFilter.Patient = aPatient
set aCases = Profile.LoadCases(aFilter)

aMessage = "The number of the cases for " & aPatient.SurnameFirstName &_ 
  " = " & aCases.Count 
  
for i = 0 to aCases.Count -1
  set aCase = aCases.Item(i)
  aMessage = aMessage & vbNewLine & (i + 1) & ") " & aCase.CaseTitle &_ 
    " was opened on " & aCase.OpenedOn 
  if aCase.Source2ID <> 0 then
    set aSource = Profile.LoadShortCode(aCase.Source2ID)
    aMessage = aMessage & vbNewLine & "       -Source 2: " &_ 
      aSource.Description & " (Code: " & aCase.Source2Code & ")" &_ 
      vbNewLine & "       -Source 2 date: " & aCase.Source2Date
  end if    
next      

Profile.MsgBox(aMessage)