Skip to main content

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! 
 

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

Terms & ConditionsCookie settings