Hi,
I have a requirement of displaying an Audit Trail comparing two arrays; Original and updated as follows:
Original Array:
[Id=15, PS_Username=VGAN, PS_Fullname=Veron Ganguly], [Id=18, PS_Username=CZUCKERT, PS_Fullname=Curt Zuckert], [Id=28, PS_Username=KDUENNHA, PS_Fullname=Karen Duennhaupt], [Id=31, PS_Username=LSWENSON, PS_Fullname=Liz Swenson], [Id=38, PS_Username=POTENKHI, PS_Fullname=Tatiana Potekhina], [Id=40, PS_Username=TCHAN, PS_Fullname=Tiffany Chan], [Id=41, PS_Username=TSTAPLES, PS_Fullname=Tina Staples], [Id=95, PS_Username=MONGEL, PS_Fullname=Geller], [Id=96, PS_Username=CBI, PS_Fullname=Chand]
Updated Array:
[Id=96, PS_Username=CBI, PS_Fullname=Chandler Bing]
So the audit trail should display:
PS_Fullname: Original value: Chand; Updated Value: Chandler Bing
TIA :)
Discussion posts and replies are publicly visible
This may help..
load( local!originalArray: { { Id: 15, PS_Username: "VGAN", PS_Fullname: "Veron Ganguly" }, { Id: 18, PS_Username: "CZUCKERT", PS_Fullname: "Curt Zuckert" }, { Id: 28, PS_Username: "KDUENNHA", PS_Fullname: "Karen Duennhaupt" }, { Id: 31, PS_Username: "LSWENSON", PS_Fullname: "Liz Swenson" }, { Id: 38, PS_Username: "POTENKHI", PS_Fullname: "Tatiana Potekhina" }, { Id: 40, PS_Username: "TCHAN", PS_Fullname: "Tiffany Chan" }, { Id: 41, PS_Username: "TSTAPLES", PS_Fullname: "Tina Staples" }, { Id: 95, PS_Username: "MONGEL", PS_Fullname: "Geller" }, { Id: 96, PS_Username: "CBI", PS_Fullname: "Chand" } }, local!updatedArray: { { Id: 96, PS_Username: "CBI", PS_Fullname: "Chandler Bing" } }, a!forEach( items: local!updatedArray, expression: if( displayvalue( fv!item.Id, local!originalArray.Id, local!originalArray.PS_Fullname, null ) = fv!item.PS_Fullname, {}, { field: "PS_Fullname", oldValue: displayvalue( fv!item.Id, local!originalArray.Id, local!originalArray.PS_Fullname, null ), newValue: fv!item.PS_Fullname } ) ) )