Skip to Content
0
Former Member
Jun 04, 2009 at 02:10 PM

Query that will run on the items matrix and trigger Approval procedure

62 Views

Hello,

We are trying to design an approval procedure whenever an item code appears in a certain UDT.

For example, we have many items in OITM.

We have 50 of those items also in @BIN.

The approval procedure should be triggered only when the document lists one of the items that appear in @BIN.

I am using the following query:

SELECT 'TRUE' where $ [$38.1.0] IN (Select code from [@BIN] )

The problem is that the query would only search on the first row and wouldnu2019t continue to the next rows.

Do you have any idea how to bypass this limitation?

Thanks in advance

Revital

SELECT 'TRUE' where $[$38.1.0] IN (Select code from [@BIN] )