How to tell what content user has deleted ?
User reports loosing absences on their RTC profile. Looking at the REPOSITORY.CONTRIBUTOR_ABSENCES table only 1 row exists for user raising the issue. Looking further I notice a REPOSITORY.DELETED_ITEMS and query that table on the UUID of the user. There are 25 rows clustered around a few dates, but the ITEM_TYPE_DBID are 54,73 and 109.
Do any/all of those relate to absences ?
Thanks.
Do any/all of those relate to absences ?
Thanks.
2 answers
Ok, by observation I think ITEM_TYPE_DBID = 54 is absence. I did the following:
db2 "select item_type_dbid,count(*) from repository.deleted_items where deleted_by='UUID of me' group by item_type_dbid"
Got:
ITEM_TYPE_DBID 2
-------------- -----------
2 242
21 1
28 247
39 1
40 1
43 1
I then deleted the 1 absence on my profile and re-ran the above query:
ITEM_TYPE_DBID 2
-------------- -----------
2 242
21 1
28 247
39 1
40 1
43 1
54 1
[ uid of me from db2 "select item_id from repository.contributor where email like 'ramerk%'" ]
db2 "select item_type_dbid,count(*) from repository.deleted_items where deleted_by='UUID of me' group by item_type_dbid"
Got:
ITEM_TYPE_DBID 2
-------------- -----------
2 242
21 1
28 247
39 1
40 1
43 1
I then deleted the 1 absence on my profile and re-ran the above query:
ITEM_TYPE_DBID 2
-------------- -----------
2 242
21 1
28 247
39 1
40 1
43 1
54 1
[ uid of me from db2 "select item_id from repository.contributor where email like 'ramerk%'" ]
We do not support accessing the RTC database directly. If users are losing absences then please raise a defect against RTC and the problem can be addressed there.
Thanks
Thanks
Comments
All I wanted to know is do those ITEM_TYPE_DBID relate to absences. I'm not about updating the database, etc. I just want to tell the user whether or not the deletions are absences; I already can associate the deletions with the user's account.
Also, as v4 is on our close horizon I don't see the point in opening a defect on the current version.