Skip to Content
0
Former Member
Dec 02, 2011 at 08:32 AM

Query help for filtering 2 fields

24 Views

Experts

I need to filter both Docdate & Cardname after running the query. But i am not getting the expected results. Can anyone help me in solving this.

Following is the query.

T1.[LineStatus], T0.[CANCELED]

FROM OPOR T0

INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry

WHERE T0.[CANCELED] = 'Y' AND t0.CardName >= '[%0]' AND T0.DocDate BETWEEN [%1] and [%2]

group by T1.U_PROJECT,T0.U_PRNO,T0.[DocNum],T0.[DocDate],T0.[CardName],T0.[DocTotal],T0.Comments,T1.[LineStatus], T0.[CANCELED]

regards

Karthik