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

[Former Member]

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] )

[Former Member · Accepted solution]

Hi Revital,

One way to implement this functionality would be to use a UI API that verifies the values while filling the items in the Matrix. For this you would need a little programming knowledge but no extra license.

There is a lot of information including Code Samples in the SDK Package delievered with every patch of Business One.

Kind Regards,

Friederike Mundt

[Former Member]

I had same goal with you long times ago. However, it seems no options to break the wall.

[Former Member]

As far as I know, the limitation for this query is: you can only get the first line, not the other. This is hard limitation. Hence, you may only based your approval on header table not the detail row table. Unless the first line is good enough for you.

Thanks,

Gordon

[Former Member]

Thanks Gordon,

I am looking for a way to bypass this limitation.

Are you familiar with any workaround?

Thanks again

Revital

[Former Member]

Hi!

Where do you run Query . Try to run in approval procedures

Thanks!

[Former Member]

Hi,

I am running it from Approval procedure

Thanks

Revital