Error when SQL is specified in "where" attribute in AML

NiNi — Fri, 30 Aug 2019 17:25:41 GMT

Hi Team,

There is AML that seems to have never been an error before, but somehow it becomes an error.
* Aras version is 11.0SP15.

For example, I remember that SQL could be written in the where attribute like the following AML and IOM code.
At the very least, I was able to execute AML / IOM code written in this way in my previous development (V11.0SP8 environment).
===<AML>========================================
<Item type='CAD Structure' action='get' where="innovator.[CAD_Structure].source_id in (select id from innovator.[CAD] where name = 'TestName')">
</Item>
================================================
===<IOM code>=====================================
Item applyItm = inn.newItem("CAD Structure", "get");
applyItm.setAttribute("where", "[CAD_Structure].source_id in (select id from innovator.[CAD] where name = 'TestName')");
Item resultItm = applyItm.apply();
================================================

However, when I run this on my current development project, I get the following error:
##############################################################
<SOAP-ENV:Envelope xmlns:SOAP-ENV='schemas.xmlsoap.org/.../'>
  <SOAP-ENV:Body>
    <SOAP-ENV:Fault xmlns:af='www.aras.com/InnovatorFault'>
      <faultcode>SOAP-ENV:Server.ItemAnalysisException</faultcode>
      <faultstring><![CDATA[Item Analysis Error. Some Items have incorrect attribute/property values syntax. See details for more information.
Details:
Incorrect value: "where="innovator.[CAD_Structure].source_id in (select id from innovator.[CAD] where name = 'TestName')"". Incorrect value explanation: "select" is forbidden in where attribute.
Incorrect value: "where="innovator.[CAD_Structure].source_id in (select id from innovator.[CAD] where name = 'TestName')"". Incorrect value explanation: Item hasn't property referred to column with name "name"
]]></faultstring>
      <detail>
        <af:legacy_detail><![CDATA[Item Analysis Error. Some Items have incorrect attribute/property values syntax. See details for more information.
Details:
Incorrect value: "where="innovator.[CAD_Structure].source_id in (select id from innovator.[CAD] where name = 'TestName')"". Incorrect value explanation: "select" is forbidden in where attribute.
Incorrect value: "where="innovator.[CAD_Structure].source_id in (select id from innovator.[CAD] where name = 'TestName')"". Incorrect value explanation: Item hasn't property referred to column with name "name"
]]></af:legacy_detail>
        <af:exception message='Item Analysis Error. Some Items have incorrect attribute/property values syntax. See details for more information.
Details:
Incorrect value: "where="innovator.[CAD_Structure].source_id in (select id from innovator.[CAD] where name = 'TestName')"". Incorrect value explanation: "select" is forbidden in where attribute.
Incorrect value: "where="innovator.[CAD_Structure].source_id in (select id from innovator.[CAD] where name = 'TestName')"". Incorrect value explanation: Item hasn't property referred to column with name "name"
' type='Aras.Server.Core.ItemAnalysisException' />
      </detail>
    </SOAP-ENV:Fault>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

##############################################################

I get an error message saying that "select" is forbidden in where attribute.
I've seen errors like this for the first time.

What should I do?
Is there something wrong with the syntax ? Is the Aras environment bad ? Has Aras AML / IOM rules changed ?

Regards

How to check from_state, to_state in onBeforePromote/onAfterPromote event method

NiNi — Tue, 20 Aug 2019 15:35:49 GMT

Hi Team,

I know that I can check from_state & to_state in 'Pre Method' & 'Post Method' event of Life Cycle Transition by check context item.

Is it possible to check from_state / to_state even in onBeforePromote / onAfterPromote event method ?

How to define message(e.g. error message)

NiNi — Tue, 30 Jul 2019 06:29:22 GMT

Hi Team,

In Aras Method, when displaying error/information/ confirmation message etc. in the message box to the user,
the following is considered as the definition place of the message:
1) UserMessage Item
... UserMessage ItemType exists.
Not shown in TOC after Aras installation.
2) ui_resources.xml
... For example, it exists in "{Aras Installed Dir}\Innovator\Client\Solutions\PLM\xml\".
Of course, when customizing by myself, I prepare ui_resources.xml in another folder.

I have used both before.
But, I want to know the merits and demerits of each.
Should I separate those depending on situation ?

Purpose of external_~ properties of CAD Document Item

NiNi — Wed, 03 Jul 2019 10:49:55 GMT

Hi Team,

I am interested in developing a CAD Connector for a certain CAD.

I found that there are "external_owner" and "external_type" properties in CAD Document Item type.
What is the purpose of these properties ? How should we use these properties ?

Ask A Question I

Wed, 03 Jul 2019 10:49:55 GMT

Ask a question in a forum.

NiNi さんの グループ アクティビティ

Error when SQL is specified in "where" attribute in AML

How to check from_state, to_state in onBeforePromote/onAfterPromote event method

How to define message(e.g. error message)

Purpose of external_~ properties of CAD Document Item

Ask A Question I

NiNi さんのグループアクティビティ