Hello!
I want to query for Business Partners based on the properties input by the user.
For eg, I have set property 64 as "fuses".
I want to query for all BP's that have fuses checked on user input. I want the user to input the name since I'd be using many properties and I do not want to create multiple queries for each of them.
The erroneous query that I am using is
SELECT T0.[GroupCode], T0.[CardCode], T0.[CardName], T0.[GroupCode], T0.[CntctPrsn], T0.[E_Mail] FROM OCRD T0 , OCQG T1 WHERE T1.[GroupName] = '[%0]
'
The query above simply lists out all the BP's. I only want the BP's listed where the property is checked.
I need help on this.
Prajwal