Hi Claudia
We cannot put conditions between fields - it's always an and in Query. I would suggest submitting a request in the Ideas portal for this feature, if it's not there already - and if so, you can vote for it.
Not 100% sure on your scenario, but have you tried a left outer join? It may help.
Best Regards,
Sigrid
------------------------------
Sigrid Kok
*Precisely Software Inc.
------------------------------
Original Message:
Sent: 05-09-2025 05:06
From: Claudia Nordhorn
Subject: Query Template
Hello,
I'm trying to create a query according to LFB1 and then join table BSAK/BSIK.
I need the result from both BSAK/BSIK (even if it's empty in one table for respective vendor)
In the criteria (snapshot attached) I need an "OR" instead of "AND".
Is this possible? And when not may somebody has another solution for me?
Many thanks in advance.
------------------------------
Claudia Nordhorn
Master Data Governance
HAVI Logistics Business Services GmbH
Duisburg
------------------------------