Download this example as a Jupyter notebook or a Python script.

---

Perform a material impacted substances query

A material impacted substances query is used to identify the substances associated with a material that are impacted by one or more defined legislations.

This example shows how to perform an Impacted Substance query on material records and how to process the results.

Connect to Granta MI

Import the Connection class and create the connection. For more information, see the Getting Started example.

from ansys.grantami.bomanalytics import Connection

server_url = "http://my_grantami_server/mi_servicelayer"
cxn = Connection(server_url).with_credentials("user_name", "password").connect()

Build and run the query

The query is assembled by providing lists of material references and legislations of interest. The query returns the substances that are present in the specified materials and are impacted by the specified legislations.

First specify some constants that contain the material and legislation references to use.

PPS_ID = "plastic-pps-generalpurpose"
PC_ID = "plastic-pc-20carbonfiber"
SIN_LIST = "SINList"
REACH = "Candidate_AnnexXV"

Next import the queries module and build the query with the references in the previous cell.

from ansys.grantami.bomanalytics import queries

mat_query = (
    queries.MaterialImpactedSubstancesQuery()
    .with_material_ids([PPS_ID, PC_ID])
    .with_legislation_ids([REACH, SIN_LIST])
)

Finally, run the query. Passing a MaterialImpactedSubstancesQuery object to the Connection.run() method returns a MaterialImpactedSubstancesQueryResult object.

results = cxn.run(mat_query)
results

<MaterialImpactedSubstancesQueryResult: 2 MaterialWithImpactedSubstances results>

A MaterialImpactedSubstancesQueryResult object contains three properties: impacted_substances_by_material, impacted_substances_by_legislation, and impacted_substances. They provide different views of the impacted substances at different levels of granularity.

View results grouped by material

This property is structured first as a list of MaterialWithImpactedSubstancesResult objects, each of which contains a dictionary of lists of ImpactedSubstance objects keyed by legislation or a single flat list of all substances.

First, you can simplify the structure somewhat because you are only using Material IDs. The following cell creates a dictionary that maps material IDs to lists of substances impacted by the SIN_LIST.

substances_by_material = {}
for material in results.impacted_substances_by_material:
    substances = material.substances_by_legislation[SIN_LIST]
    substances_by_material[material.material_id] = substances

Then use the tabulate package to print a table of the substances and their quantities for the polycarbonate material only.

from tabulate import tabulate

rows = [(substance.cas_number, substance.max_percentage_amount_in_material)
    for substance in substances_by_material[PC_ID]]

print(f'Substances impacted by "{SIN_LIST}" in "{PC_ID}" (5/{len(rows)})')
print(tabulate(rows[:5], headers=["CAS Number", "Amount (wt. %)"]))

Substances impacted by "SINList" in "plastic-pc-20carbonfiber" (5/16)
CAS Number      Amount (wt. %)
------------  ----------------
10124-36-4                 0.6
10325-94-7                 0.6
131-56-6                   1.6
131-57-7                   1.6
15087-24-8                 1.6

View results grouped by legislation

This property merges the results across all materials, resulting in a single dictionary of legislations that contains all impacted substances for all materials.

Again use the tabulate package to print a table of substances, but this time include the substances in all materials, one again limited to the SIN_LIST only.

material_substances_sin = results.impacted_substances_by_legislation[SIN_LIST]
rows = [(substance.cas_number, substance.max_percentage_amount_in_material)
    for substance in material_substances_sin]
print(f'Substances impacted by "{SIN_LIST}" in all materials (5/{len(rows)})')
print(tabulate(rows[:5], headers=["CAS Number", "Amount (wt. %)"]))

Substances impacted by "SINList" in all materials (5/27)
CAS Number      Amount (wt. %)
------------  ----------------
131-56-6                     2
131-57-7                     2
15087-24-8                   2
25973-55-1                   2
27193-28-8

View results as a flat list

This property reduces the granularity further to produce a single flattened list of substances across all legislations for all materials.

The following cell uses the tabulate package to print a table of substances. Because you are using the impacted_substances property, you only have one list of ImpactedSubstance objects, which covers both legislations and both materials.

material_substances_all = results.impacted_substances
rows = [(substance.cas_number, substance.max_percentage_amount_in_material)
    for substance in material_substances_all]
print(f"Impacted substances for all materials and legislations (5/{len(rows)})")
print(tabulate(rows[:5], headers=["CAS Number", "Amount (wt. %)"]))

Impacted substances for all materials and legislations (5/48)
CAS Number      Amount (wt. %)
------------  ----------------
131-56-6                     2
131-57-7                     2
15087-24-8                   2
25973-55-1                   2
27193-28-8