|
|
This error is raised:
595dbc4c 343143 [http-8080-2] ERROR org.openbravo.base.exception.OBException - Exception when creating query select me from Warehouse as me where ( me.organization in ('E443A31992CB4635AFCAEABE7183CE85','0','19404EAD144C49A0AF37D54377CF452D','B843C30461EA4501935CB1D125C9C25A') and exists (select 1 from ProductStockView as e left join e.storageBin as join_0 left join join_0.warehouse as join_1 left join e.product as join_2 where ((( upper((COALESCE(to_char(join_0.searchKey),''))) like upper(:alias_0) escape '|' and upper((COALESCE(to_char(join_1.name),''))) like upper(:alias_1) escape '|' )) and e.organization in ('E443A31992CB4635AFCAEABE7183CE85','0','19404EAD144C49A0AF37D54377CF452D','B843C30461EA4501935CB1D125C9C25A') ) and (e.active='Y' and ( ('169' in ('800051', '800052', '800096') and e.product.production = true and e.stocked = false) or ('169' in ('170') and e.product.stocked = true) or '169' not in ('800051', '800052', '800096','170'))) and e.warehouse = me and e.organization.id in ('E443A31992CB4635AFCAEABE7183CE85', '4735EFF4E48E42A7A84E9B5AEFDBAFDD', '0', 'DC206C91AA6A4897B44DA897936E0EC3', '7BABA5FF80494CAFA54DEBD22EC46F01', 'BAE22373FEBE4CCCA24517E23F0C8A48', '19404EAD144C49A0AF37D54377CF452D', 'B843C30461EA4501935CB1D125C9C25A', '2E60544D37534C0B89E765FE29BC0B43') and e.client.id in ('23C59575B9CF467C9620760EB255B389', '0')) )order by me.name
org.hibernate.QueryException: could not resolve property: warehouse of: ProductStockView [select me from Warehouse as me where ( me.organization in ('E443A31992CB4635AFCAEABE7183CE85','0','19404EAD144C49A0AF37D54377CF452D','B843C30461EA4501935CB1D125C9C25A') and exists (select 1 from ProductStockView as e left join e.storageBin as join_0 left join join_0.warehouse as join_1 left join e.product as join_2 where ((( upper((COALESCE(to_char(join_0.searchKey),''))) like upper(:alias_0) escape '|' and upper((COALESCE(to_char(join_1.name),''))) like upper(:alias_1) escape '|' )) and e.organization in ('E443A31992CB4635AFCAEABE7183CE85','0','19404EAD144C49A0AF37D54377CF452D','B843C30461EA4501935CB1D125C9C25A') ) and (e.active='Y' and ( ('169' in ('800051', '800052', '800096') and e.product.production = true and e.stocked = false) or ('169' in ('170') and e.product.stocked = true) or '169' not in ('800051', '800052', '800096','170'))) and e.warehouse = me and e.organization.id in ('E443A31992CB4635AFCAEABE7183CE85', '4735EFF4E48E42A7A84E9B5AEFDBAFDD', '0', 'DC206C91AA6A4897B44DA897936E0EC3', '7BABA5FF80494CAFA54DEBD22EC46F01', 'BAE22373FEBE4CCCA24517E23F0C8A48', '19404EAD144C49A0AF37D54377CF452D', 'B843C30461EA4501935CB1D125C9C25A', '2E60544D37534C0B89E765FE29BC0B43') and e.client.id in ('23C59575B9CF467C9620760EB255B389', '0')) )order by me.name] |
|