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

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



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


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