Hello, Is there a limitation for the length of the query in a portlet? I am writing a query and noticed that the "FROM" clause cannot accomodate more than certain number of lines. I have a large FROM statement with multiple sub-queries and cannot seem to accomodate this in the FROM box of the portlet. Any workarounds? Thanks.
Thanks a lot. We have noticed that the total number of results for a portlet in our Development instance is limited to 200 lines. When the query is run on the backend, more than 200 lines are generated. However, the same portlet is able to display 400 lines in Production environment. What could be the problem in Dev due to which the number of lines of data are not able to go beyond 200 lines?
I also faced the similar problem when SQL Query was nbot fitting in Data source. To fit the query I removed all unnecessary spaces, carriage returns and comments from the query and renamed all generated columns as short as posisble. This worked for me.
Secpond workaround mentionied above to continue query in wHERE clause, is, actually, pretty cool :)