compound / cross-field asset search

MSPs often reuse the same asset layout and similar asset names across many companies (e.g. the same software name on 20 clients). Users naturally search [company hint] [product keyword] (e.g. Artic server105), expecting one result: that client’s asset whose field contains “server105”.

Today that fails because:

1. Company name is not searchable text on assets — only company_id is used for filters, not name/nickname in the query.

2. Multi-word asset comprehensive search often requires all terms in one column/value. So one word in the name and one in a different field does not match reliably.