Hi Folks,
I use this query to find duplicate package references:
select sqp.name, duplicates.number from (
select substring(name from '(([0-9]+.*)*[0-9]+)') as number
from stock_quant_package
group by number
having count(1) > 1
) duplicates inner join stock_quant_package sqp on substring(name from '(([0-9]+.*)*[0-9]+)') = duplicates.number order by duplicates.number;
How can I write a module to add this query as a filter for packages view in Inventory?
Thanks in advance.