Hi All,
This week I encountered the problem when I want to create query in Domain Designer with derived table using query. I found out that maximum character can be entered there was 5000 character. So I went around and read the configuration to change that to the value that I want since my query is big.
You can try to open this file:
\WEB-INF\classes\esapi\security.properties
Find this row:
createdQuerySql=Alpha,NoTag,5000,true,createdQuerySql-Run_Report_context
sqlDomainDesigner=ValidSQL,ValidSQLSelectStart,5000,true,SQL_Domain_Designer_context
Change value 5000 for this row to the value that you want and there you go.
In my case, I changed it to 20000 and it suite my requirement straight away.
Don't forget to delete all your temp and work folder (if exist) since this file is being cached.
Hope it helps.