Database / Search syntax

Search syntax

One query language for the Database, the search box at the top of every page and your inventory. Click any example to try it here, then open it in the Database.

On this page

Basics5 What the item is9 Where it comes from3 Perks, stats and names6 Your inventory7

× 41 of 37,837 Open in Database

Annual Skate

Ancient Gospel

Luna's Howl

Not Forgotten

Zaouli's Bane (Harrowed)

Zaouli's Bane

Allegro-34

Trust

+33 more

Basics

Type a word, add a filter or two, take things out with a minus. A filter is a key, a colon and a value, with no spaces around the colon.

word

Part of a name or a type is enough: malfeasance, scout, shotgun. Capitals and accents don’t matter.

DatabaseHeader searchInventory

malfeasance 3 items

scout 283 items

a b

Add more terms and every one of them has to match.

DatabaseHeader searchInventory

is:exotic is:weapon 146 items

scout is:legendary 223 items

-term

A minus in front takes out whatever the term matches.

DatabaseHeader searchInventory

is:weapon -is:craftable 1,989 items

is:exotic -is:hunter 3,421 items

"two words"

Quotes keep a phrase together, in plain words or in a filter’s value.

DatabaseHeader searchInventory Not counted here

"ace of"

source:"iron banner"

a or b

Either side can match, and you can write and between terms too: and joins first, then or, then the spaces.

DatabaseHeader searchInventory Not counted here

is:shotgun or is:sniperrifle

is:solar is:glaive or is:arc is:fusionrifle

What the item is

is: does most of the work: hand it a rarity, a weapon type, an element or an ammo type and it knows what you mean.

is:weapon is:armor

All weapons, or all armor.

DatabaseHeader searchInventory

is:weapon 2,208 items

is:armor 6,029 items

is:exotic

By rarity: exotic, legendary, rare, uncommon or common.

DatabaseHeader searchInventory

is:exotic 3,649 items

is:legendary is:armor 4,978 items

is:handcannon

By weapon type, as one word: handcannon, autorifle, pulserifle, scoutrifle, sidearm, shotgun, sniperrifle, fusionrifle, linearfusionrifle, grenadelauncher, rocketlauncher, machinegun, sword, glaive, tracerifle. Bows and SMGs are is:bow and is:submachine (or is:smg).

DatabaseHeader searchInventory

is:handcannon 403 items

is:glaive 81 items

is:solar

By damage type: kinetic, arc, solar, void, stasis or strand.

DatabaseHeader searchInventory

is:solar 430 items

is:strand is:weapon 166 items

is:heavy

By ammo: primary, special or heavy.

DatabaseHeader searchInventory

is:special 655 items

is:heavy 441 items

slot:helmet

Armor by slot. The Database’s box takes slot:helmet, slot:gauntlets, slot:chest, slot:leg and slot:classitem; the header search and your inventory spell them is:helmet, is:chest and so on.

DatabaseHeader searchInventory

slot:helmet 1,592 items

slot:chest is:exotic 79 items

is:hunter

Class-locked gear: titan, hunter or warlock.

DatabaseHeader searchInventory

is:warlock is:armor 2,009 items

is:exotic -is:hunter 3,421 items

is:craftable

Weapons with a pattern you can shape at the Enclave.

DatabaseHeader searchInventory

is:craftable 219 items

-is:craftable is:weapon 1,989 items

element: ammo: rarity: class: type:

The Database’s box also takes these spelled out: element:solar, ammo:heavy, rarity:exotic, class:hunter, and type: for part of a type’s name (type:pulse, type:bow). The header search sticks to is:.

Database

element:solar 430 items

type:pulse 333 items

Where it comes from

Matches the source text on the item and the season it arrived in.

source:

Part of the source Bungie writes on the item, as one word: raid, dungeon, nightfall, trials, ironbanner, xur, exoticquest and so on.

DatabaseHeader searchInventory

source:raid 555 items

source:dungeon is:weapon 47 items

season:

The season number the item was added in. The Database’s box takes one number; the header search and your inventory also take comparisons (season:>=24).

DatabaseHeader searchInventory

season:28 3,308 items

season:27 is:weapon 84 items

breaker:

Weapons with a built-in anti-champion trait: barrier, overload or unstoppable.

DatabaseHeader searchInventory

breaker:unstoppable 660 items

breaker:barrier is:exotic 51 items

Perks, stats and names

These read perks and stats, which the Database’s quick box doesn’t load. Use the search box at the top of the page (Ctrl K) or your inventory’s.

perk:

Weapons that can roll the perk (header search) or copies that have it (inventory). Part of the name is enough; perkname: means the same.

Header searchInventory Not counted here

perk:outlaw

perk:"kill clip"

exactperk:

Only the whole perk name.

Header searchInventory Not counted here

exactperk:frenzy

stat:

A stat with a comparison: stat:rpm:>=600, stat:range:>70. Weapon stats: rpm, impact, range, stability, handling, reload, magazine, aimassist, zoom, recoildirection, airborne, charge, drawtime, blastradius, velocity, swingspeed and more. In your inventory, armor stats too: weapons, health, class, grenade, super, melee, total.

Header searchInventory Not counted here

stat:rpm:>=600

stat:range:>70 is:handcannon

basestat:

Like stat:, without masterwork, mods or catalyst. Weapons only for now.

Inventory Not counted here

basestat:range:>=60

name: exactname:

Match the name only (plain words also look at the type). exactname: wants the whole thing.

Header searchInventory Not counted here

name:"last word"

exactname:"Ace of Spades"

foundry:

Who made it: hakke, omolon, suros, veist, daito and the rest.

Header searchInventory Not counted here

foundry:suros

foundry:veist is:legendary

Your inventory

Signed in, the inventory’s search box reads your own items, tags and notes.

is:dupe

You own more than one copy.

Inventory Not counted here

is:dupe is:weapon

is:locked is:masterwork is:crafted

The copy’s state.

Inventory Not counted here

-is:locked

is:crafted -is:masterwork

is:invault is:postmaster

Where it is.

Inventory Not counted here

is:postmaster

is:invault is:weapon

tag:

Your tags: favorite, keep, junk, infuse, archive, or any and none.

Inventory Not counted here

tag:junk

tag:none is:weapon

notes:

Text in your notes on the item, hashtags included.

Inventory Not counted here

notes:pvp

notes:#raid

power:

Power level, with comparisons.

Inventory Not counted here

power:>=500

catalyst: inloadout: count: kills:

A few more: catalyst:missing, inloadout:none (in no loadout), count:>=3 copies, kills:>=1000 on the tracker, weaponlevel:>=20, dupe:traits, wishlist:trash, maxstatvalue:range.

Inventory Not counted here

catalyst:missing

inloadout:none is:weapon

Counts are for all 37837 items of the current manifest. Filters marked “Not counted here” need data this page doesn’t load (perks, stats, names, your inventory); they work in the header search or your inventory.

Database / Search syntax

Search syntax

One query language for the Database, the search box at the top of every page and your inventory. Click any example to try it here, then open it in the Database.

On this page

Basics5 What the item is9 Where it comes from3 Perks, stats and names6 Your inventory7

× 41 of 37,837 Open in Database

Annual Skate

Ancient Gospel

Luna's Howl

Not Forgotten

Zaouli's Bane (Harrowed)

Zaouli's Bane

Allegro-34

Trust

+33 more

Basics

Type a word, add a filter or two, take things out with a minus. A filter is a key, a colon and a value, with no spaces around the colon.

word

Part of a name or a type is enough: malfeasance, scout, shotgun. Capitals and accents don’t matter.

DatabaseHeader searchInventory

malfeasance 3 items

scout 283 items

a b

Add more terms and every one of them has to match.

DatabaseHeader searchInventory

is:exotic is:weapon 146 items

scout is:legendary 223 items

-term

A minus in front takes out whatever the term matches.

DatabaseHeader searchInventory

is:weapon -is:craftable 1,989 items

is:exotic -is:hunter 3,421 items

"two words"

Quotes keep a phrase together, in plain words or in a filter’s value.

DatabaseHeader searchInventory Not counted here

"ace of"

source:"iron banner"

a or b

Either side can match, and you can write and between terms too: and joins first, then or, then the spaces.

DatabaseHeader searchInventory Not counted here

is:shotgun or is:sniperrifle

is:solar is:glaive or is:arc is:fusionrifle

What the item is

is: does most of the work: hand it a rarity, a weapon type, an element or an ammo type and it knows what you mean.

is:weapon is:armor

All weapons, or all armor.

DatabaseHeader searchInventory

is:weapon 2,208 items

is:armor 6,029 items

is:exotic

By rarity: exotic, legendary, rare, uncommon or common.

DatabaseHeader searchInventory

is:exotic 3,649 items

is:legendary is:armor 4,978 items

is:handcannon

DatabaseHeader searchInventory

is:handcannon 403 items

is:glaive 81 items

is:solar

By damage type: kinetic, arc, solar, void, stasis or strand.

DatabaseHeader searchInventory

is:solar 430 items

is:strand is:weapon 166 items

is:heavy

By ammo: primary, special or heavy.

DatabaseHeader searchInventory

is:special 655 items

is:heavy 441 items

slot:helmet

Armor by slot. The Database’s box takes slot:helmet, slot:gauntlets, slot:chest, slot:leg and slot:classitem; the header search and your inventory spell them is:helmet, is:chest and so on.

DatabaseHeader searchInventory

slot:helmet 1,592 items

slot:chest is:exotic 79 items

is:hunter

Class-locked gear: titan, hunter or warlock.

DatabaseHeader searchInventory

is:warlock is:armor 2,009 items

is:exotic -is:hunter 3,421 items

is:craftable

Weapons with a pattern you can shape at the Enclave.

DatabaseHeader searchInventory

is:craftable 219 items

-is:craftable is:weapon 1,989 items

element: ammo: rarity: class: type:

Database

element:solar 430 items

type:pulse 333 items

Where it comes from

Matches the source text on the item and the season it arrived in.

source:

Part of the source Bungie writes on the item, as one word: raid, dungeon, nightfall, trials, ironbanner, xur, exoticquest and so on.

DatabaseHeader searchInventory

source:raid 555 items

source:dungeon is:weapon 47 items

season:

The season number the item was added in. The Database’s box takes one number; the header search and your inventory also take comparisons (season:>=24).

DatabaseHeader searchInventory

season:28 3,308 items

season:27 is:weapon 84 items

breaker:

Weapons with a built-in anti-champion trait: barrier, overload or unstoppable.

DatabaseHeader searchInventory

breaker:unstoppable 660 items

breaker:barrier is:exotic 51 items

Perks, stats and names

These read perks and stats, which the Database’s quick box doesn’t load. Use the search box at the top of the page (Ctrl K) or your inventory’s.

perk:

Weapons that can roll the perk (header search) or copies that have it (inventory). Part of the name is enough; perkname: means the same.

Header searchInventory Not counted here

perk:outlaw

perk:"kill clip"

exactperk:

Only the whole perk name.

Header searchInventory Not counted here

exactperk:frenzy

stat:

Header searchInventory Not counted here

stat:rpm:>=600

stat:range:>70 is:handcannon

basestat:

Like stat:, without masterwork, mods or catalyst. Weapons only for now.

Inventory Not counted here

basestat:range:>=60

name: exactname:

Match the name only (plain words also look at the type). exactname: wants the whole thing.

Header searchInventory Not counted here

name:"last word"

exactname:"Ace of Spades"

foundry:

Who made it: hakke, omolon, suros, veist, daito and the rest.

Header searchInventory Not counted here

foundry:suros

foundry:veist is:legendary

Your inventory

Signed in, the inventory’s search box reads your own items, tags and notes.

is:dupe

You own more than one copy.

Inventory Not counted here

is:dupe is:weapon

is:locked is:masterwork is:crafted

The copy’s state.

Inventory Not counted here

-is:locked

is:crafted -is:masterwork

is:invault is:postmaster

Where it is.

Inventory Not counted here

is:postmaster

is:invault is:weapon

tag:

Your tags: favorite, keep, junk, infuse, archive, or any and none.

Inventory Not counted here

tag:junk

tag:none is:weapon

notes:

Text in your notes on the item, hashtags included.

Inventory Not counted here

notes:pvp

notes:#raid

power:

Power level, with comparisons.

Inventory Not counted here

power:>=500

catalyst: inloadout: count: kills:

A few more: catalyst:missing, inloadout:none (in no loadout), count:>=3 copies, kills:>=1000 on the tracker, weaponlevel:>=20, dupe:traits, wishlist:trash, maxstatvalue:range.

Inventory Not counted here

catalyst:missing

inloadout:none is:weapon