Update parent audit when child is updated : Portal

Start a new topic

Answered

Update parent audit when child is updated

Asha.ramegowda

started a topic 12 months ago

Hello,

Is there a way to update "UpdateDate" attribute of parent entity when child entity is updated from semarchy application ?

Thanks,

Asha

Best Answer

Stéphanie FOURRIER said 12 months ago

Hi Asha,

UpdateDate is a technical attribute that stands for an actual database update, which is not the case for a parent record when one of its child records is updated.

My proposal to answer your needs would be to display a calculated field on your forms and collections, that will use a lookup expression. This could look like this:

lookup
    max UpdateDate
    from <child_entity_role>
end

I hope this helps.

Stéphanie.

1 Comment

Stéphanie FOURRIER

said 12 months ago

Answer

Hi Asha,

UpdateDate is a technical attribute that stands for an actual database update, which is not the case for a parent record when one of its child records is updated.

My proposal to answer your needs would be to display a calculated field on your forms and collections, that will use a lookup expression. This could look like this:

lookup
    max UpdateDate
    from <child_entity_role>
end

I hope this helps.

Stéphanie.