Advanced search doesn't work as expected

[swift2512]

What title says. Tested on demo and find out that entries can't be filtered by certain fields. (Please see an attached image.) And after applying Advanced search filters, additional filtering by regular search doesn't work.

[cz-lucas]

Hi,

when I try to filter with after the title field I am getting a 500 http-error. It happens with the demo and my local version for development.

Here is the error message:

{
	"message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'assets.jobtitle' in 'where clause' (Connection: mysql, SQL: select count(*) as aggregate from `assets` inner join `status_labels` as `status_alias` on `status_alias`.`id` = `assets`.`status_id` and `status_alias`.`archived` = 0 where ((`assets`.`jobtitle` LIKE %Traffic%)) and `assets`.`deleted_at` is null)",
	"exception": "Illuminate\\Database\\QueryException",
	"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
	"line": 825,
	"trace": [
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
			"line": 779,
			"function": "runQueryCallback",
			"class": "Illuminate\\Database\\Connection",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
			"line": 398,
			"function": "run",
			"class": "Illuminate\\Database\\Connection",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php",
			"line": 3106,
			"function": "select",
			"class": "Illuminate\\Database\\Connection",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php",
			"line": 3091,
			"function": "runSelect",
			"class": "Illuminate\\Database\\Query\\Builder",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php",
			"line": 3676,
			"function": "Illuminate\\Database\\Query\\{closure}",
			"class": "Illuminate\\Database\\Query\\Builder",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php",
			"line": 3090,
			"function": "onceWithColumns",
			"class": "Illuminate\\Database\\Query\\Builder",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php",
			"line": 3603,
			"function": "get",
			"class": "Illuminate\\Database\\Query\\Builder",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php",
			"line": 3531,
			"function": "aggregate",
			"class": "Illuminate\\Database\\Query\\Builder",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php",
			"line": 2120,
			"function": "count",
			"class": "Illuminate\\Database\\Query\\Builder",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/app/Http/Controllers/Api/AssetsController.php",
			"line": 433,
			"function": "__call",
			"class": "Illuminate\\Database\\Eloquent\\Builder",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Controller.php",
			"line": 54,
			"function": "index",
			"class": "App\\Http\\Controllers\\Api\\AssetsController",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php",
			"line": 44,
			"function": "callAction",
			"class": "Illuminate\\Routing\\Controller",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
			"line": 266,
			"function": "dispatch",
			"class": "Illuminate\\Routing\\ControllerDispatcher",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
			"line": 212,
			"function": "runController",
			"class": "Illuminate\\Routing\\Route",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
			"line": 808,
			"function": "run",
			"class": "Illuminate\\Routing\\Route",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 170,
			"function": "Illuminate\\Routing\\{closure}",
			"class": "Illuminate\\Routing\\Router",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php",
			"line": 51,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "Illuminate\\Routing\\Middleware\\SubstituteBindings",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/app/Http/Middleware/SetAPIResponseHeaders.php",
			"line": 68,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php",
			"line": 127,
			"function": "handleRequest",
			"class": "App\\Http\\Middleware\\SetAPIResponseHeaders",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php",
			"line": 89,
			"function": "handleRequestUsingNamedLimiter",
			"class": "Illuminate\\Routing\\Middleware\\ThrottleRequests",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "Illuminate\\Routing\\Middleware\\ThrottleRequests",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/app/Http/Middleware/CheckLocale.php",
			"line": 49,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "App\\Http\\Middleware\\CheckLocale",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php",
			"line": 64,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "Illuminate\\Auth\\Middleware\\Authenticate",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 127,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
			"line": 807,
			"function": "then",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
			"line": 786,
			"function": "runRouteWithinStack",
			"class": "Illuminate\\Routing\\Router",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
			"line": 750,
			"function": "runRoute",
			"class": "Illuminate\\Routing\\Router",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
			"line": 739,
			"function": "dispatchToRoute",
			"class": "Illuminate\\Routing\\Router",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php",
			"line": 201,
			"function": "dispatch",
			"class": "Illuminate\\Routing\\Router",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 170,
			"function": "Illuminate\\Foundation\\Http\\{closure}",
			"class": "Illuminate\\Foundation\\Http\\Kernel",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMiddleware.php",
			"line": 19,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "Livewire\\Features\\SupportDisablingBackButtonCache\\DisableBackButtonCacheMiddleware",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php",
			"line": 66,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "Barryvdh\\Debugbar\\Middleware\\InjectDebugbar",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php",
			"line": 62,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "Illuminate\\Http\\Middleware\\HandleCors",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/app/Http/Middleware/PreventBackHistory.php",
			"line": 23,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "App\\Http\\Middleware\\PreventBackHistory",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/app/Http/Middleware/SecurityHeaders.php",
			"line": 26,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "App\\Http\\Middleware\\SecurityHeaders",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php",
			"line": 21,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php",
			"line": 51,
			"function": "handle",
			"class": "Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "Illuminate\\Foundation\\Http\\Middleware\\TrimStrings",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php",
			"line": 21,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php",
			"line": 31,
			"function": "handle",
			"class": "Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/app/Http/Middleware/CheckForDebug.php",
			"line": 25,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "App\\Http\\Middleware\\CheckForDebug",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/app/Http/Middleware/CheckForSetup.php",
			"line": 30,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "App\\Http\\Middleware\\CheckForSetup",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php",
			"line": 49,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "Illuminate\\View\\Middleware\\ShareErrorsFromSession",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php",
			"line": 121,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php",
			"line": 64,
			"function": "handleStatefulRequest",
			"class": "Illuminate\\Session\\Middleware\\StartSession",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "Illuminate\\Session\\Middleware\\StartSession",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php",
			"line": 110,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/app/Http/Middleware/NoSessionStore.php",
			"line": 28,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "App\\Http\\Middleware\\NoSessionStore",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php",
			"line": 58,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 209,
			"function": "handle",
			"class": "Illuminate\\Http\\Middleware\\TrustProxies",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
			"line": 127,
			"function": "Illuminate\\Pipeline\\{closure}",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php",
			"line": 176,
			"function": "then",
			"class": "Illuminate\\Pipeline\\Pipeline",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php",
			"line": 145,
			"function": "sendRequestThroughRouter",
			"class": "Illuminate\\Foundation\\Http\\Kernel",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/public/index.php",
			"line": 51,
			"function": "handle",
			"class": "Illuminate\\Foundation\\Http\\Kernel",
			"type": "->"
		},
		{
			"file": "/workspace/snipe-it/server.php",
			"line": 21,
			"function": "require_once"
		}
	]
}

[cz-lucas]

I found a solution to fix the 500 http error when filtering after the title. It is here: imbus@4fb486b

[viclou]

[FD-50689]

[bzeus]

[FD-50730]

[bzeus]

@snipe I had reopened this ticket https://support.snipeitapp.com/a/tickets/50721
Let me know if you want me to close this one again.

[viclou]

[FD-50858]