Increase AccessFilterCode column width to prevent truncation errors

Jonathon Whitton shared this idea 33 days ago
Idea Logged

I've run into an issue which stems from the column width for the AccessFilterCode in the ReportFieldTemplate table.


Essentially if you have a long access filter name, or applying multiple access filters, and you reach the limit of 40 characters you will get a truncation error.

Example below:


AccessFilterCode =

'CategoryLevel1Name|CategoryLevel2Name|CategoryLevel3Name|CategoryLevel4Name|CategoryLevel5Name|CategoryID'


To ensure this doesn't happen again, can YF increase it to 255 out of the box or higher?


I've since increased it myself and got around it, but would be good to not have to configure the DB.