Track Changes Report

[Mays]

Hello everyone,
Is there any way I can extract a report for the below “track changes” in excel or PDF or any format ,
I am using frappe v14

I tried the “version” doctype but it is not obvious like the track changes for each user

[NCP]

Hi @Mays,

Please check it.

Thank You!

[Mays]

Hi @NCP ,
I tried the “version” before but it is not so clear for the auditors, they are asking for more clarified report for each user which field edited or adjusted exactly like the track changes ,

[NCP]

I don’t think, It is possible.
Sorry!

[Mays]

Thanks anyway @NCP ,
with the chatGPT I build a query report on top of the “Version” table ,it made the information more readable

SELECT
    v.docname AS "Document Name",
    JSON_UNQUOTE(JSON_EXTRACT(v.data, '$.changed[0][0]')) AS "Changed Field 1",
    JSON_UNQUOTE(JSON_EXTRACT(v.data, '$.changed[0][1]')) AS "Old Value 1",
    JSON_UNQUOTE(JSON_EXTRACT(v.data, '$.changed[0][2]')) AS "New Value 1",
    JSON_UNQUOTE(JSON_EXTRACT(v.data, '$.changed[1][0]')) AS "Changed Field 2",
    JSON_UNQUOTE(JSON_EXTRACT(v.data, '$.changed[1][1]')) AS "Old Value 2",
    JSON_UNQUOTE(JSON_EXTRACT(v.data, '$.changed[1][2]')) AS "New Value 2",
    JSON_UNQUOTE(JSON_EXTRACT(v.data, '$.changed[2][0]')) AS "Changed Field 3",
    JSON_UNQUOTE(JSON_EXTRACT(v.data, '$.changed[2][1]')) AS "Old Value 3",
    JSON_UNQUOTE(JSON_EXTRACT(v.data, '$.changed[2][2]')) AS "New Value 3",
    v.modified AS "Modified Timestamp",
    v.modified_by AS "Modified By"
FROM
    `tabVersion` v
WHERE
    v.ref_doctype = 'Employee'
ORDER BY
    v.modified DESC

[NCP]

Hmm … Nice @Mays.

Thanks for sharing it.

[Mays]

My pleasure