GroupCode description and order in Audit views

Brendan Codrington shared this idea 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

I like this idea 0

Replies (3)

Paul Thornton ●

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

Reply URL

Brendan Codrington ●

Not confident, but any progress on this idea?

Reply URL

Mark McGuire ●

Hi Brendan,

I hope all is well,

Unfortunately no movement as of yet, however I can see that you've chased a few Enhancement tickets over the recent hours. With this I'd like to escalate this further and make our wider team aware. I'd like to get your CSM involved. I see Chris McCarthy already mentioned this in another Enhancement Ticket.

Let me know your thoughts.

Regards,

Mark

Reply URL