0 votes
210 views

In a product system, the statistics tab shows that there are a couple of links with multiple possible providers. Is there a way to quickly identify which links this refers to? Is there a way to access a list, for instance, of these links? I'm open to all solutions including those using Python through the IPC. Thank you!

in openLCA by (470 points)
edited by

1 Answer

+1 vote
by (132k points)

Assuming the possible provider products are all quantative reference of the respective providers this will give you the name and ID of the processes, executed in openLCA (as sql):

select name, ref_id, count(f_quantitative_reference) as multiple_providers from tbl_processes group by name, ref_id having
count(f_quantitative_reference) > 1

This could be expanded to give you also the name and ID of the product or waste.

...