Forum Discussion

Jacky_Phan's avatar
Jacky_Phan
Ideator I
6 years ago

Is this possible if get an ItemType inside another query within AML?

I have two ItemTypes Person and Address. There is a property Person.address_id that stores the config_id of an address, for a particular purpose it is just a string type, not refer ItemType. I use be...
AML
Jayrajvh's avatar
Jayrajvh
Ideator I
6 years ago

Can you try this?

<Item type='ADDRESS' action='get' where="[ADDRESS].id in (select address_id from innovator.PERSON where id= 'abcdxyz')"></Item>

Jacky_Phan's avatar
Jacky_Phan
Ideator I
6 years ago

Hi Jay,

The id= 'abcdxyz' is just an example, it should be passed in as an parameter in parent select statement: address_id