Forum Discussion

Ashu_Aswal's avatar
Ashu_Aswal
New Contributor III
7 months ago

How to get the audit for comments

Hi , In one of my report the user want to show a column for audit which will show who commented for that variance explanation intersection, can you please help me to get this audit. Please let me k...
Cube View
Reports
  • FredLucas's avatar
    FredLucas
    7 months ago

    Hi Ashu_Aswal,

    You could achieve that by creating a dynamic calc member and having it returning that info for the required POV using the following api:

    Dim objDataAttachmentList As DataAttachmentList = api.Data.GetDataAttachments(memberScript, includeFileBytes, startRowIndex, pageSize)
objDataAttachmentList.Items.Item(0).LastEditedUserName

    Note: it is important that you use one of the text view members e.g.: V#Annotation to show that info.

FredLucas's avatar
FredLucas
Contributor III
7 months ago

Hi Ashu_Aswal,

You could achieve that by creating a dynamic calc member and having it returning that info for the required POV using the following api:

Dim objDataAttachmentList As DataAttachmentList = api.Data.GetDataAttachments(memberScript, includeFileBytes, startRowIndex, pageSize)
objDataAttachmentList.Items.Item(0).LastEditedUserName

Note: it is important that you use one of the text view members e.g.: V#Annotation to show that info.

  • Ashu_Aswal's avatar
    Ashu_Aswal
    New Contributor III
    6 months ago

    Thank you very much FredLucas for this solution. This worked perfectly.