List of records by MySql query doesn't work on child entity

[pico]

I have this SLA (36) entity as child of Customer entity, which every SLA records should be listed when the customer selected in customer field of Work Order form.

Apparently when I use the [parent_item_id] it always return 0

Then I change the query using select → it works!

Then another issue came up → when I added record to the entity_36, it broke again. Says it doesn't handle more than 1 record.

==============================


However, it works just fine when I change the structure, moved the SLA to the top level.
I think this is a legit bug.

[support]

In condition you have to use

Code: Select all

[381] in (select ...)

[pico]

Thank you Sergey.