Question

Retrieve child objects by association - Self association

1

I have a entity with self-association that have an object of the same entity as its parent or children. I do not want to commit changes on this entity. I would like to retrieve a list of children objects associating from parent entity. Using association I am able to retrieve single parent object not a list of children's. Whereas using retrieval from the database I am able to retrieve a list of children's. Could you please suggest me a way to retrieve a list of child objects using association not from the database.

asked 2016-07-18

Pranay Kondai

3 answers

Eric Tieniber · Answer 1 · 2016-07-18

I think this might be possible in Java, just not directly in a microflow. The documentation for core.retrieveByPath says:

retrieveByPath(IContext context, IMendixObject mxObject, String path, boolean isSelfAssociationChild)

Retrieves objects using the given object and path.

I haven't tested it, but that boolean would seem to indicate that you could "reverse" the self-association while retrieveing.

Mike Kumpf · Answer 2 · 2016-07-18

Pranay,

Please see this article for a walk through on how to do this. While it is for Mendix 5 - this approach has not changed in version 6.

Mike

Bart Rikers Oud · Answer 3 · 2016-07-19

What I did in the same situation was create a dummy entity instead of a self-reference.