Page 1 of 1

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

Posted: 07 Mar 2022, 15:19
by 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
mysqllistquery-1.png
mysqllistquery-2.png
Then I change the query using select → it works!
mysqllistquery-3.png
mysqllistquery-5.png
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.
mysqllistquery-4.png
==============================


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

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

Posted: 09 Mar 2022, 10:27
by support
In condition you have to use

Code: Select all

[381] in (select ...)

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

Posted: 11 Mar 2022, 14:51
by pico
Thank you Sergey.