Query is too complex = onprem version

For some of the complex searches that use nested queries you may receive the notice 'Query is too complex'. This is normally only seen when you are using the simple file database which has a limitation on the size of the query you can ask to the database.

At this time the only way around this limitation of the simple file database is to reduce the amount or size of results you are searching for. You can also upgrade your database to MSSQL (SQL Express is free) which has a much larger query size.

Please let us know if you have received this error so we can confirm there is no other problem or issue.