Skip to Content
0
Former Member
Nov 06, 2008 at 10:18 AM

BP Properties Query

863 Views

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