Hello to all,
I wanted to know if (like in custom menus) we are limited to a number of characters in the SQL query in the creation of a Quick Report?
I know that in the custom menus we are limited to 4000 characters.
Thanks in advance!
Solved
Character limit in Quick Report
Best answer by sutekh137
If I am looking in the right spot (QUICK_REPORT_TAB), it looks like the SQL query is stored in a field called “SQL_EXPRESSION”, and that field is a CLOB. So, I would guess the query is essentially limitless.
CUSTOM_MENU.TAB.Parameter (the field that holds the executed expression) has a limit of 4000 characters.
Only one way to find out about a Quick Report query for sure, though -- if you have an expression greater than 4000 characters, give it a try!
Thanks,
Joe Kaufman
This topic has been closed for comments
If I am looking in the right spot (QUICK_REPORT_TAB), it looks like the SQL query is stored in a field called “SQL_EXPRESSION”, and that field is a CLOB. So, I would guess the query is essentially limitless.
CUSTOM_MENU.TAB.Parameter (the field that holds the executed expression) has a limit of 4000 characters.
Only one way to find out about a Quick Report query for sure, though -- if you have an expression greater than 4000 characters, give it a try!
Thanks,
Joe Kaufman
Just because something is part of a plan doesn't make it right.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.