BOM Editing issue

Hi,

this error message is a good hint:

 Incorrect value explanation: "select" is forbidden in where attribute

What you want to do is not possible anymore in newer Aras version due to security restrictions:

https://community.aras.com/f/development/6266/error-when-sql-is-specified-in-where-attribute-in-aml

https://community.aras.com/f/development/3839/error-in-aml

You can customize Aras to allow your specific query. But if you really just want to modify a small amount of items, it´s easier to search for the related_id directly and use this one.

Hello Angelalp,

Thank you for your reply.

Please suggest me. How can i  customize ItemAnalysis.Suppressions.xml for mapping my requirement ?

I  try below. but it is not work. please suggest me.

Regards

Ashok Kumar Yadav

Hi,

since all my years in Innovator I never was forced to use this file. Normally there is always a way to avoid these kind of queries.

According to the xml, you have to create a copy of this template.

I assume you have to but your custom query into the <whereAttribute> tag inside CDATA:

<whereAttribute>
<!-- Add a suppression for Item "where" attribute. NOTE: it uses both @Parameter and @ParametersList -->
<template><![CDATA[

[Part BOM].related_id=(select id FROM innovator.Part WHERE ITEM_NUMBER='424-01-00001' and IS_CURRENT='1')

]]></template>
</whereAttribute>

Maybe this is already enough to make your AML query work.

Hi.......

I am getting same issue after change?

Can you suggest me?

regards

Ashok Kumar Yadav

Are you an subscriber? I think there is an official manual regarding AML security settings.

No I am not subscriber.

Can you help me to suggest me any way to edit BOM by putting item_number ?

<AML>
<Item type="Part BOM" action="edit" where="related_id=(select id FROM innovator.Part WHERE ITEM_NUMBER='424-01-00001' and IS_CURRENT='1') ">
<quantity>9</quantity>
</Item>
</AML>

Regards

Ashok Kumar Yadav

Normally you wouldn´t edit Part BOM directly. In your case it could happen, that multiple BOM items are affected. 

It might be possible to use the keyed_name, but not sure if this query would work:

<Item type="Part BOM" action="edit" where="keyed_name='yourPN' and IS_CURRENT='1') ">

Normally you edit BOM items from the Parent part. Or make a get query first and then use the result for edit.

Normally you wouldn´t edit Part BOM directly. In your case it could happen, that multiple BOM items are affected. 

It might be possible to use the keyed_name, but not sure if this query would work:

<Item type="Part BOM" action="edit" where="keyed_name='yourPN' and IS_CURRENT='1') ">

Normally you edit BOM items from the Parent part. Or make a get query first and then use the result for edit.

Is it possible get  query first and then use the result for edit BOM In Nash?

Because I want edit BOM in Bulk .

Regards

Ashok Kumar Yadav