CareWell clinic / patients-find

patients-find

Search patients. FIND_PATIENTS builds the WHERE clause from the criteria the user filled (name, city, born from, born to), counts the hits (COUNT_QUERY, message level 25) and queries. Moving to another row fires WHEN-NEW-RECORD-INSTANCE, which shows "Patient n of total".

0defects

580values match

27tolerated by policy

11waived

0unmapped

Three runs from a fresh database gave byte-identical diffs. Behaviour that looks odd in the migrated app but is the original's: faithful to the original and waivers. Files: scenario, golden record, target record, diff (JSON).

Scenario steps

Items are addressed by their Forms name (BLOCK.ITEM[row]), the same name in the original and, through the mapping, in the migrated app.

#	Step	Action	Checked on the original
0		Open form `cw_login`
1		Type `CTL.USERNAME` = ADMIN
2	sign in	Click `CTL.SIGN_IN`
3	patients	Click `HOME.PATIENTS`
4		Type `CTL.NAME` = ali
5	find by name	Click `CTL.FIND`
6		Type `CTL.NAME` = x
7	empty the name	Press `BackSpace`
8		Type `CTL.CITY` = Delhi, `CTL.BORN_FROM` = 01-JAN-1970, `CTL.BORN_TO` = 31-DEC-1980
9	find by city and birth date	Click `CTL.FIND`
10	second row	Click `PATIENTS.MRN[1]`

Screens, step by step

Left: the original Oracle Forms application, recorded on a virtual display. Right: the migrated application in headless Chromium. Screenshots are evidence only; the comparison works on the recorded values.

No step screenshots of the original were kept for this app; the comparison uses the recorded values, which are in the golden record below.

Step 0: open cw_login

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 00-open — Migrated (.NET, PostgreSQL)

Step 1: type

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 01-type — Migrated (.NET, PostgreSQL)

Step 2: sign in

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 02-sign-in — Migrated (.NET, PostgreSQL)

Step 3: patients

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 03-patients — Migrated (.NET, PostgreSQL)

Step 4: type

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 04-type — Migrated (.NET, PostgreSQL)

Step 5: find by name

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 05-find-by-name — Migrated (.NET, PostgreSQL)

Step 6: type

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 06-type — Migrated (.NET, PostgreSQL)

Step 7: empty the name

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 07-empty-the-name — Migrated (.NET, PostgreSQL)

Step 8: type

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 08-type — Migrated (.NET, PostgreSQL)

Step 9: find by city and birth date

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 09-find-by-city-and-birth-date — Migrated (.NET, PostgreSQL)

Step 10: second row

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 10-second-row — Migrated (.NET, PostgreSQL)

Golden record of the original

After each step: the focus, the displayed values that changed, the message line and any alert. The full record (every item of every step, windows, lists of values) is in the JSON file.

#	Step	Action (by name)	Focus after	Displayed values that changed	Message line	Alert	Expect
0		`Open form cw_login`	`CTL.USERNAME[0]`
1		`Type CTL.USERNAME = ADMIN`	`CTL.USERNAME[0]`	`CTL.USERNAME[0]` = ADMIN
2	sign in	`Click CTL.SIGN_IN`	`HOME.SCHEDULE[0]`	`HOME.CHECKED_IN[0]` = <any> `HOME.OPEN_AMOUNT[0]` = 15,015 `HOME.OPEN_INVOICES[0]` = 180 `HOME.TODAY_TOTAL[0]` = <any> `HOME.WELCOME[0]` = Welcome, Clinic Administrator
3	patients	`Click HOME.PATIENTS`	`PATIENTS.MRN[0]`	`CTL.COUNTER[0]` = Patient 1 of 240 `PATIENTS.CITY[0]` = Noida `PATIENTS.CITY[1]` = Gurugram `PATIENTS.CITY[2]` = Delhi `PATIENTS.CITY[3]` = Bengaluru `PATIENTS.CITY[4]` = Delhi `PATIENTS.CITY[5]` = Pune `PATIENTS.CITY[6]` = Hyderabad `PATIENTS.CITY[7]` = Gurugram `PATIENTS.CITY[8]` = Chennai `PATIENTS.FIRST_NAME[0]` = Adam `PATIENTS.FIRST_NAME[1]` = Meera `PATIENTS.FIRST_NAME[2]` = Riya `PATIENTS.FIRST_NAME[3]` = Samuel `PATIENTS.FIRST_NAME[4]` = Sara `PATIENTS.FIRST_NAME[5]` = Aisha `PATIENTS.FIRST_NAME[6]` = Aisha `PATIENTS.FIRST_NAME[7]` = Arjun `PATIENTS.FIRST_NAME[8]` = David `PATIENTS.LAST_NAME[0]` = Ali `PATIENTS.LAST_NAME[1]` = Ali `PATIENTS.LAST_NAME[2]` = Ali `PATIENTS.LAST_NAME[3]` = Ali `PATIENTS.LAST_NAME[4]` = Ali `PATIENTS.LAST_NAME[5]` = Banerjee `PATIENTS.LAST_NAME[6]` = Banerjee `PATIENTS.LAST_NAME[7]` = Banerjee `PATIENTS.LAST_NAME[8]` = Banerjee `PATIENTS.MRN[0]` = CW100686 `PATIENTS.MRN[1]` = CW100791 `PATIENTS.MRN[2]` = CW100427 `PATIENTS.MRN[3]` = CW100014 `PATIENTS.MRN[4]` = CW100084 `PATIENTS.MRN[5]` = CW100350 `PATIENTS.MRN[6]` = CW100847 `PATIENTS.MRN[7]` = CW100966 `PATIENTS.MRN[8]` = CW101547 `PATIENTS.PHONE[0]` = +91 9714247138 `PATIENTS.PHONE[1]` = +91 9747265671 `PATIENTS.PHONE[2]` = +91 9319917758 `PATIENTS.PHONE[3]` = +91 9239366764 `PATIENTS.PHONE[4]` = +91 9231537636 `PATIENTS.PHONE[5]` = +91 9698396784 `PATIENTS.PHONE[6]` = +91 9078161038 `PATIENTS.PHONE[7]` = +91 9550902396 `PATIENTS.PHONE[8]` = +91 9732765917 `PATIENTS.PLAN_ID[1]` = 5 `PATIENTS.PLAN_ID[3]` = 6 `PATIENTS.PLAN_ID[5]` = 6 `PATIENTS.PLAN_ID[8]` = 1
4		`Type CTL.NAME = ali`	`CTL.NAME[0]`	`CTL.NAME[0]` = ali
5	find by name	`Click CTL.FIND`	`PATIENTS.MRN[0]`	`CTL.COUNTER[0]` = Patient 1 of 5
6		`Type CTL.NAME = x`	`CTL.NAME[0]`	`CTL.NAME[0]` = x
7	empty the name	`Press BackSpace`	`CTL.NAME[0]`
8		`Type CTL.CITY = Delhi, CTL.BORN_FROM = 01-JAN-1970, CTL.BORN_TO = 31-DEC-1980`	`CTL.BORN_TO[0]`	`CTL.BORN_FROM[0]` = 01-JAN-1970 `CTL.BORN_TO[0]` = 31-DEC-1980 `CTL.CITY[0]` = Delhi
9	find by city and birth date	`Click CTL.FIND`	`PATIENTS.MRN[0]`	`CTL.COUNTER[0]` = Patient 1 of 6 `PATIENTS.CITY[0]` = Delhi `PATIENTS.CITY[1]` = Delhi `PATIENTS.CITY[3]` = Delhi `PATIENTS.CITY[5]` = Delhi `PATIENTS.FIRST_NAME[0]` = Riya `PATIENTS.FIRST_NAME[1]` = Sara `PATIENTS.FIRST_NAME[2]` = Isha `PATIENTS.FIRST_NAME[3]` = Kavya `PATIENTS.FIRST_NAME[4]` = Ravi `PATIENTS.FIRST_NAME[5]` = Sara `PATIENTS.LAST_NAME[2]` = Brown `PATIENTS.LAST_NAME[3]` = Mehta `PATIENTS.LAST_NAME[4]` = Menon `PATIENTS.LAST_NAME[5]` = Shah `PATIENTS.MRN[0]` = CW100427 `PATIENTS.MRN[1]` = CW100084 `PATIENTS.MRN[2]` = CW100910 `PATIENTS.MRN[3]` = CW100448 `PATIENTS.MRN[4]` = CW100861 `PATIENTS.MRN[5]` = CW101204 `PATIENTS.PHONE[0]` = +91 9319917758 `PATIENTS.PHONE[1]` = +91 9231537636 `PATIENTS.PHONE[2]` = +91 9151564479 `PATIENTS.PHONE[3]` = +91 9553973116 `PATIENTS.PHONE[4]` = +91 9610995157 `PATIENTS.PHONE[5]` = +91 9038442171 `PATIENTS.PLAN_ID[4]` = 4 `PATIENTS.PLAN_ID[5]` = 1
10	second row	`Click PATIENTS.MRN[1]`	`PATIENTS.MRN[1]`	`CTL.COUNTER[0]` = Patient 2 of 6

Database effects

None: the scenario changes no row and draws no sequence value.

Classified diff against the migrated app

Diff: patients-find
counts: match 580, tolerated 27, waived 11, defect 0, unmapped 0, harness 0
generated-id pairs (source -> target): none

waivers:
  C1 [proposed] Oracle's frame title before sign-in: applied to 2 value(s)
  C2 [proposed] The home page's collected-today gauge reads empty: applied to 9 value(s)
  C3 [proposed] Help > About names nobody: applied to 0 value(s)
  C4 [proposed] The home page forgets the user after File > Exit of a module: applied to 0 value(s)
  C5 [proposed] No item has the focus after a fetched record is refused: applied to 0 value(s)
  C6 [proposed] The second payment of billing-pay is lost: applied to 0 value(s)

[tolerated] ui.values.HOME.CHECKED_IN  rule=mask:today-counts  x9
[tolerated] ui.values.HOME.OPEN_AMOUNT  rule=text  x9
[tolerated] ui.values.HOME.TODAY_TOTAL  rule=mask:today-counts  x9
[waived] ui.values.HOME.COLLECTED  rule=waiver:C2  x9
    step02.values.HOME.COLLECTED[0]: source '' | target '83'
    step03.values.HOME.COLLECTED[0]: source '' | target '83'
    step04.values.HOME.COLLECTED[0]: source '' | target '83'
    step05.values.HOME.COLLECTED[0]: source '' | target '83'
    step06.values.HOME.COLLECTED[0]: source '' | target '83'
    step07.values.HOME.COLLECTED[0]: source '' | target '83'
    step08.values.HOME.COLLECTED[0]: source '' | target '83'
    step09.values.HOME.COLLECTED[0]: source '' | target '83'
    step10.values.HOME.COLLECTED[0]: source '' | target '83'
[waived] ui.windows  rule=waiver:C1  x2
    step00.windows: source [["FRAME", "Oracle Fusion Middleware Forms Services"], ["MAIN_WIN",... | target [["FRAME", "CareWell Clinic"], ["MAIN_WIN", "CareWell Clinic - Sign...
    step01.windows: source [["FRAME", "Oracle Fusion Middleware Forms Services"], ["MAIN_WIN",... | target [["FRAME", "CareWell Clinic"], ["MAIN_WIN", "CareWell Clinic - Sign...

Waivers

Id	Waiver	Values	Reason
C1	Oracle's frame title before sign-in	2	Until CW_NAV.START_FORM sets the MDI title, the Forms frame shows the runtime's own title "Oracle Fusion Middleware Forms Services". The target's frame reads "CareWell Clinic" from the start: the web page is the clinic's application, not Oracle's runtime. From sign-in on, both show the same title.
C2	The home page's collected-today gauge reads empty	9	HOME.COLLECTED is a display item drawn as a half gauge on the original canvas; the Forms client's component tree exposes no text for it, so the source records '' at every step. The target shows the amount REFRESH_HOME computes (the same query as the source), as a number with a bar.