From Wdata, you can include details about content from Sustainability Explorer in Query, such as for those connected to metrics in Sustainability Program.
Add Sustainability Explorer content to a query
To include content from Sustainability Explorer in a Query:
- From the query's Sources panel, click New source, and select Sustainability, Sustainability Explorer.
- Select All Explorer references, and click Add.
- From the Sources panel, specify how to use the source 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.
Sustainability Explorer source columns
When you include All Explorer references as a source, you can use these columns from Sustainability 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 Sustainability Explorer |
| Version number | The numeric ordered value of the content's version, from its URL in Sustainability Explorer
Tip: This number appears at the end of the content's URL, 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 Sustainability 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 |
| Value category | For European Sustainability Reporting Standards (ESRS) content, the type of response required:
Note: If Value category returns no value, the content requires no response. This column returns values for only ESRS content. |
| Requirement status | For ESRS content, whether the response indicated in Value category is mandatory.
Note: If Requirement status returns no value, the response is voluntary, or the content requires no response. This column returns values for only ESRS content. |
Include Sustainability Explorer content with Program metrics in results
From Query, you can use Builder to supplement metrics from Sustainability Program with Sustainability Explorer content:
- In the query, add a Sustainability Program and Sustainability Explorer as sources.
- On the Relationships tab, click Add another join (if necessary), and move the 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.