Parent Record Dependancy

Post Reply
rmcdonald
Investor
Investor
Posts: 417
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud
Contact:

Parent Record Dependancy

Post by rmcdonald »

When using Entity drop-down list (ajax) we are trying to ensure that the only items that display are from the same parent or higher level parent entity, but whenever we put conditions in the mysql field (even bringing the ID of the parent records through to be able to match using fields) we get an empty list.
User avatar
support
Site Admin
Posts: 6147
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Parent Record Dependancy

Post by support »

Not clear. Please provide entites structure and condition that you are using.
rmcdonald
Investor
Investor
Posts: 417
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud
Contact:

Re: Parent Record Dependancy

Post by rmcdonald »

Hard to provide the example as we have tried many things.

If you use the entity ajax field with no condition it will show us ALL items in the entity however both the entity where the field with the condition is and the entity we are linking too are sub entities and we want the ajax field to have a condition that only shows records that have the same parent.

e.parent_id = parent_id or similar ?
User avatar
support
Site Admin
Posts: 6147
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Parent Record Dependancy

Post by support »

Try e.parent_item_id=xxx
rmcdonald
Investor
Investor
Posts: 417
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud
Contact:

Re: Parent Record Dependancy

Post by rmcdonald »

just cant seem to get that to work , the list is empty when we put the condition in
User avatar
support
Site Admin
Posts: 6147
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Parent Record Dependancy

Post by support »

Show me your condition.
Post Reply