---
title: "Searching and JQL functions"
canonical: "https://support.appfire.com/space/AIP/10257342/Searching%20and%20JQL%20functions"
format: markdown
---
> Macro (aura-html)

Asset related issues can be searched via the "Assets" custom field in the issue navigator or by handy AIP JQL functions.

### Search by custom field (Simple search)

Searching via custom field is as simple as any field in Jira. In the issue navigator, enter the field name (by default, it is `Assets`) followed by your search term and use a generic text search. Text search is not case-sensitive.

| **Example JQL** | **Description** |
| --- | --- |
| Assets ~ Laptop | This finds issues where the "Assets" field contains "Laptop", "Laptop2", "MyLaptop", or "MyLaptop2". |
| Assets ~ 'My Laptop' | You must enclose spaces or special characters in a string. |
| Assets is not EMPTY | Finds issues with a value assigned to the "Assets" field.<br>![image](media://ed01c247-e2b0-45aa-a03c-1905d8e01101) |
| Assets ~ '#55' | Searches for an issue with a specific Asset ID. |

### Search by JQL functions (Advanced search)

### assetByField function 

> ℹ️ **Introduced in version 7.0.3**

AIP supports filtering issued with the selected assets' field values. This function works similarly to the referenceAsset function (refer to [Search functions](https://appfire.atlassian.net/wiki/spaces/AIP/pages/10256824) documentation for details).

| **Example for referenceAsset search function** | **Example for assetByField JQL function** |
| --- | --- |
| <span style="color: #172b4d">referenceAsset("asset.assetTag", "\"marla singer\"")</span> | <span style="color: #172b4d">assetByField("asset.assetTag", "\"marla singer\"")</span> |

> ⚠️ Field names are case-sensitive.

**Examples:**

| **JQL** | **Description** |
| --- | --- |
| issue in assetByField("Object Approvers", "mdavis-sd-demo") | Finds issues with assets where the `Object Approvers` field has the value `mdavis-sd-demo` (user name). |
| issue in assetByField("Object Owner", "tyler@@@marla") | Finds the issues that have assets with the `Object Owner` field are `tyler` or `marla` user names. The user key will also work. |
| issue in assetByField("asset.status", "In stock", "asset.substatus", "Defective") | Find the issues that have assets with `Status` system field as `In Stock` and `Substatus` system field as `Defective`. These values must be the English value of the field. |

> 📝 You can find examples for all other field types in the [Search functions](https://appfire.atlassian.net/wiki/spaces/AIP/pages/10256824) documentation; just remember to replace the `referenceAsset`<span style="color: #172b4d"> with </span>`assetByField`<span style="color: #172b4d">.</span>

### Filtering assets for all attribute types and system fields

You can combine multiple fields for complex searches. For example, you can even add all possible field types in one go: 

```
issue in assetByField("asset.status", "In Transit",
"asset.substatus", "Defective", 
"asset.assignee", "jevans-sd-demo",
"asset.owner", "mdavis-sd-demo",
"asset.managedBy", "jevans-sd-demo",
"asset.belongsToGroup", "jira-users@@@aaaa@@@jira-developers",
"asset.quantity", "100@@@101",
"asset.assetTag", "\"my asset tag\"",
"asset.serialNumber", "\"my serial 101\"",
"asset.installDate", "2020-03-27@@@2020-03-29",
"asset.location", "2",
"asset.cost", "99@@@101",
"asset.costCurrency", "EUR",
"asset.invoiceNumber", "\"my invoice\"",
"asset.created", "2019-07-05T13:23",
"asset.createdBy", "admin",
"asset.updated", "2020-06-18T17:11@@@2020-06-18T17:22",
"asset.updatedBy", "admin",
"Asset List", "#197",
"Asset List by Asset Types", "#227",
"Checkbox", "Ada@@@NOTHING@@@Bal",
"Date Picker", "2019-07-05",
"Date Time Picker", "2019-07-04T00:00@@@2019-07-06T00:00",
"Dropdown list", "Ada@@@NOTHING@@@Bal",
"IP v1", "\"213.74.44.193\"",
"IPv6", "\"2001:0db8:85a3:0000:0000:8a2e:0370:7334\"",
"Jira User Picker", "tolga",
"Jira User", "marla@@@NOTHING",
"Jira Users" , "tyler@@@NOTHING",
"List Box", "Mer@@@ABC_NOTHING@@@Ada",
"List Box - Multiple", "Mer@@@ABC_NOTHING@@@Izm",
"Number Float", "11.5@@@15.5",
"Number Long", "12",
"Radio Button", "Bal",
"Text", "\"b4 sample data from summary\"",
"TextArea", "sa*",
"URL", "\"http://www.snapbytes.com/\""
) 


```

### Deprecated JQL Functions (For reference only)

The following JQL functions are deprecated but included for reference:

**Examples:**

```
issue in inventoryByAttribute("Memory", "8 GB")
issue in inventoryByAttributeIgnoreCase("First Name", "Tyler")
issue in inventoryByUserAttribute("Owner", "tylerdurden")
issue in inventoryByUserAttribute("Owner") // If you do not pass second attribute, logged in user will be used.
```