Archived User Group Membership Table

[shahiedsali]

Hello guys, 

I have this custom script that archives user group memberships (sys_user_grmember). The script works, as it does moves the group membership records to the archived table (ar_sys_user_grmember). However, when I refer to the archived table (ar_sys_user_grmember), the 'user' and 'group' fields are empty. But looking into the XML, it does have the 'user' and 'group' information. Is there something I have to configure in order for it to have the referenced values in the 'user' and 'group' fields? Any help will be greatly appreciated! 😭

Custom script:

Archived user group membership table (ar_sys_user_grmember):

XML:

System Definitions > Tables > Archive Group Member:

[Tanushree Maiti]

Are you able to view user and group field value in the archive table?

If No , Just check if you have any ACL like

ar_sys_user_grmember.user

ar_sys_user_grmember.group 

If yes, check if that ACL causing the issue 

[shahiedsali · Accepted solution]

It was actually pointing to a 'test' archive rule to execute the archival of the group. Once I deactivated that 'test' archive rule, it will point to the 'correct' archive rule. Then, the user and group fields were filled with the reference fields required. Thanks everyone.