no_external_url query returns no results

[JC5]

Discussed in #5867

^{Originally posted by GeorgeHahn March 9, 2022}
I'm having trouble with the no_external_url:true query. It returns no results on my instance. This operator appears to be working correctly on the demo instance.

This is a poor bug report. Can you recommend any ways I could investigate further?

---

Debug information generated at 2022-03-08 21:15:11 America/Chicago for Firefly III version 5.6.16.

Scope	Version
Firefly III	5.6.16
Firefly III API	1.5.5
Build	113, 02-03-2022 19:39:22 CET
PHP	8.0.16
Host	Linux

System info	Value
Using docker?	true
Layout
System TZ	America/...
Browser TZ	America/...
App environment	local
App debug mode	false
App cache driver	file
App logging	debug, stack
Display errors	Off
Error reporting	ALL errors
Interface	apache2handler
Default language	en_US
Default locale	equal
BCscale	24
DB drivers	mysql, pgsql, sqlite
Current driver	pgsql
DB version	18 (exp. 18)
Login provider	eloquent
Trusted proxies (.env)

User info	Value
Session start	2022-03-01 00:00:00
Session end	2022-03-31 23:59:59
Session first	2018-03-30 00:00:00
User ID	1
User language	en_US
User locale	en_US
Attempt at "en_US.utf8"	'en_US.utf8'
Attempt at "en_US.UTF-8"	'en_US.UTF-8'

No url:

[2022-03-08 21:16:53] local.DEBUG: Constructed OperatorQuerySearch  
[2022-03-08 21:16:53] local.DEBUG: GroupCollector: The limit is now 50  
[2022-03-08 21:16:53] local.DEBUG: Now in parseQuery(no_external_url:true)  
[2022-03-08 21:16:53] local.DEBUG: Found 1 node(s)  
[2022-03-08 21:16:53] local.DEBUG: Now in handleSearchNode(Gdbots\QueryParser\Node\Field)  
[2022-03-08 21:16:53] local.DEBUG: Now handle Node class Gdbots\QueryParser\Node\Field  
[2022-03-08 21:16:53] local.DEBUG: Now in updateCollector("no_external_url", "true")  
[2022-03-08 21:16:53] local.DEBUG: "no_external_url" is not an alias.  
[2022-03-08 21:16:53] local.DEBUG: "no_external_url" is not an alias.  
[2022-03-08 21:16:53] local.DEBUG: Added operator type "no_external_url"  
[2022-03-08 21:16:54] local.DEBUG: Constructed OperatorQuerySearch  
[2022-03-08 21:16:54] local.DEBUG: GroupCollector: The limit is now 50  
[2022-03-08 21:16:54] local.DEBUG: Now in parseQuery(no_external_url:true)  
[2022-03-08 21:16:54] local.DEBUG: Found 1 node(s)  
[2022-03-08 21:16:54] local.DEBUG: Now in handleSearchNode(Gdbots\QueryParser\Node\Field)  
[2022-03-08 21:16:54] local.DEBUG: Now handle Node class Gdbots\QueryParser\Node\Field  
[2022-03-08 21:16:54] local.DEBUG: Now in updateCollector("no_external_url", "true")  
[2022-03-08 21:16:54] local.DEBUG: "no_external_url" is not an alias.  
[2022-03-08 21:16:54] local.DEBUG: "no_external_url" is not an alias.  
[2022-03-08 21:16:54] local.DEBUG: Added operator type "no_external_url"  
[2022-03-08 21:16:54] local.DEBUG: GroupCollector: page is now 1  
[2022-03-08 21:16:56] local.DEBUG: Trying to set en_US.utf8  
[2022-03-08 21:16:56] local.DEBUG: Trying to set en_US.UTF-8  

Any url:

[2022-03-08 21:27:09] local.DEBUG: Constructed OperatorQuerySearch  
[2022-03-08 21:27:09] local.DEBUG: GroupCollector: The limit is now 50  
[2022-03-08 21:27:09] local.DEBUG: Now in parseQuery(any_external_url:true)  
[2022-03-08 21:27:09] local.DEBUG: Found 1 node(s)  
[2022-03-08 21:27:09] local.DEBUG: Now in handleSearchNode(Gdbots\QueryParser\Node\Field)  
[2022-03-08 21:27:09] local.DEBUG: Now handle Node class Gdbots\QueryParser\Node\Field  
[2022-03-08 21:27:09] local.DEBUG: Now in updateCollector("any_external_url", "true")  
[2022-03-08 21:27:09] local.DEBUG: "any_external_url" is not an alias.  
[2022-03-08 21:27:09] local.DEBUG: "any_external_url" is not an alias.  
[2022-03-08 21:27:09] local.DEBUG: Added operator type "any_external_url"  
[2022-03-08 21:27:10] local.DEBUG: Constructed OperatorQuerySearch  
[2022-03-08 21:27:10] local.DEBUG: GroupCollector: The limit is now 50  
[2022-03-08 21:27:10] local.DEBUG: Now in parseQuery(any_external_url:true)  
[2022-03-08 21:27:10] local.DEBUG: Found 1 node(s)  
[2022-03-08 21:27:10] local.DEBUG: Now in handleSearchNode(Gdbots\QueryParser\Node\Field)  
[2022-03-08 21:27:10] local.DEBUG: Now handle Node class Gdbots\QueryParser\Node\Field  
[2022-03-08 21:27:10] local.DEBUG: Now in updateCollector("any_external_url", "true")  
[2022-03-08 21:27:10] local.DEBUG: "any_external_url" is not an alias.  
[2022-03-08 21:27:10] local.DEBUG: "any_external_url" is not an alias.  
[2022-03-08 21:27:10] local.DEBUG: Added operator type "any_external_url"  
[2022-03-08 21:27:10] local.DEBUG: GroupCollector: page is now 1  
[2022-03-08 21:27:12] local.DEBUG: Trying to set en_US.utf8  
[2022-03-08 21:27:12] local.DEBUG: Trying to set en_US.UTF-8  

The query excludes any meta data, so if you have an interest date set it will no longer match.

[JC5]

Closing "fixed" issues for upcoming release.