Try ERPNext Try Frappe Cloud Buy Support Partners Foundation

Dynamic Link in Query Report

Is it possible to set Dynamic Link in Query Report?

reference_name AS “Document:Dynamic Link/reference_doctype:150”,

e.g.

SELECT max(modified) AS "Date Time:Datetime:150",
       reference_doctype AS "DocType:Link/DocType:150",
       reference_name AS "Document:Dynamic Link/reference_doctype:150",
       workflow_state AS "Workflow State:Link/Workflow State:150",
       owner AS "Expected User:Link/User:150",
       modified_by AS "Completed By:Link/User:150"
 FROM `tabWorkflow Action`
 GROUP BY  reference_doctype, reference_name, workflow_state,
 owner, modified_by