Forum Discussion

NiNi's avatar
NiNi
Ideator I
7 years ago
Solved

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

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 a...
  • cogres's avatar
    cogres
    7 years ago

    Hi NiNi,

    a security update in one of the version 11 Service Packs made it so that you cannot simply use all sorts of SQL in where-clauses any more. You will need to work with whitelists to re-enable this. See this community post for further details. I have never used it myself, I simply remembered the linked community post.

    Cheers,

    C

cogres's avatar
cogres
Ideator I
7 years ago

Hi NiNi,

a security update in one of the version 11 Service Packs made it so that you cannot simply use all sorts of SQL in where-clauses any more. You will need to work with whitelists to re-enable this. See this community post for further details. I have never used it myself, I simply remembered the linked community post.

Cheers,

C

  • NiNi's avatar
    NiNi
    Ideator I
    7 years ago

    Hi cogres,

    Thank you. 

    I finally understand the reason.
    It is described in "Aras Innovator 11.0-AML Security Settings.pdf".
    In V11.0SP9 or later, the use of SQL in AML on the Clinet side was restricted.