Web Reporting Functionality

Precision Bridge web reporting provides an interactive UI for viewing Precision Bridge execution reports. It is divided into two main sections, By Execution, and By Form Mapping.

It can be accessed via this URL:

https://web.precisionbridge.net/

By Execution

The 'By Execution' tab provides a table of all the executions that are visible to PB Web:

This table lists the execution identifier, as well as the source and target servers, start and end times, execution status, and counts for:

• Created
• Updated
• Skipped
• Warnings
• Errors
• Source Deletions
• Attachments

These are aggregate counts for the entire execution.

The table can be filtered by clicking on the filter icon, selecting the field to filter on, and entering the appropriate filter details. For example, to filter on executions completed before 2022-10-01, we could enter the filter:

Click 'add' to apply the filter and 'clear' to remove the filter.

Two charts are also provided in this view, one for recent executions (by date):

and an aggregate summary showing the counts across the executions:

Please note the changes to the table filter will automatically update the data in these charts.

Execution Report

To view details on a specific execution report, click on the report identifier in the table. This will open a dialog with details on this report, including a table with details for each of the form mappings.

In this example there are just two form mappings, 'PARENT' and 'CHILD'.

The table can be filtered in the same way as the executions table, by clicking the filter icon. There is also an aggregate summary bar chart, which displays the sum of the number of records created, updated, and so forth - for all of the form mappings in the filtered table.

By Form Mapping

The 'By Form Mapping' tab provides a similar interface, whereby the table is populated with a list of all form mappings across all executions. This is useful if, for example, we wish to see what migrations have been run for a specific target table and the corresponding data.

This table can be filtered in the same way.

There is also an aggregate summary chart, which displays counts for the number of records created, updated, etc., for all form mappings in the filtered table.