Unable to fetch values from expand entity in MDK - SAP Asset Manager 2305 Application.

[nalineepriyaeskala]

Hi MDK Experts,

We have defined and created a navigation for the MyWorkOrderHeaders entity set i.e.,ZXXX_Nav.
When we try to run the query in the gateway client also it works but when I try to query it by using the expand property or / it does not show any value, or it shows undefined.

const query1 = `$expand=ZXXX_Nav&$filter=ZXXX_Nav/ZOrderId eq '${context.binding.OrderId}'&$top=1`;
const query2 = `$expand=ZXXX_Nav&$filter=OrderId eq '${context.binding.OrderId}'`;

When I try to read the service and pass the query and put the result in the alert box the ZXXX_Nav is empty and does not show any fields/properties.

Can you please help me out here?

[bill_froelich]

Since you mention Asset Manager, most likely the entity set the navigation property refers to is not part of the offline store so the data isn't available offline.  Please ensure your offline initialization (and download depending on how you have it configured) includes the entity set referenced by the navigation property.  You may need to run your download or reset the client to reinitialize the offline store.

You can also use ilodata with the UDB files to verify if the data is available offline as expected.

[nalineepriyaeskala]

We have regenerated and uploaded the offline initialization, and it also includes the custom entities referenced by the navigation property, but we still cannot see data in the application.

[bill_froelich]

I would suggest then that you extract the UDB files from a branded client (simulator/emulator) where you have the SecureDatabaseEncryptionKey set to false to enable you to open them in ilodata to inspect and confirm your offline data download results