BOM Editing issue
Hello Guys,
I want update Part BOM Quantity By Nash Tool.
Using below AML .
<AML> <Item type="Part BOM" action="edit" where="related_id=(select id FROM innovator.Part WHERE ITEM_NUMBER='424-0...
Forum Discussion
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.
