Skip to Content
0
Former Member
Apr 12, 2010 at 07:46 AM

Authorization at row level

28 Views

Hi All,

I have a scenario where if a particular user creates a purchase order andhe selects as incorret warehouse, the document should go for approval. I tried the following query but this send any purchase order created fr approval.

SELECT DISTINCT 'TRUE' FROM OPOR T0 INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[WhsCode] ='MS0006'

What could be wrong with this query?

Thanks,

Joseph