Created attachment 1294735 [details]
All_Customers OData4 metadata

Description of problem:
Unable to use $expand using OData v4

Version-Release number of selected component (if applicable):
6.3.5

How reproducible:


Steps to Reproduce:
1. Setup Financials VDB (https://github.com/DataVirtualizationByExample/DVWorkshop)
2. http://localhost:8080/odata4/Financials/All_Customers/ACCOUNT(19980002)?$expand=CONSTRAINT_E4&$format=json

Actual results:
{
"error": {
"code": null,
"message": "Fk not found"
}
}

3. Using OData v2 URL http://localhost:8080/odata/Financials/All_Customers.ACCOUNT(19980002)?$expand=All_Customers.CUSTOMER&$format=json

Actual results

{
"d": {
"__metadata": {
"uri": "http://localhost:8080/odata/Financials/All_Customers.ACCOUNT(19980002L)",
"type": "All_Customers.ACCOUNT"
},
"ACCOUNTID": "19980002",
"CUSTOMERID": "CST01002",
"ACCOUNTTYPE": "Personal",
"ACCOUNTSTATUS": "Active",
"DATEOPENED": "/Date(886291200000)/",
"DATECLOSED": null,
"CUSTOMER": {
"__metadata": {
"uri": "http://localhost:8080/odata/Financials/All_Customers.CUSTOMER('CST01002')",
"type": "All_Customers.CUSTOMER"
},
"CUSTOMERID": "CST01002",
"FIRSTNAME": "Joseph",
"LASTNAME": "Smith",
"MIDDLENAME": null,
"STREETADDRESS": "1234 Main Street",
"STREETADDRESS2": "Apartment 56",
"CITY": "New York",
"STATEPROVINCE": "New York",
"POSTALCODE": "10174",
"COUNTRY": "USA",
"PHONENUMBER": "(646)555-1776"
},
"ACCOUNTHOLDINGS": {
"__deferred": {
"uri": "http://localhost:8080/odata/Financials/All_Customers.ACCOUNT(19980002L)/ACCOUNTHOLDINGS"
}
}
}
}

Expected results:
Similar to OData v2 results

Additional info: