Issue with Screen IDs in Reports – Exceeding String Length Limit

Support
#1

Hi everyone,

I’m facing an issue with the Screen IDs attribute in Jmix Reports.

As you know, we can define Screen IDs for a report to specify where it can be used. This attribute is stored as a comma-separated String with a length limit of 1000 characters.

Now, I have a report that needs to reference 47 different screen IDs (mostly various process forms). This results in a total length of 2246 characters, which exceeds the limit and causes a database error.

Would it be possible for Jmix to define the screensIdx attribute as a LOB instead of a fixed-length String? This would allow for more flexibility when defining multiple screen IDs.

Has anyone else encountered this issue? Are there any recommended workarounds?

Thanks!

#2

Hi,

Thank you for your idea, I’ve created a GitHub issue to discuss with the team - Increase length of REPORT_REPORT.SCREENS_IDX column · Issue #4323 · jmix-framework/jmix · GitHub.

Regards,
Gleb

1 Like