Data entity virtual fields are not exported

(0) Share

Report

Posted on by Nick_Yurov

Dear experts,

I have added 2 virtual fields to standard data entity EcoResProductAttributeValueV2Entity.

Their properties:

and

I created an extension class for data entity and extended the postLoad() method to populated my new virtual fields.

After that i have built my model with DB sync.

But, when I try to use this data entity for export operation, my new virtual fields are not exported at all.

And I cannot see my new fields when i open this data entityt from DMF workspace.

Though i have refreshed data entities with this:

Can you advise me of what I should do to fix this issue?

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Martin Dráb 240,546 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You didn't mention adding the fields to the staging table - isn't it the main problem?

Was this reply helpful? Yes No
Nick_Yurov 60 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

As far as I was developing virtual fields according to this instruction docs.microsoft.com/.../data-entity-computed-columns-virtual-fields, there was not a single word about the fact, that virtual fields must be linked to staging table fields. Must they?

Was this reply helpful? Yes No
huijij 19,813 on at

Like (0)

Report
Copy link

Link copied!

Hi Nick,

Have you completed these steps Exposing custom fields on data entities to expose custom fields on the entity?

Was this reply helpful? Yes No
Nick_Yurov 60 on at

Like (0)

Report
Copy link

Link copied!

Hi Judy,

No, I haven't completed these steps because I am not using custom fields on data entity. I am trying to output virtual fields on standard data entity.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 240,546 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

All right, so we've found the key problem.

If you want to use your fields in data management (export & import), you need to add them to the staging table. If you have no corresponding fields in the staging table, the data can't be exported to staging and therefore can't be included in the exported file.

Just for completeness - you wouldn't need fields in the staging table if you didn't want to use data management. You could still access them via OData, for example.

Was this reply helpful? Yes No
Nick_Yurov 60 on at

Like (0)

Report
Copy link

Link copied!

Thank you, Martin. I really appreciate your help. I should have figured this out by myself, because on this data entity UnitOfMeasure is also a virtual field and it was exported successfully.

Was this reply helpful? Yes No