From Wdata, you can include details about framework disclosures and standards from ESG Explorer in queries, such as for those connected to a source ESG Program's metrics.
Add ESG Explorer content to a query
To include framework disclosures and standards from ESG Explorer in a Wdata query:
- From the query's Sources panel, click New source, and select ESG, ESG explorer.
- Select All Explorer references, and click Add.
- From the Sources panel, specify how to use the ESG Program's columns in the query:
- To use columns as results in Builder, select them, and then select Add to fields or drag them to the Fields tab.
- To use columns as filters in Builder, select them, and then select Add to filters or drag them to the Filters tab.
- To include a column in the query's statement in SQL, right-click it and select Add to query.
- To use columns as results in Builder, select them, and then select Add to fields or drag them to the Fields tab.
- Create the query as necessary.
ESG Explorer source columns
When you include All Explorer references as a source, you can use these columns from ESG Explorer in the query as text:
| Column | Description |
|---|---|
| Framework | The framework that issued the content, such as GRI or SASB |
| Name | The unique name of the content, as assigned by Workiva |
| Display name | The name of the content as it appears in ESG Explorer |
| Version number | The numeric ordered value of the content's version, from its URL in ESG Explorer
Tip: This number appears at the end of the content's URL in ESG Explorer, such as
|
| Title | The full title of the disclosure or standard, where applicable |
| Content | The long-form content of the disclosure or standard |
| Path | The path to navigate to the content in ESG Explorer |
| Explorer ID | The name and version of the content, such as GRI_2016 or 100_2016 |
| Status | The status of the content — Current, Deprecated, or Pending |
Include ESG Explorer content with ESG Program data in query results
In a query, you can supplement ESG Program data with ESG Explorer content from Builder .
- In the query, add the ESG Program and All Explorer references as sources.
- On the Relationships tab, click Add another join (if necessary), and move the ESG Program's Framework column from the Sources panel to the left field of the join.
- In the right field of the join, select Calculated field.
- To include the Name column from All Explorer references in the calculation, do one of these from the Sources panel:
- Move the Name column to Included columns on the Field properties panel.
- Right-click the Name column, and select Include in calculation.
- From the Field properties panel, enter the calculation
CONCAT('%"', {1}, '"%'), and click Apply. - From the Relationships tab, select Left join between the sources, and select the Like condition between the columns.
- Click Save.