---
title: "PowerBi Dashboard Release Notes"
canonical: "https://servicedesk.maxgeo.com/space/DS/1659535365/PowerBi%20Dashboard%20Release%20Notes"
format: markdown
---
<details>
<summary>June 2026</summary>

# QAQC PBI Dashboard v2.2.0

**This release covers the key QAQC 2.2.0 changes so you can quickly adapt workflows: it highlights usability upgrades like dark mode and universal left-panel filters, important plotting defaults (log scale and exclusion of non-positive values), new adjustable test parameters (difference threshold and detection limit factor), and removed legacy pages/tabs to streamline reporting. Reviewing it prevents unexpected analysis gaps and helps you reconfigure settings for consistent results**.

Version 2.2.0 of QAQC introduces several updates aimed at improving usability, consistency, and performance. The most notable addition is the introduction of **dark mode**, providing users with an improved viewing experience, particularly in low-light environments.

Additionally, some legacy pages (Batch Tracking and Batch Check) and tabs have been removed where equivalent or improved reporting is already available elsewhere in the system.

![image-20260624-051858.png](media://99d890c6-a495-4a37-8042-0ba81be4aab5)

## Filters

- Both **Global** and **Local filters** are now available on every page.
- Filters can be accessed via the **left-hand panel**.
- Available local filters may vary depending on the selected site.

**Comment:**  
This change improves navigation and flexibility significantly. Having consistent access to filters across all pages makes analysis more efficient and reduces the need to jump between views.

![image-20260624-052007.png](media://5fb09cc0-c319-4816-a1d8-fc382dc56278)

The availability of local filters depends on the selected report section. Some report sections may offer different filter options, while others may have none.

![image-20260624-052041.png](media://5bc7e2d7-026e-4b1b-8f1f-cf4613dd5aad)

## Repeats

- Scatter Plot, QQ Plot, and TH charts now default to a **logarithmic scale**.
- Values less than or equal to zero are excluded from these charts.
- Users can still manually adjust the scale if required.
- The **“Stats” tab has been removed**.  
**Comment:**  
Setting log scale as default is a sensible choice for geochemical data, as it improves interpretability. However, users should be mindful that non-positive values are excluded, which could impact certain analyses.  
The removal of the Stats tab simplifies the report, but may require users to adjust their workflow.

![image-20260624-052223.png](media://210c33b2-cb5e-446f-a3e5-1f64c8f28c7b)

Users can now define how tests are calculated by adjusting:

- **Difference Threshold (%)**
- **Detection Limit Factor**

  
**Comment:**  
This is a strong enhancement, giving users more control and making QAQC more flexible across different datasets and site requirements.

![image-20260624-052324.png](media://a55aaa52-f1f1-41bf-96aa-d33f50191d1d)

## CRM

1. Removed tabs:

- **By LabCode**
- **Bias Results**

![image-20260624-052432.png](media://02e5e051-063b-4609-90d3-2a322a691010)

## Removed Features

The following elements have been removed in this version:

1. Entire page: **Batch Tracking**
2. Entire page: **Batch Check**
3. “Stats” tab from Repeats (by Sample Name and Repeat Code)
4. CRM Performance tabs:
  1. By LabCode
  2. Bias Results
5. CRM Summary Stats tab:
  1. By Others

# **Other Dashboards UI Enhancements**

We have released several reports with UI-only updates. All listed reports have been updated to a **dark mode design**, aligned with the **DataShed5 theme** to improve visual consistency and user experience.

No structural, data model, or functional changes have been made.

## **Striplog Dashboard v2.1**

![image-20260624-041252.png](media://549663a4-c302-4cbf-bb88-8d1143105cc3)

## **Sample Slueth Dashboard v2.1**

![image-20260624-041423.png](media://b535cc84-bcdd-4113-b608-d4e6bae54648)

## **DrillHoleForm Dashboard v2.1**

![image-20260624-041542.png](media://84aa3018-0529-4958-8c4e-ab6ce99ae14a)

## **Drill Plod Dashboard v2.2**

![image-20260624-041641.png](media://e60daf22-56f4-444a-882e-922234f1d5de)

## **Audit Dashboard v1.2**

![image-20260624-041722.png](media://a5fb703a-fc3e-4ce8-973d-f1e47138e481)
</details>

<details>
<summary>May 2026</summary>

# QAQC Paginated Report v.2.0.2 Release Notes

This Release quickly shows how to filter a Paginated Report in Datashed to a specific required date and select a particular record. Follow it to save time locating the exact entry you need and ensure consistent, repeatable report navigation for QA/QC tasks.


Navigate to your Paginated Report in datashed

![QAQC Paginated Report v.2.0.2 (Copy) - Step 0.jpeg](media://eaaf6820-f44d-4a57-8e11-90b1ca20bf1b)

Note the **From_Lab_Final_Date** and **To_Lab_Final_Date** fields.

Click the "Required (DD/MM/YYYY)" field.  
Type "2 Enter"  
Click this icon.  
Click "KA22060711"

![QAQC Paginated Report v.2.0.2 (Copy) - Step 1.webp](media://627f41a6-bdbd-48a1-ac8b-e69cfd604045)
</details>

<details>
<summary>March 2026</summary>

# Audit Report v1.1.1 Release Notes

This release adds clearer line‑level visibility across LS reports, including the new Total Lines metric in Stat Compliance, a Line_ID field in LS Coordinates, and a Total Lines column in the LS Summary to improve reporting accuracy and analysis.

Internal Note: Relationship between LS Site -> LS Samp, LS Coordinates, LS Samp Aggr, changed to [key = DataSet + Site_ID + Line_ID]


## **Stat Compliance – LS**

*A new “Total Lines” measure has been added to provide clearer visibility of line activity.*

![Audit Report v1.1.1 - Release Notes - Step 0 (2).jpeg](media://51b05ab1-2db4-42fb-937b-38699a24481b)


## **Linear Sites**

*A new “Total Lines” metric and “Line_ID” field have been added to provide clearer visibility of line‑level activity.*

![Audit Report v1.1.1 - Release Notes - Step 2 (2).jpeg](media://02b73bda-67bc-4d18-ad2c-f90133c184c2)


## **LS – Coordinates**

*The “Line_ID” field has been added to provide clearer identification of individual lines.*

![Audit Report v1.1.1 - Release Notes - Step 3 (1).jpeg](media://a8d1e9f5-ee67-4962-82e7-cdf6f8417232)


## **Tenement Reports – LS Summary**

*The “Total Lines” metric has been added to provide clearer visibility of line coverage across tenements.*

![Audit Report v1.1.1 - Release Notes - Step 4 (1).jpeg](media://7b5341be-76a2-4963-bf70-2eb3f95aa3ef)



---

# QAQC Report v 2.1.1 Release Notes

This update adds new filtering options for improved sample categorization and enhances the responsive QQ Plot for clearer data visualization. Updated statistics and test calculations deliver more accurate results, helping users achieve better quality control and more efficient data interpretation.


## Repeats

After setting your **Global FIlters**, navigate to **Repeats - by Sample Name**.

![QAQC Report v.2.1.1 Release Notes - Step 0.png](media://6c875288-1938-4eb3-80e4-96c3b70be424)


Open **Filters** on the left side.

![QAQC Report v.2.1.1 Release Notes - Step 1.png](media://45f9882c-6d57-4086-9b8b-29a026684f88)


Three new filters have been added:

- **Sample Category**
- **Sample Method**
- **Sample Type**

![QAQC Report v.2.1.1 Release Notes - Step 2.png](media://03686fc0-66a0-42f7-a4d6-8bd80beebeec)


These can also be selected in **Show by** in the Scatterplot.

![QAQC Report v.2.1.1 Release Notes - Step 3.png](media://0838a189-72be-43bc-9d1b-4ad7e0ed89c3)


Navigate to the **Stats** tab.

![QAQC Report v.2.1.1 Release Notes - Step 4.png](media://75df6488-1996-4a20-a526-f8d64ee898b6)


All measures in this section have been updated.

![QAQC Report v.2.1.1 Release Notes - Step 5.png](media://f64bb71e-7056-45ac-befd-664595edf1af)


Navigate to the **QQ Plot** tab.

![QAQC Report v.2.1.1 Release Notes - Step 6.png](media://02aa15fd-dc07-4cc6-b39f-2ac207432327)


The **QQ Plot** is now responsive and can zoom and pan.

![QAQC Report v.2.1.1 Release Notes - Step 7 (2).webp](media://a5894bf6-de94-46b5-9812-eaa49efea195)


## CRM

Go back to the **Menu** and select **CRM Performance**.

![QAQC Report v.2.1.1 Release Notes - Step 13.png](media://a2bf7c60-00dc-4ae2-9e83-f11d0c3dd870)


The **CRM Performance** screen has three new selection options:

- **sysAssayStatus**
- **sysResult Minimum**
- **sysResult Maximum**

![QAQC Report v 2.1.1 Release Notes - Step 15.png](media://8407017f-5157-44aa-a7b9-dd77e0c6a5cf)



Select the **Raw Results** tab.

![QAQC Report v 2.1.1 Release Notes - Step 16.png](media://fda10383-8067-40b6-abe9-5bc3ea91144e)


The **Test** calculation has been updated.

![QAQC Report v.2.1.1 Release Notes - Step 15.png](media://5711da29-5475-4bc5-979a-a3871d188349)



---

# Audit Report v1.1 - Release Notes

Please be aware, some information on this page may come from aggregation tables and are refreshed once a day.


**Menu Page**  
Click **Global Filters** to select DataSets.  
In Audit Report v1.1 has two completely new sections, **PT** and **LS**.

![Audit Report v1.1 - Release Notes - Step 0 (2).png](media://d4ee4065-bca4-411a-a211-329303708d0e)


Select the **DataSet** you want to analyse. Selecting several of them will significantly slow the performance of the dashboard.

![Audit Report v1.1 - Release Notes - Step 1 (1).png](media://566596c5-baa1-4f3b-97c5-97909c020c35)


**Stat Compliance Overall Page**

- Introduces visual comparisons of data completeness and common quality issues for each asset type.
- Enables rapid identification of spatial and sampling‑related data risks across the full dataset.
- Supports quicker assessment and prioritisation of data remediation efforts.

![Audit Report v1.1 - Release Notes - Step 2.png](media://728f887f-006b-4440-a63b-1b9cfeeecf3c)


**Stat Compliance – General Summary**

- Provides a focused view of drillhole data compliance and quality.
- Shows overall status of drillhole records, highlighting completeness and compliance issues.
- Surfaces common data gaps such as missing survey information, dates, or drillhole type.
- Includes a detailed drillhole‑level table for deeper investigation.
- Helps users quickly identify and resolve incomplete or non‑compliant drillhole data.
- Drillhole list is dynamically retrieved from the SQL server to ensure the most current dataset is always displayed.

![Audit Report v1.1 - Release Notes - Step 5.png](media://68f179c9-bb63-4293-9220-2b4a2552d65d)


**Drillhole Collars - Stat Compliance**

- Displays overall compliance status and highlights common data gaps such as missing survey details, dates, or drillhole type.
- Includes a detailed drillhole‑level table to support deeper data review and issue resolution.
- Drillhole list is now dynamically retrieved from the SQL server to ensure the page always reflects the most current dataset.

**Drillhole Collars - General Summary**

- Highlights overall data completeness and common missing or non‑compliant attributes.
- Delivers a consolidated view of key data quality issues across drillholes and associated samples.
- Supports faster identification of issues requiring investigation or remediation.

![Audit Report v1.1 - Release Notes - Step 6 (1).png](media://24f12af2-b38d-405d-a25e-c1251d752c2e)


**DH Samples**

- Summarises overall sample‑record status and highlights common missing or incomplete attributes, including assays, dates, methods, and sample condition.
- Includes detailed sample‑level information to support faster identification and resolution of data quality issues.
- Sample list is now dynamically retrieved from the SQL server, ensuring the page always reflects the most current dataset.

![Audit Report v1.1 - Release Notes - Step 8.webp](media://75e46230-0264-4aa4-857b-c95c783bc8ed)


**Drillhole - Downhole Summary**

- Displays geology intervals with depth ranges and lithology, along with notable downhole intercepts for key elements.
- Enables users to understand subsurface geology and quickly identify significant mineralised intervals within each drillhole.

![Audit Report v1.1 - Release Notes - Step 11 (1).png](media://6881a7e6-43fe-463d-8bcb-1fc59bc5dedb)


**DH - Coordinates**

- Displays recorded coordinates and highlights issues such as missing spatial data, duplicated locations, and absent survey methods.
- Includes a version‑specific note outlining which coordinate fields are collected based on the MDS version.
- Presents summary statistics by dataset to support efficient identification and resolution of location‑related data quality issues affecting mapping, spatial analysis, and reporting accuracy.

![Audit Report v1.1 - Release Notes - Step 12.png](media://bf6dcbe5-2ba5-46ef-a481-7baa26e57295)


**DH - Downhole Survey**

- Displays survey measurements such as dip, azimuth, and depth for easy review.
- Highlights potential issues including missing values, inconsistencies, and out‑of‑range measurements.
- Provides summary views by dataset to help users quickly assess survey data quality and identify records requiring correction.
- Supports accurate drillhole orientation, contributing to reliable geological modelling.

![Audit Report v1.1 - Release Notes - Step 13 (1).png](media://1d448f59-1cd3-42fb-bfdf-b76644ebbd3a)


**Stat Compliance - General Summary (PT)**

- Highlights completeness of site survey information and common data gaps such as missing survey details or site classification.
- Identifies sample‑related issues including absent assays, types, dates, or collector information.
- Offers a clear view of data quality risks across site and sample records, helping prioritise areas requiring further attention or remediation.

![Audit Report v1.1 - Release Notes - Step 15 (1).png](media://4fda6a5e-2cee-45b7-b00c-a6b8d012b713)


**Point Sites**

- Summarises site records and highlights missing or incomplete survey details and site classifications.
- Includes a detailed table for reviewing individual site attributes.
- Supports identification and resolution of data gaps that may affect the accuracy and reliability of site locations and classifications.

**Point Sites - General Summary**

- Provides a focused view of point site data compliance and quality.
- Summarises overall site records to show completeness and compliance status.
- Highlights missing or incomplete survey information and site classifications.
- Includes a detailed table for reviewing individual site attributes.
- Helps users identify and address data gaps affecting the accuracy and reliability of site locations and classifications.

![Audit Report v1.1 - Release Notes - Step 16.webp](media://b49150c8-807e-4592-a40b-8cf9526d2922)


**PT Samples**

- Summarises sampling records and highlights common issues such as missing assays, sample classifications, collection details, or dates.
- Includes a detailed table for reviewing individual point‑sample attributes.
- Helps users identify and correct data gaps that may impact the reliability and usability of point‑sample information.

![Audit Report v1.1 - Release Notes - Step 19.webp](media://2bc011be-f2e6-4d8c-bdea-c107f5c42754)


**PT - Coordinates**

- Displays recorded site coordinates and highlights issues such as missing spatial data, duplicated locations, and absent survey methods.
- Includes a version‑specific note outlining which coordinate fields are collected based on the MDS version.
- Presents summary statistics by dataset to support identification and resolution of location‑related data quality issues affecting spatial accuracy, mapping outputs, and reporting reliability.

![Audit Report v1.1 - Release Notes - Step 22 (1).png](media://fe2565f6-0a55-400f-bb20-ac5db49dac86)


**Stat Compliance - (LS)**

- Summarises line‑based site records and highlights common gaps such as missing survey details, completion information, or linear classifications.
- Identifies recurring sample‑data issues linked to line surveys.
- Offers a clear snapshot of data completeness and key quality risks specific to line‑based datasets, helping prioritise areas requiring further review or remediation.

![Audit Report v1.1 - Release Notes - Step 23 (1).png](media://9dcc6a66-3fdd-4072-a077-c9f62cccc43f)


**Linear Sites**

- Lists individual line features with associated types and program information.
- Flags missing or incomplete elements such as survey methods, completion details, or linear classifications.
- Enables users to drill into specific line records and resolve data gaps affecting the accuracy and reliability of line‑based survey data.

![Audit Report v1.1 - Release Notes - Step 24.webp](media://ba65a004-3041-45cd-aa1f-322045e4551a)


**LS Samples - Stat Compliance**

- Summarises sample records and highlights missing or incomplete attributes such as assays, methods, conditions, dates, or collector details.
- Includes a detailed table for reviewing individual sample records.
- Supports identification and correction of data gaps that may impact the reliability and usability of line‑based sampling data.  
General Summary

![Audit Report v1.1 - Release Notes - Step 27.webp](media://e407860f-b8a9-4375-ab65-0992ed1983fb)


**LS - Coordinates**

- Displays recorded spatial coordinates for line sites and highlights issues such as duplicated coordinates, missing survey methods, or incomplete spatial data.
- Includes a version‑specific note outlining which coordinate fields are collected based on the MDS version.
- Presents dataset‑level statistics and a detailed coordinate table to support identification and resolution of spatial data quality issues affecting line‑based mapping, analysis, and reporting.

![Audit Report v1.1 - Release Notes - Step 30 (1).png](media://6651e9e9-fe16-4096-b21b-1cb0861cb749)


**Tenements Reports - General Summary**

- Summarises drilling activity, site locations, and sample data in relation to tenement boundaries.
- Highlights records that fall outside their expected or valid tenements.
- Presents peak assay results by dataset to support compliance visibility.
- Helps ensure exploration data is accurately attributed for tenement compliance and reporting.

![Audit Report v1.1 - Release Notes - Step 31.png](media://a70ad882-fa40-49c5-8f78-6b297ec5f8ec)


**Tenements Reports - DH Summary**

- Shows distribution of drillholes and drilled metres across tenement areas.
- Highlights drillholes or drilled metres that fall outside expected tenement boundaries.
- Ranks tenements by drilling intensity for clearer activity insights.
- Supports tenement compliance and governance by ensuring accurate attribution of drillhole data for reporting and regulatory assurance.

![Audit Report v1.1 - Release Notes - Step 32.png](media://433cc50f-66c2-4e59-86f5-c93ae79ee9b0)


**Tenements Reports - DH Max Assays**

- Presents the highest recorded values for selected elements, grouped by dataset and lease.
- Enables comparison of peak assay outcomes across tenements.
- Supports reporting, validation, and high‑level assessment of significant analytical results within tenement boundaries.

![Audit Report v1.1 - Release Notes - Step 33.png](media://029427b2-de75-47c4-a53b-cc99095d770e)


**Tenements Reports - PT Summary**

- Shows distribution of sites and associated metres across tenements.
- Highlights sites located outside their expected or valid tenements.
- Ranks tenements by site activity for clearer visibility of operational coverage.
- Supports tenement compliance and governance by ensuring point‑based data is accurately attributed for reporting, validation, and regulatory assurance.

![Audit Report v1.1 - Release Notes - Step 34.png](media://3179f01e-8a15-4558-ae5b-f3146b90c985)


**Tenements Reports - PT Max Assays**

- Presents highest recorded values for selected elements, grouped by dataset and lease.
- Enables comparison of peak geochemical results across tenements.
- Supports tenement reporting and validation with a high‑level view of significant assay outcomes from point‑based sampling within tenement boundaries.

![Audit Report v1.1 - Release Notes - Step 35.png](media://3891b214-60cc-4493-acf9-c1651978e301)


**Tenements Reports - LS Max Assays**

- Presents the highest recorded values for selected elements, grouped by dataset and lease.
- Enables comparison of peak geochemical results across different tenements.
- Supports tenement reporting and validation by providing a high‑level view of significant assay outcomes from line‑based sampling within tenement boundaries.

![Audit Report v1.1 - Release Notes - Step 36.png](media://47751ef2-36c7-48d4-9637-4727026cbd4b)


**Tenements Reports - LS Summary**

- Shows distribution of line sites and surveyed metres across tenement areas.
- Compares tenements based on the extent of line‑survey coverage.
- Supports tenement‑level reporting and governance by ensuring line‑based survey data is accurately attributed for compliance, validation, and regulatory assurance.

![Audit Report v1.1 - Release Notes - Step 37.png](media://38b48b4a-13df-4faa-8122-3fa11b6814e2)



---

|  |  |  |  |
| --- | --- | --- | --- |
| **#** | **Component** | **Description** |  |
| **Drill Plod Report** |  |
| 2. | **Drill Plod Report** | - Updated the report to automatically read unit settings (Metres or Feet) from **tblSYSParam**.
- Chart headings now dynamically adjust based on the configured unit type, ensuring reports reflect the correct measurement system for each database.
- Added a left‑side label on charts to clearly indicate which unit of measurement is being used. |  |

> 📝 The units shown in tables and tooltips (m/ft) could not be updated dynamically and will be referred to as “Units”

![Feet PLods Report.png](media://4eb69406-5f01-43be-a89c-481f0233c856)
</details>

<details>
<summary>April 2025</summary>

|  |  |  |
| --- | --- | --- |
| **#** | **Component** | **Description** |
| **PowerBI Audit Report, Drill Plod Report, Drill Hole Form** |
| 1. | **Audit Report** | ·         For MDS 5.x.x we take coordinates from tblVWDHCoordinates (Preferred), for 4.x.x we take coordinates from tblDHColl (NAT) |
| 2. | **Drill Plod Report** | ·         For MDS 5.x.x we take coordinates from tblVWDHCoordinates (Preferred), for 4.x.x we take coordinates from tblDHColl (NAT) |
| 3. | **Drill Hole Form** | ·         For MDS 5.x.x we take coordinates from tblVWDHCoordinates (Preferred), for 4.x.x we take coordinates from tblDHColl (NAT)<br>·         Samples (tblDHSamp) replaced by Assays (tblVWDHAssays) |
</details>

<details>
<summary>September 2025</summary>

| **#** | **Component ** | **Version** | **Description** |
| --- | --- | --- | --- |
| 1 | Drillhole Form | v2.0 | The report has been redesigned to use DirectQuery, eliminating the need for data model refreshes. |
| 2 | Drill Plod | v2.0 | The report has been redesigned to use DirectQuery, eliminating the need for data model refreshes. |
| 3 | Striplog | v2.0 | The report has been redesigned to use DirectQuery, eliminating the need for data model refreshes. |

### ⚠️ Performance Note

When using the **Direct Query** version, the report connects live to your data. Depending on dataset size, some charts and tables may take longer to load.

# Sample Sleuth v2.0
</details>

<details>
<summary>October 2025</summary>

## QAQC v2.1 PowerBI Dashboard

| **#** | **Component ** | **Description** |
| --- | --- | --- |
| 1 | Data Connection | Switched to **DirectQuery** from SQL Server. Live connection may cause delays. |
| 2 | Summary | **Added**: Laboratory Summary, Standard Type Ratio, QC Category Ratio. |
| 3 | QC Results | The report has been redesigned to use DirectQuery, eliminating the need for data model refreshes. |
| 4 | CRM | **Deleted**: CRM Stats page. |
| 5 | Repeats – Chart Filters | **Added**: “Show by” filter to split charts by DataSet, LabCode, QC Category, TEST. |
| 6 | Repeats – Preferred Method | **Deleted**: By Preferred Method. |
| 7 | Repeats – Element Name | **Deleted**: By Element Name. |
| 8 | Repeats – Repeat Code Filter | **Edited**: Now filtered by Original Type = 0. |
| 9 | Repeats – Method (Scatter Plots) | **Edited**: Minor changes to scatter plot visuals. |
| 10 | Repeats – OverRange Filter | **Added**: “Include or Exclude OverRange Results” in Extra Filters. |

### ⚠️ Performance Note

When using the **Direct Query** version, the report connects live to your data. Depending on dataset size, some charts and tables may take longer to load.

## Paginated QAQC v2.0.0.0 PowerBI Dashboard

| **#** | **Component ** | **Description** |
| --- | --- | --- |
| 1 | Filters | **Added:** OverRange filter for *Repeats (by Method)*.   
**Default:** No filter selected. |
| 2 | Summary | **Added:** Laboratory Summary, Standard Type Ratio, QC Category Ratio. |
| 3 | Lab Turnaround | **Edited:** Split line chart by *LabCode*. |
| 4 | CRM | **Edited:** Split line chart by *Method*. |
| 5 | Screen Test | **Removed:** Line chart by Sample Type.   
**Added:** New line chart split by *LabCode*. |
| 6 | Weights | **Removed:** Bar chart.   
**Edited:** Scatterplot charts split by *LabCode*. |
| 7 | Repeats – Preferred Method | **Removed:** By Preferred Method. |
| 8 | Repeats – Element Name | **Removed:** By Element Name. |
| 9 | Repeats – Repeat Code Filter | **Edited:** Now filtered by *Original Type = 0*. |
| 10 | Repeats – Method (Scatter Plots) | **Edited:** Minor changes to scatter plot visuals. |
</details>

<details>
<summary>November 2025</summary>

## Paginated QAQC v2.0.1.0 PowerBI Dashboard

| **#** | **Component ** | **Description** |
| --- | --- | --- |
| 1 | SQL Query | Forced ScreenTest SQL script to take Repeat and Preferred from table “a”  to avoid Ambiguous columns |
</details>