search

snipe / snipe-it

A free open source IT asset/license management system
https://snipeitapp.com
GNU Affero General Public License v3.0
11.13k stars 3.19k forks source link

Advanced Search Returns No Results #4275

Closed pixeldj closed 1 year ago

pixeldj commented 7 years ago

Expected Behavior (or desired behavior if a feature request)

Expecting results when using advanced search on assets page.

Actual Behavior

No results returned when using most searches, or in some cases search is not filtering properly.

Please confirm you have done the following before posting your bug report:

Provide answers to these questions:

Please do not post an issue without answering the related questions above. If you have opened a different issue and already answered these questions, answer them again, once for every ticket. It will be next to impossible for us to help you.

https://snipe-it.readme.io/docs/getting-help

--- Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/50573328-advanced-search-returns-no-results?utm_campaign=plugin&utm_content=tracker%2F505106&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F505106&utm_medium=issues&utm_source=github).
snipe commented 7 years ago

Please do a fresh pull and see if this resolves your issue

pixeldj commented 7 years ago

Updated to latest commit (59c0b63) and I'm still having the issue. If I enter text into an advanced search field I get no results. If I refresh the page afterwards, the text from the advanced search goes into the regular search box and it shows some results, but it doesn't search within a specific column.

no-search search search-results

diekmanu commented 7 years ago

Here it's not working either. This is what happens when searching for models/categories:

Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'assets.model' in 'where clause' (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 ((exists (select from models where assets.model_id = models.id and models.name LIKE %P700%)) or assets.model LIKE %P700%) and assets.deleted_at is null)' in D:\SYSTEM\WPN-XM\www\snipe-it_v4\vendor\laravel\framework\src\Illuminate\Database\Connection.php:647

Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'assets.category' in 'where clause' (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 (exists (select from models where assets.model_id = models.id and exists (select * from categories where models.category_id = categories.id and (categories.name LIKE %Monitors% or models.name LIKE %Monitors% or models.model_number LIKE %Monitors%) and categories.deleted_at is null)) or assets.category LIKE %Monitors%) and assets.deleted_at is null)' in D:\SYSTEM\WPN-XM\www\snipe-it_v4\vendor\laravel\framework\src\Illuminate\Database\Connection.php:647

Custom field search results in "No matching records found". But no exception/error message is logged here.

snipe commented 7 years ago

Can you inspect the API call via browser network and tell me what the URL (with params) is that it's trying to fetch from the API? (I don't need the domain name, just need the params to reproduce it locally.)

Also the advanced search is listed as experimental, so some issues are to be expected. We'll try to resolve them as quickly as we can.

diekmanu commented 7 years ago

Model:

GET /api/v1/hardware?status=&order_number=&company_id=&status_id=&search=P910&order=asc&limit=200&offset=0&filter=%7B%22model%22%3A%22P910%22%7D HTTP/1.1

Category:

GET /api/v1/hardware?status=&order_number=&company_id=&status_id=&search=Monitors&order=asc&limit=200&offset=0&filter=%7B%22category%22%3A%22Monitors%22%7D HTTP/1.1

Combined search: GET /api/v1/hardware?status=&order_number=&company_id=&status_id=&search=P910&order=asc&limit=200&offset=0&filter=%7B%22category%22%3A%22Monitors%22%2C%22model%22%3A%22P910%22%7D HTTP/1.1

Response code HTTP/1.1 500 Internal Server Error Server: nginx

pixeldj commented 7 years ago

/api/v1/hardware?status=&order_number=&company_id=&status_id=&search=32&sort=name&order=asc&limit=200&offset=0&filter=%7B%22custom_fields._snipeit_ram_gb_3%22%3A%2232%22%7D

It looks like it's actually returning rows, though. They just are not showing up on the page.

capture

faxesystem commented 7 years ago

Can confirm this. I'm on Version v4.0.15 build 384 (g4f80eac)

faxesystem commented 7 years ago

https://imgur.com/a/QxGGt

That's how it looks in my side. Any ideas?

Greetings,

Faxe

snipe commented 7 years ago

Can you try the latest off of master?

snipe commented 7 years ago

Hi there - We haven't heard back in a bit, so I'm going to close this ticket for now, but will re-open it if you're still having issues.

hackerman-hacking

faxesystem commented 7 years ago

Can confirm that the latest version fixed it. 🥇

diekmanu commented 7 years ago

Develop?

snipe commented 7 years ago

@diekmanu ?

diekmanu commented 7 years ago

Is it fixed in the develop branch? Because it's not working for me in v4.1.3

snipe commented 7 years ago

@diekmanu it's fixed on master and develop. Please give us the latest from your app log.

diekmanu commented 7 years ago

Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'assets.location' in 'where clause' (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 (exists (select * from locations where assets.location_id = locations.id and locations.name LIKE %City% and locations.deleted_at is null) or assets.location LIKE %City%) and assets.deleted_at is null)' in D:\SYSTEM\WPN-XM\www\snipe-it_v4\vendor\laravel\framework\src\Illuminate\Database\Connection.php:647

So for me everything location based + custom_field searches are not working.

snipe commented 7 years ago

I can't reproduce that at all. :( This line should have fixed it.

https://github.com/snipe/snipe-it/blob/31980c55de8423b94cdce2ad32c9371b4857057e/app/Models/Asset.php#L942

diekmanu commented 7 years ago

It seems that I was still using the master version from Nov 4th. Git on Windows is just crap... I guess I will just copy/paste the zip archives once again. Is the aws-sdk required now? Migration fails for me, without the dev packages.

snipe commented 7 years ago

I removed the AWS SDK from composer. We don't use it anywhere. (The hope was to allow S3 uploads, but the way Laravel does it currently requires a symlink, and I just can't currently bear having to support users not knowing how to do that.)

diekmanu commented 7 years ago

Um...

D:\SYSTEM\WPN-XM\www\snipe-it_v4>php artisan migrate

Fatal error: Class 'Aws\Laravel\AwsServiceProvider' not found in D:\SYSTEM\WPN-X M\www\snipe-it_v4\config\aws.php on line 23

Call Stack: 0.0000 232856 1. {main}() D:\SYSTEM\WPN-XM\www\snipe-it_v4\artisan:0 0.0300 3971408 2. Illuminate\Foundation\Console\Kernel->handle() D:\SYS TEM\WPN-XM\www\snipe-it_v4\artisan:36 0.0300 3971536 3. Illuminate\Foundation\Console\Kernel->bootstrap() D:\ SYSTEM\WPN-XM\www\snipe-it_v4\vendor\laravel\framework\src\Illuminate\Foundation \Console\Kernel.php:114 0.0300 3971704 4. Illuminate\Foundation\Application->bootstrapWith() D: \SYSTEM\WPN-XM\www\snipe-it_v4\vendor\laravel\framework\src\Illuminate\Foundatio n\Console\Kernel.php:267 0.0400 4116552 5. Illuminate\Foundation\Bootstrap\LoadConfiguration->bo otstrap() D:\SYSTEM\WPN-XM\www\snipe-it_v4\vendor\laravel\framework\src\Illumina te\Foundation\Application.php:208 0.0400 4143992 6. Illuminate\Foundation\Bootstrap\LoadConfiguration->lo adConfigurationFiles() D:\SYSTEM\WPN-XM\www\snipe-it_v4\vendor\laravel\framework \src\Illuminate\Foundation\Bootstrap\LoadConfiguration.php:39 0.0490 4570912 7. require('D:\SYSTEM\WPN-XM\www\snipe-it_v4\config\aws. php') D:\SYSTEM\WPN-XM\www\snipe-it_v4\vendor\laravel\framework\src\Illuminate\F oundation\Bootstrap\LoadConfiguration.php:71

So I have to install it manually / put it in composer.json?

snipe commented 7 years ago

So I have to install it manually / put it in composer.json?

No. You must still have some leftover files or something. If you look on master, the aws.php config file doesn't even exist anymore.

https://github.com/snipe/snipe-it/tree/master/config

diekmanu commented 7 years ago

Just deleted it and migration won't throw an error anymore. Perhaps I really should run this on a Linux machine in the future, where Git actually works 😄

Location search is working now. 👍 When I try to add custom fields the query result is still blank...but no error in laravel.log

snipe commented 7 years ago

Can you tell me what query it's trying to run using the debugbar?

diekmanu commented 7 years ago

GET /api/v1/hardware?status=&order_number=&company_id=&status_id=&search=DEL-R1&order=asc&limit=20&offset=0&filter=%7B%22name%22%3A%22display%40gll-del%22%2C%22custom_fields._snipeit_raum_6%22%3A%22DEL-R1%22%7D HTTP/1.1 Host: webservices:8103 Connection: keep-alive Accept: application/json, text/javascript, /; q=0.01 X-CSRF-TOKEN: jP1QrlQdy2OcWEgpanSs7v6WLxbmq7t7FYMhUCZj X-Requested-With: XMLHttpRequest User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36 Content-Type: application/json Referer: http://webservices:8103/hardware Accept-Encoding: gzip, deflate, sdch Accept-Language: de-DE,de;q=0.8,en-US;q=0.6,en;q=0.4 Cookie: assetTable-gb6a14d2.bs.table.searchText=; laravel_token=eyJpdiI6IlVcL2ZoOUtxNjVcL2JlRjgrYWtaM3Judz09IiwidmFsdWUiOiJzekxGUGZvZkJxemVpXC9qbXlDQjhjRkUzN0V2eGRmVWE5cjV5b3d2SjZWdnFRcmdEdEorYlM1eDU2czFORFM1NFlPc0xISDJTUGE5bnEyUFNHNUl4bjNsaGI0UzV2TlF5RmtjNmRFdXhFZUxJVTlOelNsXC9SN3c0YnlodzZOaEVFcEowT0p6ZEJ4WmpaVnlnaksxUE5JQkFrSXhsV3E1dGowZHZFOWtLTFpNSDRseERzdnRJamlYWXc4ZjZtYjZHMzZtVlwvNU9aNlMreTBcL2Y5SE42S01WQjVsS01EZjlZMHZyVHpQOERpSFpPVUpHNHZUbzBaQ2Z6K3ZWQW1cL2gwdytkN2E3T2NCcjJqdklxeWxmYkl1N2V3PT0iLCJtYWMiOiIzZWZlNzAxZmMzZDU3ZDVlNDFmM2Y1OGVlYWE0Y2M1MWZmNTBmYjgxOWIzYTFiOTY2YTc0MjFjOWIzZDIwNTFhIn0%3D; XSRF-TOKEN=eyJpdiI6InNRS2RmWTlcLzNMV1BWRUwzY1V4M0h3PT0iLCJ2YWx1ZSI6IkQ1M2l6UDBrdzFkeGptV1psb005T3VWazNoK3lJblAxRThPanI1TTh4enNhcjd4ZkhKbjZsYWlxNUZqSjRxenhjQzRIOTlwSmpEbzZNSFJ3bVoxVHNBPT0iLCJtYWMiOiIyNzMyZDY0MjhkMmM0ZWY5MThiMWQ4NDM3YWNhNmJjODBiYjllOTYzODBhOGIxOTVlMjViODAzZTEyZDYyZTQxIn0%3D; snipeit_session=jvv3U9yEsANbnbBtphqk4p5FPbypKXMqQz7p0inD; assetTable-g74aa562.bs.table.searchText=DEL-R1

So the custom field is called "Raum" with the value "DEL-R1"

diekmanu commented 7 years ago

Is this enough? Debugbar is just full of internal stuff. Paths, environment variables, etc. I would need to alter this first.

diekmanu commented 7 years ago

Custom field queries actually return the right rows, when looking at the developer tools. Just like in the example above. The results just don't show up.

Search by manufacturer generates an error: GET /api/v1/hardware?status=&order_number=&company_id=&status_id=&search=Fujitsu&order=asc&limit=20&offset=0&filter=%7B%22manufacturer%22%3A%22Fujitsu%22%7D HTTP/1.1 Host: webservices:8103 Connection: keep-alive Accept: application/json, text/javascript, /; q=0.01 X-CSRF-TOKEN: jP1QrlQdy2OcWEgpanSs7v6WLxbmq7t7FYMhUCZj X-Requested-With: XMLHttpRequest User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36 Content-Type: application/json Referer: http://webservices:8103/hardware Accept-Encoding: gzip, deflate, sdch Accept-Language: de-DE,de;q=0.8,en-US;q=0.6,en;q=0.4 Cookie: assetTable-gb6a14d2.bs.table.searchText=; assetTable-g74aa562.bs.table.columns=%5B%22checkbox%22%2C%22name%22%2C%22image%22%2C%22asset_tag%22%2C%22serial%22%2C%22model%22%2C%22category%22%2C%22status_label%22%2C%22assigned_to%22%2C%22location%22%2C%22manufacturer%22%2C%22purchase_cost%22%2C%22custom_fields._snipeit_mac_address_1%22%2C%22custom_fields._snipeit_ip_adresse_2%22%2C%22custom_fields._snipeit_lan_port_3%22%2C%22custom_fields._snipeit_raum_6%22%2C%22custom_fields._snipeit_dsm_rc_viewer_7%22%2C%22checkincheckout%22%2C%22actions%22%5D; DeployedassetTable-g74aa562.bs.table.columns=%5B%22checkbox%22%2C%22name%22%2C%22image%22%2C%22asset_tag%22%2C%22serial%22%2C%22model%22%2C%22category%22%2C%22status_label%22%2C%22assigned_to%22%2C%22location%22%2C%22manufacturer%22%2C%22purchase_cost%22%2C%22custom_fields._snipeit_mac_address_1%22%2C%22custom_fields._snipeit_ip_adresse_2%22%2C%22custom_fields._snipeit_lan_port_3%22%2C%22custom_fields._snipeit_raum_6%22%2C%22custom_fields._snipeit_dsm_rc_viewer_7%22%2C%22checkincheckout%22%2C%22actions%22%5D; laravel_token=eyJpdiI6IjZRejFLcmhUWG5cL0FWTkpDUmhLSHRBPT0iLCJ2YWx1ZSI6Im1ld3REd2dFaldKMXBHUVAxOEVZYkFrckFGMEduc05RS1o3YWRoeExtNDBnNzhzK3M3TDNSSklSN1M5Zjg4VmxseThGNEkyNmU2R0pCVklvTGhQNGZVN3JYdzVlOU51UXpWV1QwNHNlOHlVeVgxZmZJd281U0ZsbUUzdWxHSWtEd1lpR01Pc3B0a1Brc280WCs4WWhMRVJyTVMzWk90alhqXC9pamZLUEozZm1aeDU3cExYd2I0M0kzXC9paWFLQXRNSHYrSzk0ZnNpd1FcLzFRVURKMnRteVJIQmlpbzE3aGEwVGxNQW00dkdjZlZjSzVmcnU1RDFEOVd5RXpNNEJDNDBvWk5yaURMQUxFRENrWUJkUFF4dHdBPT0iLCJtYWMiOiIyMTkwMDE5YjE2ZmU2YmY0NDg3NjM2Y2E5YTYxODRhYWFkOWRiMWFiNWJhYTdmZmQwYTA2MjQ2MmZiN2E0NTQ3In0%3D; XSRF-TOKEN=eyJpdiI6InMxT3RQUk9iTVwvUU0wV0RTXC9UbG1Wdz09IiwidmFsdWUiOiJVUG8xRklwR0NnT1dNMm50NEZ6bGZaQTBaNWNcLzJOd3BQQ2F5ZmpPSDhTT0ZcLzdyc1V0MlV2VDB1TW91XC82XC8wTng0RVwvT1wvWWdaVzl6dXBsRE5POTFrQT09IiwibWFjIjoiMzM3OWU3MDU5NTkwZDEwOTJhMzU5MDM2ZmM1MTg0Mzk0N2ViMDI1MjYxY2M4MWRiMTEwNTIwYjc5NzljNmExZiJ9; snipeit_session=jvv3U9yEsANbnbBtphqk4p5FPbypKXMqQz7p0inD; assetTable-g74aa562.bs.table.searchText=Fujitsu

Whoops, looks like something went wrong.

HTTP/1.1 500 Internal Server Error Server: nginx Content-Type: text/html; charset=UTF-8 Transfer-Encoding: chunked Connection: keep-alive X-Powered-By: PHP/5.6.29 Cache-Control: no-cache, private date: Wed, 08 Nov 2017 15:42:06 GMT X-Content-Type-Options: nosniff Referrer-Policy: same-origin X-XSS-Protection: 1;mode=block X-Frame-Options: SAMEORIGIN Set-Cookie: snipeit_session=jvv3U9yEsANbnbBtphqk4p5FPbypKXMqQz7p0inD; expires=Thu, 16-Nov-2017 23:42:06 GMT; Max-Age=720000; path=/; httponly

snipe commented 7 years ago

I'm looking specifically for the asset related DB queries in the Query section of the debugbar.

snipe commented 7 years ago

(Also, if there's a whoops error, there's got to be something in the logs)

diekmanu commented 7 years ago

This is the exception I'm getting when searching for manufacturers:

Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'assets.manufacturer' in 'where clause' (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 (exists (select from models where assets.model_id = models.id and exists (select * from manufacturers where models.manufacturer_id = manufacturers.id and (manufacturers.name LIKE %Fujitsu%) and manufacturers.deleted_at is null)) or assets.manufacturer LIKE %Fujitsu%) and assets.deleted_at is null)' in D:\SYSTEM\WPN-XM\www\snipe-it_v4\vendor\laravel\framework\src\Illuminate\Database\Connection.php:647

snipe commented 7 years ago

Okay, I can fix that. I know where to do it, but am AFK right now. Will have a fix out for you tomorrow.

diekmanu commented 7 years ago

Thanks again @snipe

I hope this is the right location in the debugbar log regarding the custom field issues:

"connection":"abcd_snipeit-v4"}, {"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.name LIKE '%display@gll-del%' or assets._snipeit_raum_6 LIKE '%DEL-R1%') and assets.deleted_at is null", "type":"query", "params":[], "bindings":["0", "%display@gll-del%", "%DEL-R1%"], "hints":[], "backtrace":[{"index":13, "namespace":null, "name":"\app\Http\Controllers\Api\AssetsController.php", "line":244}, {"index":14, "namespace":null, "name":"\app\Http\Controllers\Api\AssetsController.php", "line":244}, {"index":34, "namespace":null, "name":"\app\Http\Middleware\CheckForDebug.php", "line":25}, {"index":37, "namespace":null, "name":"\vendor\fideloper\proxy\src\TrustProxies.php", "line":56}, {"index":40, "namespace":null, "name":"\app\Http\Middleware\CheckForSetup.php", "line":27}, {"index":43, "namespace":null, "name":"\app\Http\Middleware\NosniffGuard.php", "line":17}, {"index":46, "namespace":null, "name":"\app\Http\Middleware\ContentSecurityPolicyHeader.php", "line":18}, {"index":49, "namespace":null, "name":"\app\Http\Middleware\ReferrerPolicyHeader.php", "line":17}, {"index":52, "namespace":null, "name":"\app\Http\Middleware\XssProtectHeader.php", "line":18}, {"index":55, "namespace":null, "name":"\app\Http\Middleware\FrameGuard.php", "line":17}, {"index":70, "namespace":null, "name":"\public\index.php", "line":59}], "duration":0, "duration_str":"0\u03bcs", "stmt_id":"\app\Http\Controllers\Api\AssetsController.php:244",

snipe commented 7 years ago

Manufacturer issue should be sorted now

If you run that query on the db: "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.name LIKE '%display@gll-del%' or assets._snipeit_raum_6 LIKE '%DEL-R1%') and assets.deleted_at is null"

Do you get results? If it's not producing an error I'm not sure what to do here.

pixeldj commented 7 years ago

Still not working for me on the latest pull on Nov 9th (578da128e9e009fb658bc6a9d60054ea21e203e5)

diekmanu commented 7 years ago

2017-11-16_09h07_08

The query seems to be okay. But still no results on v4.1.4 build 173 (gba38b84)

Manufacturer search works now 👍

snipe commented 6 years ago

What's the current status of this issue?

diekmanu commented 6 years ago

For me...everything works except custom field searches. Here the right results are only displayed in the developer tools (Chrome) . These are not showing up on the page.

pixeldj commented 6 years ago

For me, asset tag searches work in advanced search, but asset name, status, location, checked out user all return everything. Custom field searches in advanced search return nothing at all.

EDIT (4/9/18): It appears that regular fields work in advanced search now, but custom fields still return nothing.

yoshiesk commented 6 years ago

For me , everything works except custom field searches. and also I upgrade to the v4.1.9-pre - build 3117(master), still get the same problem ~

migaspar commented 6 years ago

I can confirm this with version v4.1.10-pre - build 3160 (master)

snipe commented 6 years ago

@migaspar what's in your error logs?

migaspar commented 6 years ago

problem persists with Version v4.1.10 - build 3249 (master). there is no corresponding error in storage/logs/laravel.log. btw, the search in the general search window works as expected.

israeljacobsen commented 6 years ago

i have the same problem with 4.1.14 doesn't search in custom fields, php 7.0.25 Ubuntu 16.04.01 Laravel Version 5.4.35

israeljacobsen commented 6 years ago

debugger log.txt file

israeljacobsen commented 6 years ago

i had upgraded to 4.2 still custom filed have result from server but doesn't display on screen

pixeldj commented 6 years ago

Just tried on the live demo and it appears custom field searches still return no results.

I added IPv4 custom field to 13" Macbook Pro model, edited an asset and added the IP "10.0.0.10". When I use regular search it comes up, but when searching in the "IPv4" field with custom search, nothing is returned.

vogtmh commented 6 years ago

We're about to switch from a simple Excel sheet to SnipeIT now. We have v4.2.0 - build 3479 (master) running on premise. The only dealbreaker is the bug in the advanced search right now as Excel searches work so much better. Are there any quick fixes I could apply to make the search results appear?

I suppose the AJAX request is not done right. When I compare the console output of my Chrome, the standard and the advanced search are quite different (see attached pictures).

Standard filter: standard_filter

Advanced filter: advanced_filter

kevinbarbour commented 6 years ago

I'm also experiencing issues with the advanced search. It appears to work for standard fields but whenever I search on a custom field no results appear.

v4.2.0 build 3497 (g590938f)

snipe commented 6 years ago

@uberbrady can you take a look at this? The file you want to eyeball is public/js/extensions/bootstrap-table-toolbar.js. Custom field searching doesn't work, though the query that's generated is correct (in other words, this looks like a BS tables issue or the table toolbar issue.)

It also looks like the API is being hit twice when you use the advanced search, the first time erroring, the second time loading as expected. This happens whether you're searching on custom fields or not, but when you search on custom fields, the table loads no results, ever, whereas the advanced search on normal fields returns expected results.

screen shot 2018-04-23 at 8 52 57 pm
skifanatech commented 6 years ago

We have a new premise-based installation and the advanced search features clearly do not work properly. Running version 4.20 build 3479.

If I filter the results in the "search" box, the results are consistent with my expectations (although it's quirky and sometimes i have to clear the box and reload the the full asset list). When i put that same criteria into the advanced search using non-custom fields, i get totally different results that are clearly wrong. A simple Location search ignores most assets in that location. All category searches return no records. Doing a combination of filters almost always yields no records. As it stands, the advanced search is not usable.

vogtmh commented 6 years ago

Unfortunately this is still an issue in 4.4.1 :-/