Is there a way to update "UpdateDate" attribute of parent entity when child entity is updated from semarchy application ?
Thanks,
Asha
Best Answer
S
Stéphanie FOURRIER
said
almost 3 years 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
S
Stéphanie FOURRIER
said
almost 3 years 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
Asha.ramegowda
Hello,
Is there a way to update "UpdateDate" attribute of parent entity when child entity is updated from semarchy application ?
Thanks,
Asha
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> endI hope this helps.
Stéphanie.
Stéphanie FOURRIER
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> endI hope this helps.
Stéphanie.
-
Recover Deleted(soft Delete) Record and Configure in Application
-
How Can I Trigger Enricher or Sql Procedure when deleting?
-
Read CSV files from AWS S3
-
Find SQL Statements Generated for Match Rules
-
Is it possible to disable specific steps of an Integration Job?
-
Reset the Override on Many Records Through the Interface or By Script
-
PL/SQL Procedure With B_CREDATE and B_UPDDATE Not Mapped or Loaded, Columns Will Be Null
-
LoadDataRecord contains non persitable expressions when trying to publish Data using the Rest API
-
Data notification on Record deletion
-
How to reference a sequence in a custom function, which I will then populate as an attribute in Semarchy?
See all 59 topics