[ https://issues.jboss.org/browse/TEIID-4397?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-4397 at 11/27/17 12:52 PM: ------------------------------------------------------------------ Employee_FK0 is the reverse navigation, FK0 is the forward navigation. Employee?$expand=Employee_FK0($filter=$it/name%20eq%20%27president%27) should mean navigating from the pk. The expected result would expand all employees of an employee who has a name of president. This is functioning as expected. Employee?$expand=FK0($filter=$it/name%20eq%20%27president%27) should mean navigating from the fk. The expected result would expand the manager of employees who have a name of president. This later case is not working correctly. was (Author: shawkins): Employee_FK0 is the reverse navigation, FK0 is the forward navigation. Employee?$expand=Employee_FK0 should mean navigating from the pk - so the iterator would reference the employees. The expected result would expand all employees who have an employee with the name president. Employee?$expand=FK0 should mean navigating from the fk - so the iterator would reference the manager. The expected result would expand all employees who have a manager with the name president. I don't think either of these are working as expected for a self relationship. -- This message was sent by Atlassian JIRA (v7.5.0#75005)