GroupCode description and order in Audit views

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

Replies (3)

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

photo
1

Not confident, but any progress on this idea?

photo
1

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

Leave a Comment
 
Attach a file