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.
List of records by MySql query doesn't work on child entity
- support
- Site Admin
- Posts: 6222
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: List of records by MySql query doesn't work on child entity
In condition you have to use
Code: Select all
[381] in (select ...)
-
- Posts: 48
- Joined: 13 Jul 2019, 23:13
- Name: Pico Seno
- Location: Jakarta, indonesia
- Company Name: Banda Tech
- Contact:
Re: List of records by MySql query doesn't work on child entity
Thank you Sergey.