Multi-row SQL Widgets - Event log entries
Scenario 1: SQL Widget ('Multiple Row SQL' Type) - Validate entries in the "SYSTEM.radplus_event_log" table
Specific Setup:
- Have a report or query to display data in the "SYSTEM.RADplus_event_log" table [TestReport]
- In form "Widget Definition" have a "Multiple Row SQL" type widget created [MultWidget] based on a table. For this test the "cw_hist_client_allergies" filed in form "Client Allergies and Hypersensitivities", is used
- Have a client [ClientA] with just one allergy filed in form "Client Allergies and Hypersensitivities"
- Have another client [ClientB] with two more allergies filed in form "Client Allergies and Hypersensitivities"
- Have [MultWidget] placed on a user's home view or additional console view
Steps
- At the home view, select [ClientA], the client with just one entry filed in the table
- Navigate to location of widget [MultWidget]
- Click the "Refresh" button in the widget (Note the current date and time)
- Validate results are displayed as expected. For this test, just one row is displayed as expected for the "Allergies" on file for [ClientA]
- Run the [TestReport], created to display data in the "SYSTEM.RADplus_event_log" table
- Validate there are only two event log rows displayed for the transaction to step 1a:
- One entry row is displayed for accessing [ClientA]
- Validate the 'event_date' and 'event-time' are consistent with the date time noted in step 1a
- Second row entry is for refreshing the widget with the loaded data for [ClientA]
- Validate the 'event_date' and 'event-time' are consistent with the date time noted in step 1a
- Click to refresh the widget again
- Repeat steps 1a and 1b
- Validate results are as expected
- At the home view, select [ClientB], the client with multiple entries filed in the table
- Navigate to location of widget [MultWidget]
- Click the "Refresh" button in the widget (Note the current date and time)
- Validate results are displayed as expected. For this test, just one row is displayed as expected for the "Allergies" on file for [ClientB]
- Run the [TestReport], created to display data in the "SYSTEM.RADplus_event_log" table
- Validate there are still only two event log rows displayed for the transaction to step 2a, as expected. (Note: only two event log entries are expected, even when multiple entire are displayed in the widget)
- One entry row is displayed for accessing [ClientB]
- Validate the 'event_date' and 'event-time' are consistent with the date time noted in step 2a
- Second row entry is for refreshing the widget with the loaded data for [ClientB]
- Validate the 'event_date' and 'event-time' are consistent with the date time noted in step 2a
- Click to refresh the widget again
- Repeat steps 2a and 2b
- Validate results are as expected
|
Topics
• Admission
• Audit Log
|
