[
https://issues.jboss.org/browse/TEIID-4397?page=com.atlassian.jira.plugin...
]
Jan Stastny edited comment on TEIID-4397 at 11/24/17 4:07 PM:
--------------------------------------------------------------
[~shawkins] What are the semantics for using $it?
Following example:
* Employee (employee_id, name, manager_id) is a entity with self-relation.
* I have
| employee_id | name | manager_id |
| 1 | 'president'| null |
| 2 | 'vice-president'| 1 |
| 3 | 'director'| 2 |
| 4 | 'manager1'| 3 |
| 5 | 'manager2'| 3 |
| 6 | 'employee1'| 4 |
| 7 | 'employee2'| 4 |
| 8 | 'employee3'| 4 |
| 9 | 'employee4'| 5 |
| 10 | 'employee5'| 5 |
| 11 | 'employee6'| 5 |
* now for query
{code}http://localhost:8080/odata4/olingo_basic/Source/Employee?$expand=Employee_FK0($filter=$it/name%20eq%20%27president%27){code}
* the result is that only Employee 'president' is expanded
* Is this what is expected?
Either way I wasn't able to find this in docs. Generally speaking the docs on OData
topic are not very helpful as far as supported functionality is concerned.
Second question, is this applicable to $expand=* usage?
was (Author: jstastny):
[~shawkins] What are the semantics for using $it?
Following example:
* Employee (employee_id, name, manager_id) is a entity with self-relation.
* I have
| employee_id | name | manager_id |
| 1 | 'president'| null |
| 2 | 'vice-president'| 1 |
| 3 | 'director'| 2 |
| 4 | 'manager1'| 3 |
| 5 | 'manager2'| 3 |
| 6 | 'employee1'| 4 |
| 7 | 'employee2'| 4 |
| 8 | 'employee3'| 4 |
| 9 | 'employee4'| 5 |
| 10 | 'employee5'| 5 |
| 11 | 'employee6'| 5 |
* now for query
{code}http://localhost:8080/odata4/olingo_basic/Source/Employee?$expand=Employee_FK0($filter=$it/name%20eq%20%27president%27){code}
* the result is that only Employee 'president' is expanded
* Is this what is expected?
Either way I wasn't able to find this in docs. Generally speaking the docs on OData
topic are not very helpful as far as supported functionality is concerned.
Allow $it to be used in expand
------------------------------
Key: TEIID-4397
URL:
https://issues.jboss.org/browse/TEIID-4397
Project: Teiid
Issue Type: Sub-task
Components: OData
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.1, 8.12.x-6.4
It should be possible to use $it in expand for correlated references.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)