VIEWS tab missing after search.

[expired user #8977]'s profile image [expired user #8977] posted 9 years ago in General Permalink
When I open Search - Find text on server, it fails to create a tab for the VIEWS.
If I remove some of the SELECTS from the query the VIEWS tab is shown.

Version 9.2.0.4947 (64 Bit)
1 attachment(s):
  • 2015-05-29-1-49-33-PM
ansgar's profile image ansgar posted 9 years ago Permalink
There is a setting in Tools > Preferences > SQL, which limits the maximum number of result sets - by default to 10. That's intentionally, and shall avoid huge memory consumption. Your view query is the elevenths one in the list, so it's not displayed. Just increase the value to display more results.
[expired user #8977]'s profile image [expired user #8977] posted 9 years ago Permalink
OK, I missed that.

Thanks very much for your help Ansgar,
Regards Mike.

Please login to leave a reply, or register at first.