How to view all "links with multiple possible providers"?

Question

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!

Answer 1

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.