GroupCode description and order in Audit views

Brendan Codrington shared this idea 2 months ago
Idea Logged

Hi, I'm using the GroupCode field (from the ReportFieldTemplate table) in the Audit views to organise fields in a data dictionary per view.


Can you add a table to Audit Views what each GroupCode its relevant group description (folder name) and order per view? Currently I'm renaming and ordering the group code values via an org ref code but it is cumbersome process.


Example report SQL using GroupCode is as follows (ReportView table = "View"):


SELECT DISTINCT TOP 10000


"View"."ViewDescription",


"REPORTFIELDTEMPLATE"."GroupCode",


"REPORTFIELDTEMPLATE"."SortOrder",


"REPORTFIELDTEMPLATE"."ColumnName"


FROM "ReportView" AS "View"


LEFT OUTER JOIN "dbo"."ReportFieldTemplate" AS "REPORTFIELDTEMPLATE"


ON (


"View"."ViewId" = "REPORTFIELDTEMPLATE"."ViewId"


)


Previous ticket raised on this (as a question) is here - https://community.yellowfinbi.com/ticket/13077

Comments (1)

photo
1

Hi Brendan,

Thanks for the suggestion. I have now raised this as an IDEA with our Dev team. If I get any updates on this, I will let you know.

Regards,

Paul